Statistical
AVEDEV function: measure Mean Absolute Deviation without squaring outliers
Calculate the average absolute distance from the sample mean using AVEDEV when extreme outliers inflate standard deviation.
Linear distance from the mean vs squared STDEV
AVEDEV(number1, ...) computes the average of absolute deviations |x - mean| across numeric observations. Unlike STDEV, it weights extreme outliers linearly rather than squaring them.
Empty cells and text labels inside a range reference are ignored automatically; if no numbers exist, AVEDEV returns #NUM!.
=AVEDEV(B2:B6)Try the example
Use the original values or change them to test your understanding.