In this lesson we look at how to calculate the Mean, Median, Mode, and Range.

We then include a SlideShare presentation at the end that shows how to do these same calculations quickly using Microsoft Excel.

The Mean, Median, and Mode represent three different ways of finding the “Average” value for a group of numbers.

Often the “Median” or Middle value is used to express an Average for cases where there can be large variations in values at the high and low ends of the group.

Typical Examples of this are Median Income, Median House Price, Median Car Price, and so on.

Let us now look at how we calculate each of these three different types of mathematical average.

The “Mean” Average

The “Mean” is kind of mean and nasty because we have to do a lot of adding up and dividing to get the answer.

It is probably the average which is hardest to do the maths working out for.

The “Median” Average

The Median is the middle value of our items, after we have first written our items out in order from lowest to highest.

Remember: Median = Middle (like the median strip that runs down the middle of a multi-lane divided road).

If we have an odd number of items, and put them into order, there will only be one item in the middle for the Median.

However, if there is an even number of items, then after we put the items in order, there will be two items in the middle.

What we do is find the halfway point in between these two items, by adding the two items together, and then dividing by two.

This halfway point average is the Median of the data.

The “Mode” Average

The Mode is a useful average when we have repeating values in our data.

The value which repeats the most, is the one which we call the Mode.

Remember: Mode = Most Of.

Calculating Averages Using MS Excel

The following SlideShare presentation takes the material from this lesson and shows how it can be processed using Microsoft Excel functionality.

Click the bottom right hand corner icon to go to full screen, and use the escape key to return to this web page.

If you are using an ipad or ipod to view the presentation, then simply swipe your finger across each slide to go forward and backward through the slide show.

Credits and References

Original PowerPoint slides for Mean and Median came from the Internet and were written by Mike Crowley.

Mike’s PowerPoint was then modified and added to by Passy’s World to include the use of Excel statistics functionality.

Mean Median Mode Videos

Here is a four minute video which shows the basics of calculating the Mean, Median, Mode, and Range.

The guy who made this video has some interesting little songs and ideas for memorizing what to do for each calculation.

Here is a more detailed thirteen minute video on exactly how to calculate the Mean Median, Mode and Range. This video includes all of the working out steps which need to be done.

Mean Median Mode Song

The following one and a half minute musical animation covers how to calculate the Mean Median and Mode.

Funny Mean Median and Mode Music Video

This next video is a bit different, but covers how to calculate mathematical averages in a very entertaining way.

Related Items

Basic Histogram Graphs

Grouped Data Histograms Using Class Intervals

MS Excel Charts and Graphs

MS Excel Column Graphs and Pie Charts

Funny Graphs from Graph Jam

Real World Line Graphs

Free Online Graph Makers

Misleading Graphs

Stem and Leaf Plots (Stem Plots)

Real World Charts and Graphs

If you enjoyed this post, why not get a free subscription to our website.

You can then receive notifications of new pages directly to your email address.

Go to the subscribe area on the right hand sidebar, fill in your email address and then click the “Subscribe” button.

To find out exactly how free subscription works, click the following link:

If you would like to submit an idea for an article, or be a guest writer on our blog, then please email us at the hotmail address shown in the right hand side bar of this page.

If you are a subscriber to Passy’s World of Mathematics, and would like to receive a free PowerPoint version of this lesson valued at $3.99, but 100% free to you as a Subscriber, then email us at the following address:

Please state in your email that you wish to obtain the free subscriber copy of the “Mean Median and Mode” PowerPoint.

Enjoy,

Passy

Pingback: Online Graph Makers | Passy's World of Mathematics

Pingback: Misleading Graphs | Passy's World of Mathematics

Pingback: Calcule mediam | Platformblog

Pingback: Stem and Leaf Plots | Passy's World of Mathematics

Pingback: Real World Charts and Graphs | Passy's World of Mathematics

Pingback: Online Graph Makers | Passy's World of Mathematics

Pingback: Averages – Mean Median Mode | Passy's World – Old Site

Pingback: Mean Median Mode for Grouped Data | Passy's World of Mathematics

Pingback: Symmetry and Skew | Passy's World of Mathematics

Pingback: Real World Charts and Graphs | Passy's World of Mathematics

Pingback: Introduction to Probability | Passy's World of Mathematics