Buzz
The AVEDEV function helps you calculate the average of the absolute deviations of specified data points from their mean value. It serves as a measure of variability within the dataset. To understand more about the syntax and usage of the AVEDEV function on spreadsheets, follow the article below.
AVEDEV Function and Its Usage
Guidance on Using AVEDEV Function in Excel - Illustrated Examples
Syntax: AVEDEV(number1, [number2], ...)
Where: number1, number2, … represent values for which absolute deviations are to be calculated and fall within the range of 1-->255 arguments
Note: - The provided data must be numbers, names, arrays, or references containing numerical values
- If the reference or array contains text, empty cells, or logical values (True, False), these values will be ignored;
- Cells with a value of 0 are still counted.
Example 1: The mean absolute deviation of the arguments in the formulas is:
- AVEDEV(1)=0
- AVEDEV(1,2)=0.5
Example 2: Calculating the mean absolute deviation of students' scores
- The AVEDEV function in Excel returns the average of the sum of the absolute differences between each score and the mean.
- The resulting absolute deviation is denoted as AVG
AVEDEV function in Excel isn't too difficult to understand, is it? Hopefully, this little trick will help you and successfully apply the AVEDEV function in analyzing data and information. You can also learn more about Excel functions through the article Compilation of Common Calculation Functions in Excel 2013.
