Excel has several built-in functions that measure variability in a data set, and AVEDEV is one of them. AVEDEV returns the average of the absolute deviations of data points relative to the mean. This tutorial will assist Excel users in using Avedev to measure variability of the given data.
Figure 1. Final result of the AVEDEV function
Syntax of the AVEDEV Function
=AVEDEV(number1, [number2],...)
Or
=AVEDEV(array)
The arguments of the AVEDEV function are:
- number 1, number2 – only number1 is required; subsequent numbers are optional
- The argument could also be an array; this is especially useful when dealing with large data sets, so we don’t have to input the numbers one by one
Setting up the Data for the AVEDEV Function
Figure 2. Sample data for use in the AVEDEV formula
The data that we will use is a list of numbers in column B, and the result for the Avedev function in column D.
Calculate average absolute deviation using Avedev
We want to calculate the average of absolute deviations of the numbers using Avedev.
Follow these steps:
Step 1. Select cell D3
Step 2. Enter the formula: =
AVEDEV(B3,B4,B5,B6,B7)
Step 3. Press Enter
The result in cell D3 is 2.24, which is the average of the absolute deviations of the numbers compared to the mean.
Figure 3. Entering the formula for the AVEDEV function
Alternative formula using an array
There is an alternative formula to calculate with Avedev using an array:
Step 1. Select cell D4
Step 2. Enter the formula: =
AVEDEV(B3:B7)
Step 3. Press Enter
Figure 4. Using the AVEDEV formula with an array
B3:B7 is the array containing the numbers that we want to compute for average absolute deviation. The result in cell D4 is the same as in the previous example, which is 2.24.
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.
Leave a Comment