Calculates the average of the deviations of data points from their mean.
Sample Usage
AVEDEV(1,2,3,4,5,6,7,8,9,10)
AVEDEV(A1:B2)
Syntax
AVEDEV(value1, [value2, ...])
- value1 - Values or ranges that represent a sample.
- value2, .. - [OPTIONAL] Additional values or ranges.
Examples
AVEDEV(1,2,3,4,5,6,7,8,9,10) returns a value of 2.5.
AVEDEV(A1:B2) returns the average of the absolute deviations of the numbers in cells A1:B2 from their mean.
Notes
- AVEDEV will ignore any text values in value arguments.