Skip to main content
MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
Show menu

AVERAGE DEVIATION function

Description

Average deviation function.

AVEDEV(range) calculates the average of the absolute difference of all values in range with their arithmetic mean.

It is calculated as follows:

$$\frac{\sum_{}^{}{|x-\bar{x}|}}{n} $$

The argument range can be a list of numbers, cell addresses, cell ranges (such as A1:A10).

Range can also be a matrix. In that case the function returns a matrix with one row and the same number of columns, with each element the AVEDEV of the corresponding column. If range is a row matrix, it is converted to a column matrix first.

Calculator

AVEDEV(  

Related functions