Returns the average of the absolute deviations of data points from their mean.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: 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.