English

# How To Calculate Mean in Excel?

How to Find Mean / Average in Microsoft (MS) Excel?

## Microsoft Excel (MS) Average Formula | AVERAGE Function in Excel

Arithmetic mean is defined as the average of a set of numerical values. It is calculated by adding all the numbers and by dividing the total with the number of terms in the set. Microsoft Excel is designed to calculate mean of a set of numbers dynamically using the simple formula AVERAGE(number1, number2...)

Let us learn here how to calculate mean in excel with sample pictures.

Step 1:
Open a file in an excel containing sample data to find the arithmetic mean.

Step 2: Keep the cursor on the cell where you want the mean to be calculated (say B7) and click on the Function icon under Insert Menu. You could see the Functions Tab which lists default mathematical functions. Select AVERAGE and Hit Ok.

Step 3: The Average formula is now displayed in the selected cell (B7) as AVERAGE

Step 4: Complete the mean formula, by selecting the cells from B2 to B6 and Hit Enter. Here, Drag the cursor from B2 to B6. Now, the formula is AVERAGE (B2:B6), Hit Enter.

Step 5: The mean of the set of numbers is calculated and displayed as 77.8 in cell B7.