HelpContactFor teachers and institutes
>_StemPy Lab
Mock TestsClasses

>_StemPy Lab

Learn. Solve. Code the solutions. Test yourself.

Live examsFree mock exams, timed and rankedEveryone starts together, and your score and rank come the moment it ends.See the exams →
Live examsInternational live exams are comingTell us which exam you want first. Timed practice papers are open now.See what is coming →

Learn

  • Physics
  • Chemistry
  • Mathematics
  • Biology
  • Python Programming
  • Statistics & Data Science
  • Computer Science
  • Space Science and Astronomy
  • Classes
  • Groups

Practice

  • Problems
  • Quizzes
  • Mock Tests
  • Prepare for an Exam
  • Question Sets
  • Exams
  • Certificates
  • Python Labs
  • AI Practice Generator
  • Student-Created Tests

Community

  • Discussions
  • Resources
  • Notes
  • Glossary
  • Blog

Account

  • Log in
© 2026 senLearn. All rights reserved.HelpFor SchoolsAboutContactPrivacy PolicyTerms of UseRefund Policy
  1. Problems
  2. /Use the bicycle sales of problems 5 and 6…
HardStatistics & Data ScienceHigh School (9–10)Time SeriesNumericalConceptualIGCSE

Use the bicycle sales of problems 5 and 6…

StemPy LabContributed by StemPy Lab

Try it on paper first. A hint, the key idea and the worked solution are here when you need them.

Use the bicycle sales of problems 5 and 6. The centred moving averages are 172.5, 177.5, 182.5 and 187.5 at quarters 3 to 6, and the trend line is y=157.5+5ty = 157.5 + 5ty=157.5+5t. Find the seasonal variation at each of quarters 3 to 6. With only one value for each season, use these as the seasonal components. Forecast the sales in quarter 1 and in quarter 3 of year 3. State two assumptions behind your forecasts.

Check your answer

Work it out on paper, then type your number. The answer itself stays hidden.

Need a reminder? The key ideaShowHide

Seasonal variation === actual −-− trend. Seasonal component === the mean of the variations of one season. Then

forecast=trend value+seasonal component\displaystyle \text{forecast} = \text{trend value} + \text{seasonal component}forecast=trend value+seasonal component

The worked solution

Check an answer or open a hint to unlock the worked solution.

Have you tried it?

Work it out on paper first. It is fine to get stuck or make a mistake: that is how we learn. When you are ready, go through the solution one step at a time, and check each step against your own.

Step 1. The variations. Quarter 3: 260−172.5=87.5260 - 172.5 = 87.5260−172.5=87.5. Quarter 4: 90−177.5=−87.590 - 177.5 = -87.590−177.5=−87.5. Quarter 5: 140−182.5=−42.5140 - 182.5 = -42.5140−182.5=−42.5. Quarter 6: 230−187.5=42.5230 - 187.5 = 42.5230−187.5=42.5.

Step 2. Quarter 1 of year 3. Trend 157.5+5×9=202.5157.5 + 5 \times 9 = 202.5157.5+5×9=202.5. Forecast 202.5+(−42.5)=160202.5 + (-42.5) = 160202.5+(−42.5)=160.

Step 3. Quarter 3 of year 3. Trend 157.5+5×11=212.5157.5 + 5 \times 11 = 212.5157.5+5×11=212.5. Forecast 212.5+87.5=300212.5 + 87.5 = 300212.5+87.5=300.

Step 4. Assumptions. The trend keeps rising by 5 a quarter, and each season stays as far above or below the trend as before.

Answer: variations 87.587.587.5, −87.5-87.5−87.5, −42.5-42.5−42.5 and 42.542.542.5; forecasts 160160160 and 300300300 bicycles.

Watch out. Each component rests on one value only, so these forecasts are rough. More years of data would give better components.

Log in to save this for later
← All Problems
← A trend line drawn by eye on a time series graph passes through (2, 140) and (10, 180), where t is…Next →
More onTime Series

Discussion (0)

Log in to join the discussion.

Loading…

More on this topic

  1. A trend line drawn by eye on a time series graph passes through (2, 140) and (10, 180), where t is…Medium
  2. A gym's members in quarter 2 and the centred moving averages at those quarters are these…Easy
  3. Five quarterly values of a series are 30, 44, 52, 26 and 34…Hard
  4. For the bicycle sales of the last problem, a trend line is drawn by eye through the centred moving…Medium
  5. A shop sells bicycles. Its sales in each quarter for two years are these…Medium
All problems on this topic →