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
- 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:
Where the number arguments are numeric values for which you want to calculate the population standard deviation.
Example of STDEVP Function in Excel
The Above example calculates the population standard deviation of subject scores with formula
= STDEVP (A2:A13)
Which results in value 12.7986544