Calculating the Mean and Standard Deviation by Xls

Using Excel to calculate the Mean and Standard Deviation

To calculate SD and Mean it will take a awfully long steps so as to use manual calculation even it will be in no time and straightforward by victimization Microsoft stand out rather than applying manual equations

 

simple steps can offer in no time correct straightforward} technique of shrewd variance and mean still professional persons will use applied mathematics software system to calculate the SD &Mean by victimization SPSS and different software system

 
lets begin by victimization stand out for calculation

Open a blank Microsoft stand out and follow the following steps
Enter the following information into cells C2 to C10 : twelve,25,9,10,6,8,5,6,11

Calculating the Mean and Standard Deviation by Xls1

Calculating the Mean and Standard Deviation by Xls1

Calculating the Average Value

  • Click on cell C11 – the location where the AVERAGE function will be entered.
Calculating the Mean and Standard Deviation by Xls2

Calculating the Mean and Standard Deviation by Xls2

  • Click on the Formulas tab.
  • Choose insert function
  • Select category > Statistical to open the function drop down list.
  • Click on AVERAGE in the list to bring up the function’s
  • Click ok
Calculating the Mean and Standard Deviation by Xls3

Calculating the Mean and Standard Deviation by Xls3

  • New window will appear chose cells C2 to C10 to enter the range into the dialog box.
  • Click OK.
  • The answer 10.2222, which is the average value for the data in cells C2 to C10, should appear in cell C11.

Calculating the Standard Deviation

  • Click on cell C12 – the location where the STDEV function (standard deviation) will be entered.
  • Click on the Formulas tab.
  • Choose insert function
  • Select category > Statistical to open the function drop down list.
  • Click on STDEV in the list to bring up the function’s
Calculating the Mean and Standard Deviation by Xls4

Calculating the Mean and Standard Deviation by Xls4

  • Click ok
  • Choose cells from C2-C11
  • Click OK.
Calculating the Mean and Standard Deviation by Xls5

Calculating the Mean and Standard Deviation by Xls5

  • The answer 6.0369 should appear in cell C12.

 

Join our mailing list to receive our weekly updates