AVEDEV Function
Returns the average absolute distance of numbers from their mean.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
AVEDEV finds the average, measures how far each number is from it (ignoring whether above or below), then averages those distances.
It answers "how far off is a typical value?" in the data's own units, and is easier to explain than standard deviation. Outliers affect it less, because distances aren't squared.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A number, cell or range. |
| number2, … | No | Up to 254 more numbers, cells or ranges. |
Examples
Example 1 — Typical distance from the average
On average, each rep's sales are this far from the $53,636 mean.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Measure | Result |
| 2 | Ana | North | 62000 | Avg deviation | 7926.53 |
| 3 | Ben | South | 48500 | Std deviation | 9567.31 |
| 4 | Cy | North | 50000 | ||
| 5 | Di | East | 71250 | ||
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
It's smaller than the standard deviation, which gives extra weight to the far-away values such as Di's.
Common mistakes
- #NUM! The range contains no numbers.
- Text and blanks are skipped. Zeros count, so a 0 standing in for missing data increases the result.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.