Article updated on March 27, 2018

The AVEDEV function calculates the average of the absolute deviations of data points from their mean.

The absolute deviation from the mean helps us understand how "spread out" the values in a data set are, it describes the variation in a data set.

Formula in cell D3:

=AVEDEV(B3:B7)

Excel Function Syntax

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

Arguments

number1 Required. A cell reference to number(s) or an array of numbers.
[number2] Optional. Up to 254 additional number arguments.

Comments

AVEDEV is a measure of the variability in a data set. Variability is the extent to which a distribution is stretched or squeezed.