How to Calculate the Mean in Excel



In this tutorial you will learn how to calculate the mean in Excel.
Calculating the mean from a set of numbers is done by the formula:
Mean (number set) = Sum (components)/number of elements, or
This means you need a set of numbers to calculate the means for.
Prerequisites: Microsoft Excel.
Step 1. Let’s create it:
Launch Excel and start a new file from File- New.
launch Excel

Step 2. Fill several rows with the various values you want to calculate the Mean for.
enter figures

Step 3. At the ending row, add the following formula:
= =SUM(your data set)/COUNT(your data set), where your data set is the number set you have selected.
Hit Enter. The Mean of your input numbers is displayed.
enter formula

Result: Congratulations, you have learnt how to calculate the mean in Excel.