STDEVPA |
STDEVPA(value1 [,value2] [..]) |
Returns the standard deviation based on an entire population (including logical values and text). |
value1 | The first value. |
value2 | (Optional) The second value. |
REMARKS |
* This function is identical to the STDEV.P function except that logical values, text and errors are included. * The standard deviation is a measure of how [[Dispersed]] the values are from the mean. * 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). * Arguments that are text or logical values are ignored. * You can have a maximum of 255 arguments. * You can use the STDEV.P function to return the standard deviation based on an entire population. * You can use the STDEV.S function to return the standard deviation based on a sample. * You can use the STDEVA function to return the standard deviation based on a sample (including logical values and text). * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - What is the standard deviation of 10,20,30,40. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top