Documentation/Calc Functions/AVEDEV

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

AVEDEV

Category:

Statistical Analysis

Summary:

Returns the average of the absolute deviations of data points from their mean. Displays the diffusion in a data set.

Syntax:

AVEDEV(Number1; Number2; ...; Number30)

Returns:

Arguments:

Number1, Number2, ..., Number30 are values or ranges that represent a sample. Each number can also be replaced by a reference.

Additional details:

Examples:

=AVEDEV(A1:A50)

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: