AVEDEV
Returns the average of the absolute deviations of data points from their mean
Syntax
AVEDEV(number1, [number2], ...)
Parameters
- number1: Required. The first number, cell reference, or range for which you want the average of the absolute deviations
- number2: Optional. Additional numbers, cell references, or ranges, up to 255
Example
=AVEDEV(A1:A10)