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 launch Excel](https://howtech.tv/wp-content/images/003279/1.jpg)
Step 2. Fill several rows with the various values you want to calculate the Mean for.
![enter figures enter figures](https://howtech.tv/wp-content/images/003279/2.jpg)
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 enter formula](https://howtech.tv/wp-content/images/003279/3.jpg)
Result: Congratulations, you have learnt how to calculate the mean in Excel.