Navigation:  Formulas and functions > Functions from A to Z > AVEDEV (average deviation)

Syntax:

AVEDEV(Number1 [, Number2, Number3 ...])

Description:

This returns the average deviation of the given numbers from their mean.

Number1, Number2, etc., are single values, cell ranges, or arrays containing the values to be evaluated.

If this function refers to empty cells, they are ignored. Likewise, cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus taken into account.

Example:

AVEDEV(2, 2, 2, 2) returns 0

AVEDEV(2, 2, 2, 3) returns 0.375

See also:

DEVSQ, STDEV.S/STDEV, VAR.S/VAR