Calculates the average of the deviations of data points from their mean.
AVEDEV(value1, [value2, ...])
- value1 - Values or ranges that represent a sample.
- value2, .. - [OPTIONAL] Additional values or ranges.
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.
- AVEDEV will ignore any text values in value arguments.