Functions
AVEDEV
Average of absolute deviations from the mean
Try it
When to use it
When should I use AVEDEV instead of STDEV?
Use AVEDEV to measure variability as the average absolute deviation from the mean; it is less sensitive to outliers than standard deviation and easier to interpret in plain terms.
Used in
Syntax
AVEDEV(value1,...)Examples
=AVEDEV(1,2,3,4,5,6,7,8,9,10) // => 2.5