AVEDEV function

AVEDEV(FirstParameter, OtherParameters...) AVEDEV(FirstParameter; OtherParameters...)

FirstParameter

Number or { Number }

The first parameter.

OtherParameters

Number or { Number } (accepts many)

Additional parameters.

Returns

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.

Examples

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.