Article updated on March 13, 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:

=STDEV.P(B3:B12)

Excel Function Syntax

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

Arguments

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

Comments

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

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