Article updated on February 22, 2018

The STDEV function calculates the standard deviation of a group of values. Standard deviation shows how much the values differ from the mean value of the group.

Formula in cell C3:


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.


There are newer better functions that may have improved accuracy, this function is available for compatibility with earlier Excel versions.