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:
For example:
AVEDEV(2, 6, 9, 4, 5)
returns 1.84, which is the average deviation from the mean of 5.2.
See also: