# AVEDEV

## Content

This function calculates the average of the absolute deviations of the specified values from their mean.

## Syntax

`AVEDEV(number1, [number2], ...)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *number1, number2, ...* | Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want the average of the absolute deviations. You can also use a single array or a reference to an array instead of arguments separated by commas. |

## Remarks

This is a measure of the variability in a data set.

## Examples

`AVEDEV(B5,L32,N25,D17)`
`AVEDEV(B1:B5)`
`AVEDEV(B1:B17,L1:L17,N2:N8)`
`AVEDEV(R5C2,R32C12,R25C15)` `AVEDEV(R1C2:R1C7)`
`AVEDEV(98,79,85)` gives the result 7.1111111111