STDEV.P (First, Other...) STDEV.P (First; Other...)
First
The first number or array of numbers.
Other
Additional numbers or arrays of numbers.
Returns
Number 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.