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.