STDEVP Function in Excel – Calculate the Population Standard Deviation in Excel

STDEVP function in Excel calculates the population standard deviation of a supplied set of values. Standard Deviation, measures the deviation of number from the average value.

Population Standard Deviation is calculated using formula

STDEVP function in Excel 1

Where,

  • X takes each value in the set;
  • X̄ is the average of the set of values;
  • N is the number of values.

 

Syntax of STDEVP Function in Excel:

STDEVP (number1, [number2], … )

Where the number arguments are numeric values for which you want to calculate the population standard deviation.

 

Example of STDEVP Function in Excel

STDEVP function in Excel 2

The Above example calculates the population standard deviation of subject scores with formula

= STDEVP (A2:A13)

Which results in value 12.7986544

previous-small STDEVP Function in Excel                                                                                                                 next_small STDEVP Function in Excel