< Go Back

Excel AVEDEV Function

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

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar