STDEVPA(value1 [,value2] [..])

Returns the standard deviation based on an entire population (including logical values and text).

value1The first value.
value2(Optional) The second value.

Remarks

* The standard deviation is a measure of how widely values are dispersed from the average (or mean) value.
* You can also use a single array or a reference to an array instead of arguments separated by commas.
* Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
* The standard deviation is calculated using the "biased" or "n" method.
* You can have a maximum of 30 arguments.
* You can use the STDEVP function to exclude text and logical values.
* For the Microsoft documentation refer to support.office.com

 A
1=STDEVPA(10,20,30,40) = 11.180

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