Author: Oscar Cronquist Article last updated on June 15, 2018

The STDEV.P function returns standard deviation based on the entire population.

The standard deviation is how widely numbers are distributed around the average value.

Formula in cell D3:


Excel Function Syntax

STDEV.P(number1, [number2], ...)


number1 Required. The first number argument that represents a population.
[number2] Optional. Up to 253 additional number arguments.


The STDEV.P function ignores logical values and text values.

For large sample sizes, STDEV.S and STDEV.P return approximately equal values.