AVEDEV function
Summary
Returns the average of the absolute deviations of data points from their mean
Syntax
AVEDEV(number1, [number2], ...)
The AVEDEV function syntax has the following arguments:
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want the average of the absolute deviations. You can also use a single array or a reference to an array instead of arguments separated by commas.
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want the average of the absolute deviations. You can also use a single array or a reference to an array instead of arguments separated by commas.
Example
=AVEDEV(A2:A8)