- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - AVEDEV Function
Description
The AVEDEV function returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.
Syntax
AVEDEV (number1, [number2] ...)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number1 | 1 to 255 arguments for which you want the average of the absolute deviations. | Required |
number2, ... | You can also use a single array or a reference to an array instead of arguments separated by commas. | Optional |
Notes
The equation for average deviation is −
$$\frac{1}{n}\sum \left | x-\bar{x} \right |$$
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.
Text representations of numbers that are supplied as a part of an array are not interpreted as numeric values by the AVEDEV function.
If none of the values supplied to the Function are numeric, AVEDEV returns #DIV/0! Error.
If any of the number arguments that are supplied directly to the Function are nonnumeric text strings, AVEDEV returns #VALUE! Error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016