What is the syntax for AVEDEV in Excel?

The syntax for AVEDEV is: =AVEDEV(number1, [number2], ...)

What are common errors with AVEDEV?

Ignores text and logical values

What is AVEDEV and when should I use it?

AVEDEV calculates the average absolute deviation from the mean - a measure of data spread. Unlike standard deviation, it doesn't square differences, making it less sensitive to outliers. Use it for robust variability measurement in quality control and data analysis.

What is the difference between AVEDEV and STDEV?

AVEDEV uses absolute deviations (|x-mean|), STDEV uses squared deviations ((x-mean)²). STDEV is more common in statistics and gives more weight to outliers. AVEDEV is simpler to interpret: 'on average, values differ from the mean by X'.

How do I interpret AVEDEV results?

AVEDEV tells you the average distance from the mean. If AVEDEV=5 and mean=100, values typically differ from 100 by about 5 units. Lower AVEDEV = more consistent data. Compare AVEDEV across datasets to assess relative variability.

Statistical

AVEDEV Function in Excel

Returns the average of the absolute deviations of data points from their mean.

Syntax

=AVEDEV(number1, [number2], ...)

Arguments

number1 (required): First number or range
number2 (optional): Additional numbers or ranges

Examples

=AVEDEV(A1:A10) - Average deviation - Result: Deviation value

AVEDEV for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

Ignores text and logical values

Use cases

Data variability
Statistical analysis
Quality control

Frequently asked questions

What is AVEDEV and when should I use it? AVEDEV calculates the average absolute deviation from the mean - a measure of data spread. Unlike standard deviation, it doesn't square differences, making it less sensitive to outliers. Use it for robust variability measurement in quality control and data analysis.
What is the difference between AVEDEV and STDEV? AVEDEV uses absolute deviations (|x-mean|), STDEV uses squared deviations ((x-mean)²). STDEV is more common in statistics and gives more weight to outliers. AVEDEV is simpler to interpret: 'on average, values differ from the mean by X'.
How do I interpret AVEDEV results? AVEDEV tells you the average distance from the mean. If AVEDEV=5 and mean=100, values typically differ from 100 by about 5 units. Lower AVEDEV = more consistent data. Compare AVEDEV across datasets to assess relative variability.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.