| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 Excel, Word and PowerPoint Tutorials from Howtech | 2013-06-21 22:00:35 |  138,180 Views |
Don’t forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids – our feed
http://www.facebook.com/howtechtv – join us on facebook
https://plus.google.com/103440382717658277879 – our group in Google+
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.
Step 2. Fill several rows with the various values you want to calculate the Mean for.
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.
Result: Congratulations, you have learnt how to calculate the mean in Excel.
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
