=AVEDEV(number1, [number2], ...)
=AVEDEV(B5:B10)
The AVEDEV function can be used to calculate the mean of the absolute values of deviations from the mean. For example, this formula will return the mean of the absolute values of deviations from the mean for the data in the range B5:B10.
The AVEDEV function is a useful tool for calculating the average absolute deviation of numbers in a data set. It takes numerical arguments, including numbers, names, arrays, and references, and ignores empty cells, text, and logical values.