AVEDEV function in Excel calculates the average deviation of a supplied set of values. Average Deviation, measures the deviation of a set of points from their average.
The Average Deviation is calculated by the following equation:
Where,
- X takes each value in the set;
- X̄ is the average of the set of values;
- N is the number of values.
Syntax of AVEDEV Function in Excel:
AVEDEV( number1, [number2], … )
Where the number arguments are numeric values for which you want to find the average deviation of.
Example of AVEDEV Function in Excel
The Above example calculates the average deviation of monthly sales for 12 months with formula
= AVEDEV( A2:A13)
Which results in value 520.8333