Home › Functions › Statistical › AVEDEV
fx
AVEDEV
Statistical  ·  Since: Excel 2003  ·  9 languages

Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.

🌐 Translations

English AVEDEV
Deutsch MITTELABW
Français ECART.MOYEN
Español DESVPROM
Italiano MEDIA.DEV
Português DESV.MÉDIO
Nederlands GEM.DEVIATIE
Polski ODCH.ŚREDNIE
Русский СРОТКЛ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

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

Arguments

number1 (required)
number2 (optional)

▶ Examples

=AVEDEV(A2:A8)

Related functions

Copied to clipboard