Microsoft Office Tutorials and References
In Depth Information
AVEDEV
AVEDEV
AVEDEV returns the average of the absolute deviations of data points from their mean.
=AVEDEV(number1,number2,...)
The AVEDEV function is one of several functions used to measure the dispersion, or spread, in
a set of data. In Figure 11.1, the AVERAGE calculation shows that both departments have an
average age of 40. But the AVEDEV calculation clearly highlights a wider spread in ages for
Department B, the average deviation is 17 points from the mean (average).
NUMBER N Number N are the arguments, which can be cell references, arrays, or
range names. You can have up to 30 arguments. Blank cells or cells
containing text or logical values are ignored. Cells that contain a zero (0)
are included in the AVEDEV calculation.
The equation for the AVEDEV function takes 1 divided by the number of values in a data set
( n ), then multiplies that by the result of the sum of the absolute value of each data point
(x 1 , x 2 ,…,x n ) less the mean of the data set.
Figure 11.1
AVEDEV is an
indication of the dispersion