AVEDEV

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 |xix| ) ÷ 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 2.00.