Standard Deviation Formulas

Learning Objectives:

  • Learning how to calculate standard deviation in Excel.
  • Learning the difference between STDEV.P and STDEV.S.

Standard Deviation

Excel has two functions to calculate the standard deviation of a dataset. The standard deviation measures how far a typical observation is from the average of the data.

STDEV.P

This function calculates the standard deviation for the entire population. It is typed `=STDEV.P`

Excel STDEV.P example

STDEV.S

This function calculates the standard deviation for the entire sample. It is typed `=STDEV.S`

Excel STDEV.S example

← Previous Lesson Back to Lessons Next Lesson →