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

Returns the standard deviation based on an entire population.

number1The first number.
number2(Optional) The second number.

Remarks

* Added in Excel 2010.
* This function replaces the STDEVP function.
* The standard deviation is a measure of how widely values are dispersed from the average (or mean) value.
* Arguments that are text or logical values are ignored.
* You can also use a single array or a reference to an array instead of arguments separated by commas.
* The standard deviation is calculated using the "biased" or "n" method.
* You can have a maximum of 30 arguments.
* You can use the STDEVPA function to count any arguments that are text or logical values.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=STDEV.P(10,20,30,40) = 11.180

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top