The word average means middle or central point.
Most of the time when we are required to calculate the average of a list of data we are supposed to calculate the ‘mean’ of the given data.
Formula to calculate average in excel.
Since the formula to calculate average can be found in excel, it is pretty easy to calculate it using the average function.
=AVERAGE(X1:Xn)
Example:
Suppose you are given a data set containing the name of students and their mathematics percentage and asked to calculate the average of their mathematics marks.
Name of Student | Marks |
Archie | 90 |
Millicent | 92 |
Jeff | 94 |
Veronica | 90 |
We will begin by transferring the data to an excel spreadsheet.

We continue by adding another row and label it Average and put our average function just below the marks column and press enter to get your average.

Therefore, their average mark is 91.