STDEV

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

Returns the standard deviation based on a sample.

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

REMARKS
* This function is only available for backwards compatibility and should not be used.
* STDEV.S was added in Excel 2010 to replace this 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 have a maximum of 255 arguments.
* 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

 A
1=STDEV(10, 20, 30, 40) = 12.910
2=STDEV(1, 2, 3) = 1.000
3=STDEV(900000001, 900000002, 900000003) = 1.000

1 - What is the standard deviation of 10,20,30,40.
2 - What is the standard deviation of 1,2,3.
3 - What is the standard deviation of 900000001,900000002,900000003.

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