The STDEV.S function calculates the sample standard deviation of a supplied set of values.
- This function is new in Excel 2010 and so is not available in earlier versions of Excel. However, the STDEV.S function is simply a new version of the STDEV function that is available in earlier versions of Excel.
|num_1||The first number argument corresponding to a sample of a population|
|[num_2], …||Optional. Additional number arguments 2 to 254 corresponding to a sample of a population|
Note: Arguments to the STDEV.S function can be input as cell ranges, individual numbers, or number arrays, e.g., in the table below:
- The result in J3 uses a range of cells (see K3)
- The result in J4 uses cell ranges plus individual numbers (see K4)
- The result in J5 uses cell ranges plus a number array (see K5)
- The STDEV.S function is used when calculating the standard deviation for a sample of a population. If you are calculating the standard deviation of an entire population, you need to use the STDEV.P function.
- The STDEV.S function ignores text values and logical values if these are supplied as part of an array. If you want a function that includes text and logical values in the calculation, consider using the STDEVA function.
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any values that are supplied directly to the function are text values that cannot be interpreted as numeric values|
|#DIV/0!||Occurs if fewer than two numeric values are supplied to the function
The Standard Deviation is a statistical measure, that is closely linked to the Variance. Both measures are commonly used across a set of values, to identify the amount that the values differ, or deviate, from the average value.
When your data set is a sample of a population, rather than an entire population, you should use a slightly modified form of the Standard Deviation, known as the Sample Standard Deviation. The equation for this is:
- n is the number of values.