Buzz
To assess the academic performance of students, we can apply two methods of calculating average in Excel, namely the conventional calculation method and the AVERAGE function method.
Calculating Average in Excel
Illustrative Example:
We have a data table containing information about students, scores in 3 subjects: Math, Foreign Language, Literature. Let's proceed to calculate the average scores for these 3 subjects.
Note: Format the result cell as the Average Score, keeping only 2 decimal places for the most accurate result. On the Ribbon, under the Number section, select the Number format.
Conventional Calculation Method for Averaging
Since there are 3 subjects, using the conventional averaging formula involves summing up the 3 numbers and dividing by 3 to obtain the result.
Input the formula into cell I7 as follows: =(F7+G7+H7)/3 then press Enter.
Drag down to copy the formula and complete the cells below.
AVERAGE function formula method for calculating average
Calculating average through conventional computation may seem much simpler; however, if you need to average a large number of subjects, data entry can be time-consuming. The AVERAGE function will help you address this issue.
Syntax: AVERAGE(number1,number2,number3,...).
Where:
Number1: Mandatory. It is the first number, referencing the cell or data range you want to calculate the average for.
Number2, number3,... Optional. The subsequent numbers or additional data range you want to average. Maximum is 255 numbers.
Returning to the above problem.
Input into cell I7 the formula: =AVERAGE(F7:H7) and press Enter.
Drag down the cells below to copy the formula and complete the results.
You can compare and observe that the results of the two methods are exactly the same.
Above is a guide on how to calculate averages in Excel using two methods. It is hoped that through this article, you can choose the averaging method that suits you best.
In Excel, there are many other basic functions that you can explore and apply in your problems. Some common Excel functions like Min and Max often come in handy. Wishing you success.
