Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format

Summary: Calculates the average of the absolute deviations of the values in list.

Syntax: AVEDEV( { NumberSequenceList N }+ )

Returns: Number

Constraints: None.

Semantics: For a list N containing n numbers x1 to xn, with average x, AVEDEV(N) is equal to:

\frac{1}{n} \sum_{i = 1}^{n} | (x_{i} - \bar{x}) |