# Documentation/Calc Functions/AVEDEV

Jump to navigation Jump to search

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

AVEDEV