Loading

Find standard deviation and variance of a column

yash patel

Hello,
How do I find variance and standard deviation of a column in a database?
For my project, I have to compute normal distribution on each column of a data base. I have tried looking around but can't find any helpful solutions to this problem.
Now, I am not very familiar with normal distribution either, so any help would be much appreciated and valuable.

How do I approach this problem ? I'm using c# in .NET and Mysql database.

Thank you.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jaganathan Bantheswaran13y ago
Hi,

Once you have your table values you can select the particular column values to be calculated the mean, variance & deviation.

var values = (from val in yourtable select val.YourColumn).ToList();

then follow the link for the calculation.

http://www.martijnkooij.nl/2013/04/csharp-math-mean-variance-and-standard-deviation/