Author: Oscar Cronquist Article last updated on May 11, 2022

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:


Excel Function Syntax

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


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


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