AVEDEV function
AVEDEV(First,
Other...) AVEDEV(First;
Other...)
First
Number or { Number }
The first parameter.
Other
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.
Returns 2. The mean is 4, and the absolute deviations from the mean are 3, 0 and 3, respectively. Blank values are ignored.