Ahead of discussing how to calculate average in excel, let us define average. 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.
Further, when using the AVERAGE function in your Excel sheets, please do keep in mind the difference between cells with zero values and blank cells. 0’s are counted, but empty cells are not.
Formula to Calculate Average in Excel.
The formula to calculate average can be found in excel. Generally, it is pretty easy to calculate it using the average function. Additionally. the AVERAGE Function is categorized under Excel Statistical functions and it returns the average value of a given series of numbers in Excel.
=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 |
Firstly, we begin by transferring the data to an excel spreadsheet.
Second, we add 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.
