Averages from a Frequency Table
Averages from a frequency table means calculating the mean, median, mode and range of data that has already been grouped into a table showing each value and how often it occurs. The mode is the value with the highest frequency, the median is found using the running total (cumulative frequency), and the mean is calculated as (sum of frequency x value) divided by the total frequency. This is a common GCSE Statistics topic tested with discrete data such as shoe sizes or number of siblings.
Before you start
Make sure you're comfortable with these topics first:
Method
- Add a third column to the table showing frequency x value (f x x) for each row.
- For the mean, sum the frequency x value column, then divide by the total frequency (sum of the frequency column).
- For the mode, read off the value with the highest frequency directly from the table.
- For the median, add a running total (cumulative frequency) column, then find the median position. For an odd total frequency, the median is the ((total frequency + 1)/2)th item. For an even total frequency, it is the mean of the (total frequency / 2)th and the (total frequency / 2 + 1)th items (if both fall in the same row, that row's value is the median).
- For the range, subtract the smallest value in the table from the largest value, using only values that actually have a frequency greater than 0.
- Double-check the total frequency by adding the frequency column, since every later calculation depends on it being correct.
Common mistakes
MistakeDividing the total of f x value by the number of rows in the table, the number of different values, instead of by the total frequency.
InsteadThe divisor is the total frequency, found by adding the frequency column. Four rows could hold 30 items or 300, so the number of rows says nothing about how many values were recorded.
MistakeGiving the highest frequency as the mode, such as answering 8 when shoe size 5 has the highest frequency, which is 8 (sizes 4, 5 and 6 have frequencies 3, 8 and 5).
InsteadThe mode is the value that occurs most often, so name the row: shoe size 5. The frequency only says how many times it occurred, and it sits in a different column.
MistakeTaking the median to be the middle row of the table or the middle frequency, rather than the middle data value.
InsteadAdd a cumulative frequency column and find the position of the median from the total; for 31 values it is the 16th. The median is the value whose cumulative frequency first reaches that position.
MistakeFinding the range from the frequency column by subtracting the smallest frequency from the largest.
InsteadThe range describes the values, not how often they occur. Take the largest value that has a frequency above 0 and subtract the smallest such value.
Worked examples
Example 1
The table shows the number of pets owned by 20 students. Pets: 0 (frequency 5), 1 (frequency 7), 2 (frequency 6), 3 (frequency 2). Find the mean, median, mode and range.
- Total frequency = 5 + 7 + 6 + 2 = 20, which matches the 20 students.
- Frequency x value: 0x5=0, 1x7=7, 2x6=12, 3x2=6. Sum = 0+7+12+6 = 25.
- Mean = 25/20 = 1.25 pets.
- Mode: the highest frequency is 7, for the value 1, so the mode is 1 pet.
- Median: with 20 values, the median is the mean of the 10th and 11th values. Cumulative frequencies are 5, 12, 18, 20, so both the 10th and 11th values fall in the '1 pet' group (cumulative frequency reaches 12 there). Median = 1.
- Final answer: mean = 1.25, median = 1, mode = 1, range = 3 - 0 = 3.
Example 2
The table shows the number of library books borrowed in a week by a group of students: 1 book (frequency 6), 2 books (frequency 8), 3 books (frequency y), 4 books (frequency 3). The mean number of books borrowed is 2.5. Find y, then find the median and the mode.
- Total frequency = 6 + 8 + y + 3 = 17 + y. Total of f x value = 6 + 16 + 3y + 12 = 34 + 3y.
- The mean is (34 + 3y) / (17 + y) = 2.5, so 34 + 3y = 2.5 x (17 + y) = 42.5 + 2.5y.
- Subtract 2.5y and 34 from both sides: 0.5y = 8.5, so y = 17.
- Check: the total frequency is 34, the total of f x value is 6 + 16 + 51 + 12 = 85, and 85 / 34 = 2.5.
- Median: with 34 values it is the mean of the 17th and 18th. The cumulative frequencies are 6, 14, 31, 34, so both values are in the 3-book row and the median is 3.
- Mode: the highest frequency is 17, in the 3-book row, so the mode is 3.
- Final answer: y = 17, median = 3 books, mode = 3 books.
Practice questions
Q1[1 mark]A table shows number of siblings: 0 (freq 4), 1 (freq 10), 2 (freq 4), 3 (freq 2). Find the mode.Show answer
Answer: 1 (highest frequency, 10)
Q2[1 mark]Using the same table (0:4, 1:10, 2:4, 3:2), find the range.Show answer
Answer: 3 (3 - 0 = 3)
Q3[1 mark]Using the same table (0:4, 1:10, 2:4, 3:2), find the total number of students.Show answer
Answer: 20 (4+10+4+2 = 20)
Q4[3 marks]Using the same table (0:4, 1:10, 2:4, 3:2), find the mean number of siblings.Show answer
Answer: 1.2 (sum of f x x = 0+10+8+6 = 24, 24/20 = 1.2)
Q5[1 mark]Using the same table (0:4, 1:10, 2:4, 3:2), find the median number of siblings.Show answer
Answer: 1 (20 values; median is mean of 10th and 11th values; cumulative frequencies 4, 14, 18, 20 place both in the '1 sibling' group)
Q6[3 marks]A different table shows test scores out of 5 for 30 students: 1 (freq 3), 2 (freq 5), 3 (freq 9), 4 (freq 8), 5 (freq 5). Find the mean score.Show answer
Answer: 3.23 (2 dp) (sum of f x x = 3+10+27+32+25 = 97, 97/30 = 3.23)
Exam-style questions
Written in the style of a GCSE Statistics exam paper, with a full mark scheme.
Exam tips
- If a question gives the mean and asks for a missing frequency, write an equation: the total of f x value divided by the total frequency equals the mean, with the unknown in both totals. Then solve it.
- Add up the frequency column and check it against the number of items in the question before any other calculation; a slip in the total spoils the mean and the median together.
Q1[3 marks]The table shows the number of goals scored by a hockey team in 15 matches: 0 (freq 3), 1 (freq 6), 2 (freq 4), 3 (freq 2). Calculate the mean number of goals per match.Show mark scheme
Tick each line you got.
Nothing ticked yet - 3 available
Q2[4 marks]The table shows the number of text messages sent by 25 students in one evening: 0 (freq 2), 1 (freq 5), 2 (freq 8), 3 (freq 6), 4 (freq 4). Find the median number of text messages.Show mark scheme
Tick each line you got.
Nothing ticked yet - 4 available
Q3[3 marks]The table shows the number of DVDs owned by 12 families: 0 (freq 1), 1 (freq 3), 2 (freq 4), 3 (freq x), 4 (freq 1), where x is unknown and the total frequency is 12. Find x, then state the mode.Show mark scheme
Tick each line you got.
Nothing ticked yet - 3 available
See real GCSE Statistics past-paper questions, with official mark schemes
This topic in real past papers
We have tagged some boards' past papers question by question (not every board or year yet). This topic comes up in:
- AQA GCSE Statistics past papers: 1 question across 1 paper, latest tagged November 2020
- Edexcel GCSE Statistics past papers: 1 question across 1 paper, latest tagged November 2020
Free printable worksheet
Want more practice on paper? Download the Averages from a Frequency Table worksheet pack - 33 pages of exam-style questions with a full mark scheme. Free to download, no card or account. Print it for personal and classroom use.
This topic is chapter 4 of GCSE Statistics Foundation Essentials 2 and chapter 6 of GCSE Statistics Higher Essentials 2, the whole course as one free printable PDF. Its worksheet is also chapter 4 of GCSE Statistics Foundation Topic Workbook 4 and chapter 6 of GCSE Statistics Higher Topic Workbook 5, free printable practice books.
Other versions of this worksheet: