The Excel AVEDEV function calculates the average deviation of a supplied set of values.
Syntax: AVEDEV( number1, [number2], … )
where the arguments, number1, [number2], etc, are one or more numerical values or references to cells containing numbers. If you are using Excel 2007 or Excel 2010, you can enter up to 255 number arguments to the function. However, in Excel 2003, the function can only accept up to 30 number arguments.
Note that the Avedev function ignores logical values and text values (including text representations of numbers) if these are supplied as part of an array of cells. However, the function does count logical values and text representations of numbers that supplied directly to the function.
Avedev Function Example
|#DIV/0!||–||Occurs if none of the values supplied to the function are numeric
(Note that text representations of numbers, that are supplied as a part of an array, are not interpreted as numeric values by the Avedev function)
|#VALUE!||–||Occurs if any values that are supplied directly to the Avedev function are text values that cannot be interpreted as numeric values.|