Syntax:
AVEDEV(list)
Returns the average deviation of the values in the list from their arithmetic mean. list may be an array, a range of cells, or a comma-separated list of values.
The equation used is:
( Σi=n |xi − x| ) ÷ n
where xi is each value and n is the number of values.
Example:
AVEDEV(A1:A15)
returns the average deviation of the contents of cells in the range A1
to A15
from their arithmetic mean.
Added in 1.36.