The mean is the average or the most common value in a set of numbers. In this article, we will learn how to calculate the mean in Excel.
Steps to Calculate Mean in Excel
Let us consider the following dataset of a group of students with their marks:
We are interested in finding the mean of the marks scored by the students. To calculate the mean in Excel, we use an in-built AVERAGE function. The syntax of the AVERAGE function is =AVERAGE(start cell reference:end cell reference).
- Select the cell where you want to display the mean.
- Type the formula =AVERAGE( and select the data range containing the values for which mean value is sought.
- Finish the formula with ) and press the Enter key.
In this example, we enter the formula =AVERAGE(B2:B11) in cell B13, to get the mean of the marks obtained by students:
Note: The AVERAGE function ignores empty cells and cells that do not include any numbers.
In this article, we learned how to calculate the mean in Excel using the AVERAGE formula.