AVEDEV

Definition: AVEDEV is a function that returns the average of the absolute deviations of data points from their mean.

Syntax: =AVEDEV(number1, [number2], …)

Situation: This formula is suitable when you need to find the average deviation of data points from their mean.

Example: If you have a list of test scores in cells A1 to A10, the average deviation from the mean can be found using the formula =AVEDEV(A1:A10). If the mean is 80 and the scores are [75, 85, 90, 70, 80, 85, 80, 75, 90, 80], the average deviation is 5.6.