Returns the average of the absolute deviations of data points from their mean. Displays the diffusion in a data set.
AVEDEV(Number 1 [; Number 2 [; … [; Number 255]]])
Returns a real number which is the average of the absolute deviations of Number 1, Number 2, ..., Number 255 from their mean.
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.
The formula for average absolute deviation is:
where xi represents the Number i and x bar is their mean.
|=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:
Equivalent Excel functions: