To determine the academic performance of students, students can apply 2 ways to calculate the average in excel below: the method of calculating the average by normal calculation and the method of calculating the average by the AVERAGE function in Excel.
How to calculate average in Excel
Take the example below:
We have a data table that includes student information, 3 grades in Math, Foreign Languages, Literature. We will take turns calculating the average score of these 3 subjects.
Note: You should format the result box as Average score only 2 numbers after the comma to get the most accurate result. On the Ribbon, under Number, select the Number format type.
Averaging method using conventional calculations
Because there are 3 subjects, if we calculate the average according to the average calculation formula, we will sum 3 numbers and divide by 3 to produce the result.
Type in cell I7 the calculation formula as follows: =(F7+G7+H7)/3 , and then press Enter.
Scroll down to copy the formula and complete the cells below.
Average calculation method by AVERAGE formula function
Calculating the average by normal calculation will probably be much simpler, but if you have to average with a large number of subjects, entering data is also very time-consuming, the AVERAGE function will help you solve this problem.
Syntax: AVERAGE(number1,number2,number3,…).
Where:
Number1: Required. As the first number, refer to the cell or area of data you want to average.
Number2,number3,… Options. The next numbers or additional data areas you want to average. The maximum is 255 numbers.
Back to the problem above.
Type in cell I7 Formula: =AVERAGE(F7:H7) and press Enter.
Scroll down to the cells below to copy the formula and complete the result.
You can compare and see the results of the 2 methods are exactly the same.
Above is a guide on how to calculate average in Excel using 2 methods. Hopefully, through the article, you can choose the average calculation method that suits you best.
https://thuthuat.taimienphi.vn/cach-tinh-trung-binh-trong-excel-30497n.aspx
In Excel, there are many other Excel basics that you can learn and apply in your math problems, some basic functions in Excel such as Min, Max often appear a lot. Good luck.