Excel

Menu

1

How to Create an Excel Budget

2

How to Create an Accounting Spreadsheet in Excel

3

Comparing Budget and Accounting in Excel

4

Excel Template for a Loan Amortization Schedule

5

Excel Template for a Fixed-rate Mortgage

6

Excel Template for Calculating Your Monthly Paycheck

7

How Do You Make a Frequency Table in Excel?

8

How to Make a Relative Frequency Table in Excel

9

How to Make a Cumulative Frequency Table in Excel

10

How to Create a Bar Chart in Excel

11

How to Create a Pie Chart in Excel

12

How to Create a Line Chart in Excel

13

How to Create a Box Plot in Excel

14

How to Create a Histogram in Excel

15

How to Calculate Average or Mean in Excel

16

How to Find Mean of Grouped Data in Excel

17

How to Calculate Standard Deviation in Excel

Here is a guide on how to calculate the standard deviation in a collection of data.

Excel Instruction

Calculating the Standard Deviation

1.: Enter all the data values into Excel.
2.: Choose an empty cell and enter the Excel command

=STDEV(
3.: Highlight the range of cells containing the data and press Enter. You have now found the standard deviation of the data!

Example 1

The Ukrainian national gymnastics team members Anoushka, Alexandra, Triana, Mirella, Jana and Fiona are all good friends. Anoushka is $167 cm$ tall, Alexandra is $159 cm$ tall, Triana is $162 cm$ tall, Mirella is $155 cm$ tall, Jana is $160 cm$ tall and Fiona is $157 cm$ tall. Find the standard deviation of the girls’ heights.

1.

Enter the heights of the gymnasts in Excel.

2.

Click on an empty cell and write the formula:

=STDEV(

3.

Highlight all the cells containing the gymnasts’ heights and press Enter. You’ll get the following table:

Spreadsheet in Excel presenting height data and standard deviation

With formulas:

Spreadsheet in Excel showing formula for standard deviation

You can now see that the standard deviation of the gymnasts’ heights is $4.2$ cm.

Want to know more?Sign UpIt's free!

Done