AVEDEV function

AVEDEV (First, Other...) AVEDEV (First; Other...)

First

The first number or array of numbers.

Additional numbers or arrays of numbers.

Number Number

The average of the absolute deviations of values from their mean.

Returns the average of the absolute deviations of values from their mean. The values are given as numbers or as number arrays.

AVEDEV (1, 4, 7)

AVEDEV (1; 4; 7)

Returns 2. The mean is 4, and the absolute deviations from the mean are 3, 0 and 3, respectively.

AVEDEV (1, 4, BLANK (), 7)

AVEDEV (1; 4; BLANK (); 7)

Returns 2. The mean is 4, and the absolute deviations from the mean are 3, 0 and 3, respectively. Blank values are ignored.

AVEDEV ({ 1, 4 }, BLANK (), 7)

AVEDEV ({ 1; 4 }; BLANK (); 7)

Returns 2. The mean is 4, and the absolute deviations from the mean are 3, 0 and 3, respectively. Arrays are supported. Blank values are ignored.