AVEDEV

AVEDEV - This function returns the average of the absolute deviations of data points from their mean.

Syntax:

AVEDEV(number1;number2; ... ;number30)

number1, number2, ..., number30 are values or ranges that represent a sample.

Example:

We want to find the average of the absolute deviation of the following test scores. See the screen shot.

=AVEDEV(B2:B7) will return 9.78

Screen shot: