Averages from Frequency Tables

On this page

How to read a frequency table and use it to find the mode, the range, the median, the total and the mean, and how to find a missing frequency.

What a frequency table shows

A frequency table is a short way to write a list in which values repeat. The first column gives the value that was recorded. The frequency says how many times that value was recorded.

Here, two pupils went swimming 0 times, three pupils went 1 time and one pupil went 2 times. Written out in full, the list is 0, 0, 1, 1, 1, 2

Adding the frequencies gives the number of people: 2+3+1=6 pupils. The table has only 3 rows, but it shows 6 pieces of data. The two pupils who went 0 times still count.

The same information is sometimes drawn as a bar chart or a vertical line chart. The height of each bar or line is the frequency.

In the exam you are usually asked to find the mode, the median, the range or the total from a frequency table, for 1 or 2 marks each, or to work out the mean, for 3 marks. Harder questions give a table with a missing frequency, or ask you to explain the mistake in someone's working.

The mode and the range

The mode is the value with the highest frequency. The question may call it the modal value. Give the value from the first column, not the frequency.

The range is the largest value minus the smallest value. Use only values that were recorded: a row with frequency 0 means nobody had that value, so leave it out.

Worked example 1: The mode and the range

The table shows the number of cars at each house in a street.

Find the modal number of cars and the range.

  1. The highest frequency is 9, in the row for 1 car.
  2. So the modal number of cars is 1. The answer is not 9: that is how many houses have 1 car.
  3. No house has 4 cars, because that frequency is 0. Leave that row out when you find the range.
  4. Your turn. Work out the range.

    The largest number of cars recorded is 3 and the smallest is 0. Range =3-0=3

  5. Answer: the mode is 1 car and the range is 3 cars.

The total and the mean

To find the total of all the data, multiply each value by its frequency, then add the results. For example, a value of 3 with frequency 5 adds 3\times5=15 to the total, because five people each had 3

Add a third column to the table for value × frequency. It helps you to include every row, and a row with frequency 1 is easy to miss.

To find the mean, divide the total of the data by the total frequency:

\text{mean}=\frac{\text{total of the data}}{\text{total frequency}}

Divide by the number of people, not by the number of rows. A mean must lie between the smallest and the largest value, so if your mean is bigger than every value in the table, something has gone wrong.

Worked example 2: The total from a frequency table

Some families gave tins of food to a food bank. The table shows how many tins each family gave.

Work out the total number of tins.

  1. Multiply each number of tins by its frequency.
  2. The first row is 0\times2=0, not 2. Two families gave no tins.
  3. The other rows: 1\times4=4, 2\times7=14, 3\times5=15, 4\times2=8
  4. Your turn. Add the products: 0+4+14+15+8

    0+4+14+15+8=41

  5. Adding the frequency column would give 20, which is the number of families, not the number of tins.
  6. Answer: 41 tins

Worked example 3: The mean from a frequency table

The table shows the number of bus journeys each of 24 people made last week.

Work out the mean number of journeys. Give your answer correct to 1 decimal place.

  1. Journeys × frequency: 0\times3=0, 1\times6=6, 2\times8=16, 3\times4=12, 4\times3=12
  2. Total number of journeys: 0+6+16+12+12=46
  3. Total frequency: 3+6+8+4+3=24 people. Divide by 24, not by 5 rows.
  4. Your turn. Work out the mean, correct to 1 decimal place.

    46\div24=1.9166\ldots=1.9 to 1 decimal place

  5. Check: 1.9 lies between the smallest value, 0, and the largest value, 4
  6. Answer: 1.9 journeys

Finding the median

The median is the middle value when all the data is in order. A frequency table already has its values in order, so you do not need to write out the list.

If there are n values, the median is the value in position

\frac{n+1}{2}

For 21 values that is the 11th value. For 16 values it is 8.5, which means halfway between the 8th and 9th values.

To find which value is in that position, keep a running total of the frequencies as you go down the table. The position, such as the 11th, is not the median: the median is the value found in that position.

Worked example 4: The median of an odd number of values

The table shows the number of hot drinks each worker in an office had today.

Find the median number of hot drinks.

  1. Add a running total column to the table. The last running total, 21, is the number of workers.
  2. (21+1)\div2=11, so the median is the 11th value.
  3. Values 1 to 4 are 0. Go down the running totals to the first one that is 11 or more.
  4. Your turn. Which number of hot drinks is in the 11th position?

    The 11th value is 1, because values 5 to 12 are all 1

  5. Answer: the median is 1 hot drink.

Worked example 5: The median between two rows

The table shows the number of baskets each of 20 players scored in a netball match.

Find the median number of baskets.

  1. (20+1)\div2=10.5, so the median is halfway between the 10th and 11th values.
  2. Running totals: 3, 7, 10, 16, 20
  3. Values 8 to 10 are 2, so the 10th value is 2
  4. Your turn. What is the 11th value?

    Values 11 to 16 are 3, so the 11th value is 3

  5. The median is halfway between 2 and 3: (2+3)\div2=2.5
  6. Answer: the median is 2.5 baskets.

A missing frequency

Some questions leave one frequency out and tell you a total instead.

  • If you are told the total frequency, add the frequencies you know and subtract from it.
  • If you are told the total of the data, work out value × frequency for the rows you know, subtract from the total, then divide by the value in the missing row.

A frequency counts people or things, so it must be a whole number. If you get a decimal, check your working.

Worked example 6: Finding a missing frequency

Tickets for a school show cost £6, £8, £10 or £12. The table shows how many tickets were sold at each price. The number of £8 tickets is missing.

The school took £162 altogether. Work out how many £8 tickets were sold.

  1. The total, £162, is an amount of money, not a number of tickets.
  2. Money from the rows you know, in pounds: 6\times5=30, 10\times4=40, 12\times3=36
  3. 30+40+36=106, so these tickets took £106.
  4. Your turn. How much money came from the £8 tickets?

    162-106=56, so £56 came from £8 tickets.

  5. Number of £8 tickets: 56\div8=7. Check: 30+7\times8+40+36=162
  6. Answer: 7 tickets

Totals, means and new data

If you know a mean, you can work back to the total:

\text{total}=\text{mean}\times\text{number of values}

For example, 10 pupils with a mean score of 4 scored 4\times10=40 altogether. Another 15 pupils with a mean of 6 scored 6\times15=90

To find the mean of all 25 pupils, add the totals and add the numbers of pupils: (40+90)\div25=5.2. Taking the mean of the two means, (4+6)\div2=5, is wrong, because the groups are different sizes.

If more data is added to a table, change both the total of the data and the total frequency before you divide again. If a wrong value is corrected, the total frequency stays the same, but the total of the data changes.

Common mistakes

  • Adding one column instead of multiplying. To find the total, multiply each value by its frequency, then add the products.
  • Working out 0\times4 as 4. Zero times any frequency is 0.
  • Dividing by the number of rows. For the mean, divide by the total frequency, the number of people.
  • Giving the highest frequency as the mode. The mode is the value next to the highest frequency.
  • Finding the middle of the table, not the middle of the data. Use (n+1)\div2 and a running total of the frequencies.
  • Leaving out a row. Check that you have one product for every row, including rows with frequency 1

Practice questions