Returns the average of the absolute deviations of data points from their mean.
Syntax
AVEDEV(number1, [number2], ...)Argumente
number1erforderlich
The first number or range of numbers for which you want the average of absolute deviations.
number2optional
Additional numbers or ranges, up to 255 arguments.
The AVEDEV function measures the variability in a data set. It calculates the average of the absolute differences between each data point and the arithmetic mean of the entire set.
=AVEDEV(10, 12, 14, 16)→2The mean is 13. The absolute deviations are |10-13|=3, |12-13|=1, |14-13|=1, |16-13|=3. The average of (3,1,1,3) is 2.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =AVEDEV( followed by your data range or numbers, then close the parenthesis.
Calculate
Press Enter to see the average absolute deviation.
AVEDEV uses absolute differences from the mean, whereas STDEV uses squared differences, making STDEV more sensitive to outliers.