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

Returns the standard deviation based on a sample.

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

* This function was added in Excel 2010 to replace the STDEV 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 30 arguments.
* You can use the STDEVA function to count any arguments that are text or logical values.
* For the Microsoft documentation refer to

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

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