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:

=STDEV(B3:B14)

Excel Function Syntax

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

Arguments

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.

Comments

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