AVEDEV
Returns the average of the absolute deviations of data points from their mean.
StatisticalStatistics & Analysis
What it does
Calculates the average of the absolute deviations from the mean.
Syntax
AVEDEV(number1, [number2], ...)
Arguments
number1(number) — First number or range.
Examples
Average deviation
Calculate AVEDEV for a set of scores.
FORMULA
=AVEDEV(A2:A6)
RESULT
2.8
SAMPLE DATA
| A | |
|---|---|
| 1 | Scores |
| 2 | 10 |
| 3 | 12 |
| 4 | 8 |
| 5 | 15 |
| 6 | 18 |