STDEV.S

Using the Excel STDEV.S Function

Summary

The Excel STDEV.S function returns an estimated standard deviation based on a sample, ignoring logical values and text. Standard deviation is a measure of how widely values are dispersed from the mean. The mean can be found using the AVERAGE function.

The STDEV.S replaces the STDEV function, which is currently available as a compatibility function. Microsoft recommends that users use the STDEV.S function.


Syntax

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

Syntax Breakdown

Number 1
Required. The first number that corresponds to a sample of a population. An array or reference to an array can also be used.

Number 2
Number 2 and subsequent number arguments are optional. The function can accept up to 255 arguments. An array or reference to an array can also be used.


Usage Notes

STDEV.S returns the standard deviation from data that is representative of a sample of a population, ignoring logical and text values. To calculate the standard deviation for an entire population, use STDEVP or STDEV.P.

Standard deviation is used to calculate the variance in a set of numbers compared to the average, or mean, of the numbers. STDEV.S is intended to estimate the standard deviation for a sample, not the entire population.

Standard deviation is calculated using the "n - 1" method.

Logical values and text representations of numbers that are entered directly into an argument are counted. The function ignores logical values, text representation of numbers, error values, and empty cells that are contained in an array or reference.

Use the STDEVA function to calculate logical values and text representation of numbers.

Variations of Standard Deviation Functions in Excel
Function Data Set Text & Logical Values
STDEV Sample Ignored
STDEVP Population Ignored
STDEV.S Sample Ignored
STDEV.P Population Ignored
STDEVA Sample Evaluated
STDEVPA Population Evaluated