Sunday, 10 November 2013

How to calculate mean and standard deviation in Excel

In this article you will learn how to calculate mean and standard deviation (STDEV) values in Microsoft excel, I have followed very easy and simple method for your easy understand.

How to calculate mean 

1.  Type your value and keep the courser where you want to calculate mean 
2.  Click on "Formulas" and then click on "Insert Function"
3.  A dialog box will appear Click on "Or Select a Category" and select the "Statistical" after this select function click on "AVERAGE"
 4.  Click "OK" one more dialog box will appear, "number1" insert the column number from where to upto you want calculate mean and then click "OK" 
the mean value appear your selected cell

How to calculate standard derivation (STDEV)

1.  Type your value and keep the courser where you want to calculate standard deviation
2.  Click on "Formulas" and then click on "Insert Function"
3.  A dialog box will appear Click on "Or Select a Category" and select the "Statistical" after this select function click on "STDEV".
 4.  Click "OK" one more dialog box will appear, "number1" insert the column number from where to upto you want calculate standard deviation and then click "OK"

Now you got your mean and standard deviation value 
More detail see this video....dnt forget like, comments & subscribe

No comments:

Popular Posts