The following article details in detail how to use AVEDEV function, the function of calculating the average of absolute deviation in Excel.
Description: The function returns the average absolute deviation between a given data point and the average value of the population. The function is a measure of the variability of a dataset.
Syntax: AVEDEV (number1, [number2], .) .
Inside:
- number1, number2, . : are the arguments to calculate the standard deviation, where number1 is the required parameter, the optional next parameters and the number of parameters is from 1 to 255 parameters.
Attention:
- AVEDEV function depends on the input data unit.
- The arguments must be a number, name or reference array that contains numeric values.
- If the parameter is a logical value or presents a number as a text you want to not be error, you should type directly into the list of arguments.
- Arguments that contain logical values, text, and blank cells are ignored, but cells with a value of 0 are still counted.
- Equation of AVEDEV function :
For example:
Evaluate students' level of subjects evenly by subject grades.
In the cell to calculate the absolute deviation between the subjects that enter the formula: = AVEDEV (E7: G7) .
Press Enter -> the absolute deviation result between 3 subjects of the student is:
Similarly copying the formula for the remaining data cells results:
Here the absolute difference between subjects is smaller, indicating that students learn very 3 subjects of math, physics, chemistry such as Hoang, Manh. The greater the absolute deviation, the more likely it is that she has not yet studied subjects like Hoang and Van Anh.
The above is a common usage and case of AVEDEV function .
Good luck!