Article updated on March 13, 2018

The STDEV.S function returns standard deviation based on a sample of the entire population.

The standard deviation is how widely numbers are distributed around the average value.

Formula in cell D3:


Excel Function Syntax

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


number1 Required. The first number argument that represents a sample of the population.
[number2] Optional. Up to 253 additional number arguments.


The STDEV.S function ignores logical values and text values.

For large sample sizes, STDEV.S and STDEV.P return approximately equal values.