AVEDEV Function in Excel – Calculate Average Deviation in Excel

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:

AVEDEV function in Excel 1

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

AVEDEV function in Excel 2

The Above example calculates the average deviation of monthly sales for 12 months with formula

= AVEDEV( A2:A13)

Which results in value 520.8333

previous AVEDEV Function in Excel                                                                                                                next AVEDEV Function in Excel