AVEDEV:
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.
AVEDEV takes
1 required argument and
254 optional arguments:
Syntax: AVEDEV(number1,
[number2], ...
)
Using the AVEDEV function:
The arguments for the AVEDEV function are:
Argument

Required?

Description

number1 
Required 
The first number. 
number2, ... 
Optional 
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.