Mean, median and the outlier

One week of orders with one unusual day. Work out the mean, median, mode and range, choose the right measure for eight situations and see why one big value moves only one of them.

Exercise25 minLower secondary +2CC BY 4.0
4 tasks · 25 min

What you will learn

  • Calculate the mean, the median, the mode and the range of a small data set
  • Find the median of an even number of values
  • Explain why an outlier moves the mean more than the median
  • Choose the measure that fits a question

An average is one number that stands for many. There are several kinds, and they can tell very different stories about the same data:

  • Mean: add all values and divide by how many there are.

  • Median: sort the values; the one in the middle is the median. With an even number of values, take the mean of the two middle ones.

  • Mode: the value that appears most often.

  • Range: the largest value minus the smallest. It shows how spread out the data is.

An outlier is a value far away from the others. The exercise has four tasks and takes about 25 minutes.

A small shop counts its orders on five days: 3, 4, 4, 5 and 34. The 34 was the day a school ordered for every class.

Worked example: the median step by step

Fabrikam's delivery times in days: 4, 2, 7, 3, 2, 5.

  1. Sort them: 2, 2, 3, 4, 5, 7.

  2. Count them: six values, an even number.

  3. The two middle values are the 3rd and the 4th: 3 and 4.

  4. Median = (3 + 4) ÷ 2 = 3.5 days.

With an odd number of values, say seven, the middle one is the 4th. A quick rule: for n values, the middle is at position (n + 1) ÷ 2.

In a spreadsheet, =AVERAGE(A1:A6) gives the mean, =MEDIAN(A1:A6) the median and =MODE(A1:A6) the mode. The names are the same in Excel, Google Sheets and LibreOffice; Excel also offers MODE.SNGL.

Common mistakes

  • Not sorting first. The median of 4, 2, 7 is not 2: sorted, it is 2, 4, 7, so the median is 4.

  • Picking one middle value from an even list. With six values there are two middle values; take their mean.

  • Deleting outliers to get a nicer result. The 34 was a real order. Report it, and say why you use the median for a typical day.

  • Using the mean for categories. You cannot average shoe sizes as labels or favourite colours; use the mode.

For fast finishers

Open the sample orders dataset. For the 25 paid orders, find the mean and the median order value. Which is larger, and why?

Extension solution

The mean is 378.76 and the median is 392.00. Here the mean is the smaller one: many small orders (one of 98.00, one of 147.00 and four of 149.00) pull it down more than the two large orders of 798.00 pull it up. In a spreadsheet: =AVERAGEIFS(J2:J31; K2:K31; "paid") gives the mean. For the median, sort the table by status so the 25 paid orders sit together, then use =MEDIAN on those 25 cells. (Filtering alone is not enough: MEDIAN still counts hidden rows.)

Teacher notes

How to run it. Go through the four definitions with the class (five minutes), then learners work alone. With a class link (unfold "Use it with a class" below the exercise) each learner hands in a result code and Class results shows the class average per task.

Typical mistakes. The median taken from the unsorted list; with six values, learners pick the 3rd or 4th value instead of their mean; the range written as "3 to 34" instead of 31. In the sorting task, "a normal day's orders" is sometimes put under mean, which is exactly the point of the exercise.

Follow-up questions.

  • A newspaper reports the mean income in a region. Why might the median be fairer?

  • Can the mean be a value that never appears in the data? (Yes: the mean of 3, 4, 4, 5 and 34 is 10, and no day had 10 orders.)

  • What happens to the median if the largest value doubles? (Nothing, as long as it stays the largest.)

Differentiation. Easier: allow a calculator and give the sorted lists. Harder: ask learners to invent a data set of five values with mean 10 and median 6, then explain how they built it.

Use it with a class
  1. 1. Copy the class link and share it with your class.
  2. 2. Learners finish the exercise and get a result code.
  3. 3. Paste the codes into Class results to see everyone at once.
Change the tasks in the builder

Reuse this material

CC BY 4.0

You may copy, adapt and share it, also commercially, as long as you credit ManyPI and link back.

"Mean, median and the outlier" by ManyPI (https://manypi.com/edu/mean-median-exercise), licensed under CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/)