The Excel STDEV function returns the standard deviation for data that represents a sample. To calculate the standard deviation for an entire population, use STDEVP or STDEV.P.
Get the standard deviation in a sample
Estimated standard deviation
=STDEV (number1, [number2], ...)
number1 - First number or reference in the sample.
number2 - [optional] Second number or reference.
The STDEV function calculates the standard deviation for a sample set of data. Standard deviation measures how much variance there is in a set of numbers compared to the average (mean) of the numbers. The STDEV function is meant to estimate standard deviation in a sample. If data represents an entire population, use the STDEVP function.
To calculate the standard deviation of a data set, you can use the STEDV.S or STEDV.P function, depending on whether the data set is a sample, or represents the entire population. In the example shown, the formulas in...