Returns the average of the absolute deviations of data points from their mean.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
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)Ergebnis: 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.