The STDEV.S (STDEV S) is a Statistical function that calculates and returns the standard deviation for a sample of data. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). The STDEV.S calculates standard deviation using the “n-1” method. In this guide, we’re going to show you how to use the STDEV.S function and also go over some tips and error handling methods.
- Excel 2010 and later
|number1||The first number or reference in the sample of the population. You can also use an array instead of multiple arguments.|
|[number2], …||Other numbers of the population up to 254 arguments.|
The standard deviation is a measure of how widely values are dispersed from the average value (the mean). The STDEV.S function assumes that given arguments are a sample of the population. The function uses the following formula:
where x is the average (mean) and n is the sample size.
All you need to do is to supply your dataset as arguments.
- Use STDEV.S to calculate the standard deviation for a sample of the population.
- The function calculates the standard deviation by using the “n-1” method.
- The STDEV.P function uses “n” method to calculate the standard deviation.
- You can use the AVERAGE function to calculate the mean of a data set.
- The STDEV is the older version of this function. Refrain from using STDEV.
- Arguments can either be numbers or names, arrays, or references that contain numbers.
- Logical values, and text representations of numbers that you type directly into the list of arguments are counted.
- If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the STDEVA function.