Article updated on February 23, 2018

The STDEVA function estimates the standard deviation from a sample of values. Standard deviation shows how much the values differ from the mean value of the group.

If your data contains the entire population use instead the STDEVPA function to calculate the standard deviation.

Formula in cell D3:


Excel Function Syntax



number1 Required. This argument can be an array of constants or a cell reference to a group of values.
[number2] Optional. Up to 254 additional arguments.


Use the STDEV function if you don't want to include boolean values and text that represents numbers in your calculation.