Documentation/Calc Functions/AVEDEV
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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(Number 1 [; Number 2 [; … [; Number 255]]])
Returns:
Returns a real number which is the average of the absolute deviations of Number 1, Number 2, ..., Number 255 from their mean.
Arguments:
Number 1, Number 2, ..., Number 255 are real numbers, references to cells or to cell ranges of numbers.
- If any of the arguments contain text value either being passed directly or with double quotes then the function returns a name(#NAME?) error or a simple error value(Err:504), respectively.
- If a reference to a cell containing text is passed as an argument then the function calculates average absolute deviation ignoring that value.
Additional details:
The formula for average absolute deviation is:
where xi represents the Number i and x bar is their mean.
Examples:
Formula | Description | Returns |
---|---|---|
=AVEDEV(A1:A5) where A1,A2,A3,A4,A5 are 1,2,3,4,5 | returns average of the absolute deviations of 1,2,3,4,5 from their mean | 1.2 |
=AVEDEV(1.5;-2;0;-4.2) | returns average of the absolute deviations of 1.5,-2,0,-4.2 from their mean | 1.925 |
Related LibreOffice functions:
ODF standard:
Equivalent Excel functions:
AVEDEV