## How to use the STDEV.S function

*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]*, ...)

### Arguments

number1 |
Required. The first number argument that represents a sample of the population. |

[number2] |
Optional. Up to 253 additional number arguments. |

### Comments

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

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

### Functions in 'Statistical'

The STDEV.S function function is one of many functions in the 'Statistical' category.