Returns the average of the absolute deviations of data points from their mean.
Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.
AVEDEV(number1, [number2], ...)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)Resultat: 2
The 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.
AVEDEV uses absolute differences from the mean, whereas STDEV uses squared differences, making STDEV more sensitive to outliers.