KNOWING EXCEL AVEDEV FUNCTION
Are you in the process of acquiring knowledge of using Excel to perform several basic operations? This article would show you how to easily use the Excel AVEDEV function to perform average deviation operation.
What is Excel AVEDEV function?
Excel AVEDEV function is a Microsoft Excel operation that calculates the average of the absolute deviations of a set of data provided.
Syntax of Excel AVEDEV function
AVEDEV (number 1, [number 2], … [number n])
The number arguments indicate the numerical values of the set of data to be used in the operation while n is the number of available data.
Standard Formula for AVEDEV calculation
The formula used by excel in performing the AVEDEV operation is:
Where,
X= each value present in the set of data
x = average value of the set of data
N = number of values in the data
Example to illustrate Excel AVEDEV Function
The table below contains some set of data that would be used to illustrate how the average deviation can be calculated using Microsoft Excel
Runs |
Values |
1 |
24 |
2 |
56 |
3 |
12.46 |
4 |
49 |
5 |
9 |
- Step 1
Open your Excel worksheet and you’ll observe a blank worksheet
Note: Excel 2013 is used for this illustration meanwhile same procedure is applicable to other versions of Excel.
- Step 2
Input the set of values. You can start from any row and column of your choice.
Figure 1. Worksheet with an inputted set of values
- Step 3
Choose the AVEDEV operation. This can be done clicking on “fx” which will bring a display like the below image. From the set of operations, select “AVEDEV” and press “ok”. If you can’t easily find “AVEDEV” Type it directly into “search for function.”
Figure 2. Choosing the AVEDEV function
After pressing “ok” the below display would pop up
Figure 3. Pop up
- Step 4
Define the syntax. Excel would automatically write out the function arguments once you highlight the set of values to be used for the operation.
Figure 4. Highlighting the set of values to obtain the average deviation
- Step 5
Press the “ok” icon and you’ll have the average deviation of the highlighted set of values.
Figure 5. Calculated standard deviation for the set of values
Syntax = =AVEDEV(R[5]C[2]:R[10]C[2])
Average deviation = 17.9264
Leave a Comment