AVEDEV(number1,number2,...)

Number1, number2, ...   are 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

• 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 equation for average deviation is: