This function calculates the average of the absolute deviations of the specified values from their mean.
AVEDEV(value1,value2,...)
AVEDEV(array)
AVEDEV(array1,array2,...)
Each argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.
This is a measure of the variability in a data set.
Accepts numeric data for all arguments. Returns numeric data.
AVEDEV(B5,L32,N25,D17)
AVEDEV(B1:B5)
AVEDEV(B1:B17,L1:L17,N2:N8)
AVEDEV(R5C2,R32C12,R25C15) AVEDEV(R1C2:R1C7)
AVEDEV(98,79,85) gives the result 7.1111111111