Returns the average of the absolute deviations of data points from their mean.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
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)Kết quả: 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.