Websink Prep UKGCSE MathsTextbook contentsMaths textbooksYear 1Year 2Year 4Year 5Year 6GCSEBrowse allPast papersFind a tutorBecome a tutor
GCSE Maths · EdexcelChapter 24 · Statistics
GCSE Maths · Statistics · Higher · Lesson 24.8

GCSE Maths: Line graphs and time series (Higher)

Part of the GCSE Maths statistics chapter (Higher). Chapter overview · Foundation version of this lesson · whole chapter on one page · Download worksheet (PDF) · Answers (PDF)

Download worksheet (PDF)Answers (PDF)
24.8

Line graphs and time series

Edexcel 1MA1: S2
Grade 2-5

A time series is a set of measurements taken at regular times: the temperature every hour, the number of customers every month, a baby’s mass every week. We show a time series on a line graph: time goes on the horizontal axis, the measurement on the vertical axis. We plot a point for each reading and join the points with straight lines, from left to right.

Ice cream sales at a seaside kiosk020406080Quarter of the year (Q1 = Jan to Mar)Sales (hundreds)Q1 Y1Q2 Y1Q3 Y1Q4 Y1Q1 Y2Q2 Y2Q3 Y2Q4 Y2Q1 Y3Q2 Y3Q3 Y3Q4 Y3
A time series. Notice the pattern that repeats each year (low in Q1, high in Q3) and the way each year is higher than the one before.

What a line graph shows. Reading a line graph, look for three things. The trend is the general direction over a long time (here, sales rise from year to year). Seasonal variation is a pattern that repeats regularly (here, sales are highest in summer, Q3, every year). Unusual values do not fit the pattern and may need explaining.

Predicting. To predict the next value, continue the trend and the seasonal pattern. For example, Q3 sales were 58, 63, 68 in three years: they go up by 5 each year, so Year 4’s Q3 might be 73. This is an extrapolation (going beyond the data), so it is only an estimate and could be wrong if conditions change. Reading a value between two plotted points is interpolation: it is less risky, but it assumes the values change steadily between the readings.

Key ideas

  • A time series is data measured at regular times; show it on a line graph with time on the horizontal axis.
  • Trend = long-term direction. Seasonal variation = a pattern that repeats regularly.
  • Compare the same season in different years to see the trend.
  • Interpolation (between points) is more reliable than extrapolation (beyond the data).
  • A line graph that does not start at 0, or has an uneven scale, can mislead.
Worked example 24.8.1
The line graph shows the ice cream sales (in hundreds) for each quarter. (a) What were the sales in Q2 of Year 2? (b) In which quarter were sales highest? (c) How many more were sold in Q3 of Year 3 than in Q3 of Year 1?
020406080QuarterSales (hundreds)Q1 Y1Q2 Y1Q3 Y1Q4 Y1Q1 Y2Q2 Y2Q3 Y2Q4 Y2Q1 Y3Q2 Y3Q3 Y3Q4 Y3

Method. Find each quarter on the horizontal axis, go up to the plotted point, and read across to the vertical axis.

  1. (a) Find Q2 Y2 and read the point. The 6th point from the left is Q2 of Year 2.
    Sales = 45 hundred = 4500
  2. (b) Find the highest point. The highest point on the graph is the greatest sales.
    Highest point = 68 hundred, at Q3 of Year 3
  3. (c) Read the two Q3 points. Q3 Y3 and Q3 Y1.
    Q3 Y3 = 68, Q3 Y1 = 58
  4. Subtract. “How many more” means take away.
    68 − 58 = 10 hundred = 1000

Check. The Q3 points are 58, 63, 68, rising by 5 each year, so 68 is 10 more than 58. ✓

Watch out. Remember the units: the vertical axis is in hundreds.

Worked example 24.8.2
Describe the trend and the seasonal pattern in the ice cream sales.

Method. Compare the same quarter in different years for the trend, and compare the quarters within a year for the seasonal pattern.

  1. Look at the same quarter each year. This removes the seasonal effect so that only the trend is left.
    Q1: 24, 27, 30 (up 3 each year)
    Q3: 58, 63, 68 (up 5 each year)
  2. State the trend. The values for every quarter go up from year to year.
    Trend: sales are rising each year.
  3. Look within one year. Compare the four quarters of Year 1.
    Year 1: 24, 41, 58, 30: low, then rising to a peak in Q3, then falling.
  4. State the seasonal pattern. The same shape repeats in every year.
    Seasonal pattern: sales are highest in Q3 (summer) and lowest in Q1 (winter) every year.

Check. Each year looks like a bigger version of the year before. ✓

Watch out. The trend and the seasonal pattern are different: the trend compares years, the seasonal pattern compares seasons.

Worked example 24.8.3
The table shows the mass of a baby each month.
Age (months)0123456
Mass (kg)3.44.14.95.66.16.67
Draw a line graph.

Method. For a line graph, plot a point for each time and join the points with straight lines, from left to right.

  1. Draw and label the axes. Time goes on the horizontal axis. The measurement goes on the vertical axis, with an equal scale.
    Horizontal axis: Age (months). Vertical axis: Mass (kg).
  2. Plot a point for each pair of values. Go along to the time, then up to the value.
    0: 3.399999999999999911182158029987476766109466552734375
    1: 4.0999999999999996447286321199499070644378662109375
    2: 4.9000000000000003552713678800500929355621337890625
    3: 5.5999999999999996447286321199499070644378662109375
    4: 6.0999999999999996447286321199499070644378662109375
    5: 6.5999999999999996447286321199499070644378662109375
    6: 7
  3. Join the points with straight lines. The lines show the trend. Do not draw a line before the first point or after the last one.
    02468Age (months)Mass (kg)0123456

Check. Each point matches a value in the table. ✓

Watch out. Plot every point accurately before you join them.

Worked example 24.8.4
Use the pattern in the Q3 sales to estimate the Q3 sales in Year 4. Say why your answer might not be reliable.

Method. Find how the Q3 sales change each year, continue the pattern one more year, and comment on the risk.

  1. Write the Q3 sales for each year. Same quarter each year, so no seasonal effect.
    58, 63, 68
  2. Find the yearly change. Subtract each value from the next.
    63 − 58 = 5
    68 − 63 = 5
  3. Continue the pattern. Sales have gone up by 5 each year, so assume they go up by 5 again.
    68 + 5 = 73 hundred
  4. Comment on reliability. This is an extrapolation: it assumes the trend continues, but weather, prices or competition could change.
    It is only an estimate.

Check. The sequence 58, 63, 68, 73 has a constant difference of 5. ✓

Watch out. Say that the estimate assumes the trend continues.

Watch out

The trend compares the same season in different years. Do not compare Q1 with Q3 to find the trend: that mixes the seasonal pattern with the trend. And never say a prediction is certain.

Exercise 24H  Line graphs and time series

Non-calculator
1
FThe graph shows the ice cream sales (in hundreds) for each quarter over three years. (a) In which quarter were sales lowest? (b) Work out the total sales in Year 2. (c) What was the increase in sales in Q4 from Year 1 to Year 3?
020406080QuarterSales (hundreds)Q1 Y1Q2 Y1Q3 Y1Q4 Y1Q1 Y2Q2 Y2Q3 Y2Q4 Y2Q1 Y3Q2 Y3Q3 Y3Q4 Y3
(a)Lowest quarter
(b)Total sales in Year 2
(c)Increase in Q4
2
FThe table shows the number of visitors to a website each month.
MonthJanFebMarAprMayJun
Visitors120150210260240300
Draw a line graph to show this information.
3
RThe graph shows a family’s gas bill (in £) for each quarter over two years. Describe (a) the seasonal pattern and (b) the trend.
0255075100125150QuarterBill (£)Q1 Y1Q2 Y1Q3 Y1Q4 Y1Q1 Y2Q2 Y2Q3 Y2Q4 Y2
(a)Seasonal pattern
(b)Trend
4
PSThe graph shows the monthly sales (in thousands of pounds) of two shops, A and B. (a) In which month did shop A first have higher sales than shop B? (b) How much higher were A’s sales than B’s in June? (c) Which shop has more steady sales? Give a reason.
01020304050MonthSales (£000)JanFebMarAprMayJunShop AShop B
(a)First month A is higher
(b)June difference
(c)More steady
5
PSUse the ice cream data. The Q1 sales in the three years were 24, 27, 30 hundred. Estimate the Q1 sales in Year 4 if the pattern continues.
6
RA company shows this line graph of its profit and says “our profit is growing very fast”. Explain why the graph may be misleading.
100101102103104105YearProfit (£000)20202021202220232024
7
RDev records the favourite colour of 5 students and draws a line graph joining the points for red, blue, green, yellow, black. Explain why this is not appropriate.
8
PSThe temperature was recorded at 12 noon (14°C) and at 2 pm (18°C). (a) Estimate the temperature at 1 pm. (b) Explain why your answer to (a) is only an estimate.
(a)Temperature at 1 pm
(b)Why only an estimate
9
PSWork out the mean quarterly sales in Year 2 from the ice cream graph, giving your answer to 2 decimal places.
10
RIce cream sales in Q3 were 58, 63, 68 hundred in Years 1, 2 and 3. If the trend continues, in which year will Q3 sales first be over 100 hundred? Comment on the reliability.
11
FThe table shows the temperature in a classroom at different times.
Time8am9am10am11am12pm1pm2pm3pm
Temperature (°C)1214171921222018
Draw a line graph to show this information.
12
RSam looks at a graph of umbrella sales. Sales were 40 in January and 28 in March. He says: “Sales are falling, so the shop will soon sell no umbrellas.” Give two reasons why this conclusion may be wrong.

Websink Prep UK is an independent site. It is not affiliated with, endorsed by or sponsored by AQA, Pearson Edexcel, OCR, WJEC, Eduqas, CCEA, SQA, GL Assessment, CEM or the Department for Education. All exam board names and trademarks belong to their owners. Past papers are linked from the exam boards' own websites and are not hosted here.

About Websink Prep UK · Find a tutor · Privacy · Terms · Cookie settings