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
