Excel functions / Statistics
AVEDEV function
The average distance of the values from their mean: a plain measure of how spread out they are.
Syntax
=AVEDEV(number1, [number2], …)
Arguments
number: Numbers, cells or ranges.
When to use it
AVEDEV gives the average of how far each value is from the mean, ignoring the sign. It is a plain measure of spread that a large outlier affects less than the standard deviation.
Examples
The spread of a small list
A B C 1 Value 2 4 1.02 3 5 4 6 5 7 6 5 7 4 8 3 In C2:
=AVEDEV(A2:A8)→ 1.02
Common mistakes
- Not the standard deviation. AVEDEV and STDEV measure spread differently and give different numbers.
AVEDEV in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: PRŮMODCHYLKA
- Danish: MAD
- Dutch: GEM.DEVIATIE
- Finnish: KESKIPOIKKEAMA
- French: ECART.MOYEN
- German: MITTELABW
- Hungarian: ÁTL.ELTÉRÉS
- Italian: MEDIA.DEV
- Norwegian: GJENNOMSNITTSAVVIK
- Polish: ODCH.ŚREDNIE
- Portuguese (Brazil): DESV.MÉDIO
- Portuguese (Portugal): DESV.MÉDIO
- Russian: СРОТКЛ
- Spanish: DESVPROM
- Swedish: MEDELAVV
- Turkish: ORTSAP