STDEV.P function

STDEV.P(FirstParameter, OtherParameters...) STDEV.P(FirstParameter; OtherParameters...)

FirstParameter

Number or { Number }

The first parameter.

OtherParameters

Number or { Number } (accepts many)

Additional parameters.

Returns

Number

The population standard deviation of the parameters.

Returns the population standard deviation of the parameters. STDEV.P(3, 4, 5, 6, 2, 3, 1)STDEV.P(3; 4; 5; 6; 2; 3; 1) returns roughly 1.6.

STDEV.P only accepts numbers, or number arrays. Use STDEVPA instead of you also need to evaluate logical values and text strings representing numbers.

Example

STDEV.P(3, 4, 5, 6, 2, 3, 1)STDEV.P(3; 4; 5; 6; 2; 3; 1)

Returns roughly 1.6.