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

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

  1. The spread of a small list

    ABC
    1Value
    241.02
    35
    46
    57
    65
    74
    83

    In C2: =AVEDEV(A2:A8) → 1.02

    Try this example

Common mistakes

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.

Translate a whole formula

Try AVEDEV in the playground

Related functions