Home » Microsoft Excel 2003 » 05 - Working With Formulas
5
Average Function
Having calculated the total and the percentage value of each student’s marks, Sean now wants to calculate the mean value of percentage of the students for each term. Mean is the same thing as the average.
To calculate the average percentage, you can use either of the formulas,
- =SUM(C3:C18)/16
- =AVERAGE(C3:C18)
To calculate the average percentage,
1. Type the heading Average % in cell B19.
2. Put the average formula for the first term in cell C19.
3. Press Enter.
The figure 79.125% appears in cell C19.
