Returns the average of the absolute deviations of data points from their mean
The AVEDEV returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.
1 required argument and
254 optional arguments:
Using the AVEDEV function:
The arguments for the AVEDEV function are:
||The first number.
||Up to 254 additional numbers 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.
|• AVEDEV is influenced by the unit of measurement in the input data.
|• Arguments must either be numbers or be names, arrays, or references that contain numbers.
|• Logical values and text representations of numbers that you type directly into the list of arguments are counted.
|• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however,
cells with the value zero are included.
The AVEDEV returns the average of the absolute deviations of data points from their mean.