AVEDEV(list)

The AVEDEV function calculates the average deviations of numbers in a list from the mean value of the list. The formula for average deviation is:

image\ebx_3720456.gif

For example:

AVEDEV(2, 6, 9, 4, 5)

returns 1.84, which is the average deviation from the mean of 5.2.

See also:

ABS(x)

AVERAGE(list) or AVG(list)

Other statistical functions