STDEVA

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

Returns the standard deviation based on a sample (including logical values and text).

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

REMARKS
* For an illustrated example refer to the [[Disperson]] page.
* 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 included.
* You can have a maximum of 255 arguments.
* You can use the STDEV.S function to return the standard deviation based on a sample.
* You can use the STDEVPA function to return the standard deviation based on an entire population (including logical values and text).
* You can use the STDEV.P function to return the standard deviation based on an entire population.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=STDEVA(10,20,30,40) = 12.910

1 - What is the standard deviation of 10,20,30,40.

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