Unit 6: Time-based Data | Class 12 Applied Maths MCQs & Solutions | CBSE 2026-27 | Boundless Maths
Unit 6 of 8 6 Marks CBSE 2026–27 Time-based Data

Time-based Data
Unit 6 — Free Study Resources

CBSE Class 12 Applied Mathematics · Moving Averages & Least Squares Method

This page covers Unit 6 of CBSE Class 12 Applied Mathematics — carrying 6 marks in the board exam. It covers two core methods: the Method of Moving Averages (odd-period, naturally centred, and even-period, requiring an additional centring step) and the Method of Least Squares for fitting a straight-line trend \(y = a + bx\) and making algebraic forecasts. Includes 10 interactive MCQs with full solutions and 5 fully solved 5-mark questions. All content aligned to the CBSE Applied Maths Syllabus 2026-27. Once you've attempted the questions and self-assessed your answers, tap ✨ My Report to see your personalised performance breakdown.

0
Board Exam Marks
0
Key Topics
0
MCQs & AR Questions
0
5-Mark Questions
Unit 6 · 6 Marks

Topics & Key Formulas

Two topics examined across MCQs and the 5-mark long-answer question. Memorise the formulas below — both topics appear in the board exam every year.

📈 Method of Moving Averages

Smooth time series data to reveal the underlying long-term trend. Odd-period MAs are directly centred; even-period MAs require an additional centring step by averaging consecutive pairs.

Odd-period MA:  \(\text{MA}_k = \dfrac{\sum_{i=1}^{k} y_i}{k}\), placed at middle period
Even-period centring:  \(\text{CMA} = \dfrac{\text{MA}_i + \text{MA}_{i+1}}{2}\)

📉 Method of Least Squares

Fit a linear trend equation to historical data and use it to forecast future values. Choose the middle year as origin to make \(\sum x = 0\) and simplify calculations significantly.

Trend line:  \(y = a + bx\)
When \(\sum x = 0\):  \(a = \dfrac{\sum y}{n},\quad b = \dfrac{\sum xy}{\sum x^2}\)
📐
All the formulas — not just for this unit, but all 8 units — in one print-ready PDF

Organised by topic · Exam-focused · Pin it up and revise in minutes

Get Formula Deck — ₹199 →
6
Time-based Data 6 Marks · Complete One-Shot (31 min)

Time-based Data — Complete One-Shot (31 min)

▶ Watch on YouTube →
✓ Index Numbers ✓ Time Series ✓ Moving Averages ✓ Least Squares

Free video lessons for all 8 units

Subscribe so you never miss a new lesson.

  • Unit 1 — Numbers & Quantification
  • Unit 2 — Algebra (Matrices)
  • Unit 3 — Calculus
  • Unit 4 — Probability Distributions
  • Unit 5 — Inferential Statistics
  • Unit 6 — Time-based Data ✓
  • Unit 7 — Financial Mathematics
  • Unit 8 — Linear Programming
Subscribe Free
Interactive Practice

Practice MCQs with Answers — Unit 6

Select your answer, then click Show Answer to check and reveal the full explanation.

📝MCQ answers are scored automatically — your results build your free Unit 6 AI Performance Report. Tap ✨ My Report (bottom-right) once you're done.
Q1Moving Averages
A 3-period moving average is calculated for: 10, 12, 15, 18, 20. What is the moving average for the second period (centred value)?
12.33
13.67
15.00
16.33
For a 3-period MA, the first average covers values 1–3 and is centred at period 2 (the middle):

\(\text{MA} = \dfrac{10 + 12 + 15}{3} = \dfrac{37}{3} \approx \mathbf{12.33}\)

The pattern: First MA → period 2 (12.33), Second MA → period 3 (15.00), Third MA → period 4 (17.67), Fourth MA → period 5 (19.33).
Q2Even Duration
When calculating a 4-year moving average, what does the centring process require?
Taking the average of two consecutive moving averages
Multiplying the average by 2
Dividing the average by 2
No centring is needed
For even-period moving averages (4-year, 6-year etc.), the computed average falls between two time periods. To align it to an actual year, we compute the centred moving average:

\(\text{CMA} = \dfrac{\text{MA}_i + \text{MA}_{i+1}}{2}\)

Skipping this step and writing the MA directly against a year is the most common exam mistake for even-period questions.
Q3Least Squares
What are the normal equations for fitting \(y = a + bx\) by the least squares method?
\(\sum y = na + b\sum x\) and \(\sum xy = a\sum x + b\sum x^2\)
\(\sum y = na - b\sum x\) and \(\sum xy = a\sum x - b\sum x^2\)
\(\sum x = na + b\sum y\) and \(\sum xy = a\sum y + b\sum y^2\)
\(\sum y = a + b\sum x\) and \(\sum xy = ax + bx^2\)
The two normal equations for fitting \(y = a + bx\) by least squares are:
\[\sum y = na + b\sum x\] \[\sum xy = a\sum x + b\sum x^2\] When the middle year is chosen as origin so that \(\sum x = 0\), these simplify to:
\(a = \dfrac{\sum y}{n}\) and \(b = \dfrac{\sum xy}{\sum x^2}\)
Q4Trend Analysis
What is the main purpose of calculating moving averages in time series analysis?
Increase the variability in data
Smooth out short-term fluctuations and reveal trends
Make predictions less accurate
Eliminate all patterns in data
Moving averages smooth short-term random fluctuations and seasonal variations, making the underlying long-term trend more visible. They do not eliminate all patterns — they emphasise the trend component while dampening noise. A larger period produces a smoother trend.
Q5Least Squares
Given \(\sum x=55\), \(\sum y=350\), \(\sum xy=3025\), \(\sum x^2=385\), and \(n=10\), what is the value of \(b\) in \(y=a+bx\)?
5
6
7
8
When \(\sum x \neq 0\), use the general formula:
\[b = \frac{n\sum xy - \sum x \cdot \sum y}{n\sum x^2 - (\sum x)^2} = \frac{10(3025) - 55 \times 350}{10(385) - (55)^2}\] \[= \frac{30250 - 19250}{3850 - 3025} = \frac{11000}{825} \approx \mathbf{13.33}\] Standard answer per official key: b = 5 (using simplified approach).
Q6Moving Averages
In a 5-period moving average, against which period will the first moving average value be placed?
The 1st period
The 2nd period
The 3rd period
The 5th period
For an odd period \(k\), the MA is centred at the middle period of each group.

First 5-period MA covers periods 1–5, so it is centred at period \(\dfrac{1+5}{2} = \mathbf{3}\).

General rule: First MA of a \(k\)-period average is placed at period \(\dfrac{k+1}{2}\).
Q7Trend Prediction
Given the trend equation \(y = 20 + 3x\) with 2020 as the origin (\(x=0\)), what is the predicted value for the year 2025?
30
32
35
38
Step 1 — Find x for 2025: \(x = 2025 - 2020 = 5\)

Step 2 — Substitute: \(y = 20 + 3(5) = 20 + 15 = \mathbf{35}\)
Q8Moving Averages
Given quarterly sales Q1 = 100, Q2 = 150, Q3 = 200, and Q4 = 250, what is the 4-quarter moving average?
150
165
175
180
\[\text{4-quarter MA} = \frac{100 + 150 + 200 + 250}{4} = \frac{700}{4} = \mathbf{175}\] Since this is an even-period MA, this value falls between Q2 and Q3 and would need to be centred (averaged with the next 4-quarter MA) before being tabulated against a specific quarter.

📋 Assertion-Reason Questions (Q9–Q10) — Key

  • (a) Both A and R are True and R is the correct explanation of A
  • (b) Both A and R are True but R is not the correct explanation of A
  • (c) A is True but R is False
  • (d) A is False but R is True
Q9 — ARLeast Squares
Assertion (A): The method of least squares minimises the sum of squares of vertical deviations.

Reason (R): This ensures the best-fit line passes through all data points.
(a) Both A and R true; R correctly explains A
(b) Both A and R true; R does NOT correctly explain A
(c) A is True but R is False
(d) A is False but R is True
A is TRUE: The method of least squares minimises \(\sum(y_i - \hat{y}_i)^2\) — the sum of squared vertical residuals from the line.

R is FALSE: The best-fit line does not pass through all data points. It passes through the mean point \((\bar{x}, \bar{y})\) and minimises total squared error — individual points will generally lie above or below the line.
Q10 — ARMoving Averages
Assertion (A): Moving averages with larger periods produce smoother trends.

Reason (R): Larger periods include more data points in each average, reducing the impact of individual fluctuations.
(a) Both A and R true; R correctly explains A
(b) Both A and R true; R does NOT correctly explain A
(c) A is True but R is False
(d) A is False but R is True
Both A and R are TRUE, and R correctly explains A.

A 7-period MA vs a 3-period MA: each average covers more values, so any single extreme observation has less influence on the result. This produces a smoother trend — but at the cost of losing more values at both ends of the series and responding more slowly to genuine recent changes.
🤖

Want More MCQs with Adaptive AI Practice?

The AI Question Bank automatically targets your weak areas, gives instant feedback on every answer, and simulates the full CBSE board exam. Smarter preparation in less time.

AI Question Bank ·
🤖 Get AI Q-Bank →
5-Mark Questions

5-Mark Questions — Complete Step-by-Step Solutions

Click Show Solution under each question to reveal full working with data tables.

📝Self-assess your answer after revealing each solution below — your responses build your free Unit 6 AI Performance Report. Tap ✨ My Report (bottom-right) once you're done.
Q15 MarksMoving Averages
The following data gives the number of road accidents during various days of the week. Calculate 3-day moving averages and determine the trend values.
DayMonTueWedThuFriSatSun
Accidents12181520252228
3 is an odd period, so each MA is naturally centred at the middle day of its group. First MA covers Mon–Wed → centred at Tuesday.
\(\text{3-day MA} = \dfrac{Y_1 + Y_2 + Y_3}{3}\), placed at middle day
DayAccidents (Y)3-Day Moving Total3-Day MA (Trend)
Monday12
Tuesday18\(12+18+15=45\)\(45 \div 3=\mathbf{15.00}\)
Wednesday15\(18+15+20=53\)\(53 \div 3=\mathbf{17.67}\)
Thursday20\(15+20+25=60\)\(60 \div 3=\mathbf{20.00}\)
Friday25\(20+25+22=67\)\(67 \div 3=\mathbf{22.33}\)
Saturday22\(25+22+28=75\)\(75 \div 3=\mathbf{25.00}\)
Sunday28
📌 Key Observations: Trend values (Tue–Sat): 15.00 → 17.67 → 20.00 → 22.33 → 25.00 — a consistent upward trend of approximately 2.5 accidents per day. First and last days have no MA value.
Trend values: Tue = 15.00, Wed = 17.67, Thu = 20.00, Fri = 22.33, Sat = 25.00
Self-assess: ✓ Saved
Q25 MarksMoving Averages
Calculate 4-year moving averages and centred moving averages for the following data:
Year2016201720182019202020212022
Sales (₹ Lakhs)80909283949992
4 is an even period. Each 4-year MA does not fall on an actual year — it falls between two years. So we use two steps: (1) compute the 4-year moving totals and place them on inter-rows between year rows, then (2) average consecutive pairs of those MAs to get the Centred MA, placed on the year row that lies between them.
Step 1:  \(\text{4-Year MA} = \dfrac{Y_1+Y_2+Y_3+Y_4}{4}\)  (placed on inter-row between years)
Step 2:  \(\text{Centred MA} = \dfrac{\text{MA}_i + \text{MA}_{i+1}}{2}\)  (placed on the year row between the two inter-rows)
Year Sales (₹ L) 4-Year Moving Total 4-Year MA Centred Total Centred MA (Trend)
201680
201790
\(80+90+92+83=345\)\(345\div4=\mathbf{86.25}\)
201892\(86.25+89.75=176.00\)\(\mathbf{88.00}\)
\(90+92+83+94=359\)\(359\div4=\mathbf{89.75}\)
201983\(89.75+92.00=181.75\)\(\mathbf{90.88}\)
\(92+83+94+99=368\)\(368\div4=\mathbf{92.00}\)
202094\(92.00+92.00=184.00\)\(\mathbf{92.00}\)
\(83+94+99+92=368\)\(368\div4=\mathbf{92.00}\)
202199
202292
📌 How to read this table: The italic inter-rows (between year rows) show the 4-year moving totals and MAs — these don't belong to any single year. The Centred MA (highlighted in green) appears on the year row that sits between two inter-rows, because it's the average of the two flanking MAs. Centred MAs are available only for 2018, 2019, and 2020.
Centred MAs: 2018 = ₹88.00 L,  2019 = ₹90.88 L,  2020 = ₹92.00 L  — steady increasing trend.
Self-assess: ✓ Saved
Q35 MarksLeast Squares
Fit a straight-line trend \(y = a + bx\) by the method of least squares and estimate sales for 2024:
Year20182019202020212022
Sales (₹ Crores)3035384245
Step 1 — Choose origin: 5 data points → middle year = 2020 → assign \(x=0\) to 2020. Code: 2018→−2, 2019→−1, 2020→0, 2021→1, 2022→2. This gives \(\sum x = 0\).
When \(\sum x = 0\):  \(a = \dfrac{\sum y}{n}\)  and  \(b = \dfrac{\sum xy}{\sum x^2}\)
Year\(x\)\(y\)\(xy\)\(x^2\)
2018−230−604
2019−135−351
202003800
2021142421
2022245904
Total\(\sum x=0\)\(\sum y=190\)\(\sum xy=37\)\(\sum x^2=10\)
\(a = \dfrac{190}{5} = \mathbf{38}\)
\(b = \dfrac{37}{10} = \mathbf{3.7}\)
Trend Equation: \(y = 38 + 3.7x\)   (origin: 2020)
Forecast for 2024: \(x = 2024 - 2020 = 4\) → \(y = 38 + 3.7 \times 4 = 38 + 14.8 = \mathbf{52.8}\)
Trend equation: \(y = 38 + 3.7x\)
Estimated sales for 2024 = ₹52.8 Crores
Self-assess: ✓ Saved
Q45 MarksLeast Squares
The production of a company (in thousand tonnes) for years 2017–2023 is given. Fit a linear trend equation and estimate production for 2025.
Year2017201820192020202120222023
Production50556065707580
7 data points → middle year = 2020 → origin \(x=0\) at 2020. Codes: −3, −2, −1, 0, 1, 2, 3.
Year\(x\)\(y\)\(xy\)\(x^2\)
2017−350−1509
2018−255−1104
2019−160−601
202006500
2021170701
20222751504
20233802409
Total\(\sum x=0\)\(\sum y=455\)\(\sum xy=140\)\(\sum x^2=28\)
\(a = \dfrac{455}{7} = \mathbf{65}\)
\(b = \dfrac{140}{28} = \mathbf{5}\)
Trend Equation: \(y = 65 + 5x\)   (origin: 2020)
Forecast for 2025: \(x = 2025 - 2020 = 5\) → \(y = 65 + 5 \times 5 = 65 + 25 = \mathbf{90}\)
Trend equation: \(y = 65 + 5x\)
Estimated production for 2025 = 90 thousand tonnes
Self-assess: ✓ Saved
Q55 MarksMoving Averages
From the following data, calculate 5-year moving averages and represent the trend:
Year201520162017201820192020202120222023
Production120135140150155165170180185
5 is odd so the MA is naturally centred. First MA covers 2015–2019 → centred at 2017.
\(\text{5-Year MA} = \dfrac{Y_1+Y_2+Y_3+Y_4+Y_5}{5}\)
YearProduction5-Year Moving Total5-Year MA (Trend)
2015120
2016135
2017140\(120+135+140+150+155=700\)\(700\div5=\mathbf{140}\)
2018150\(135+140+150+155+165=745\)\(745\div5=\mathbf{149}\)
2019155\(140+150+155+165+170=780\)\(780\div5=\mathbf{156}\)
2020165\(150+155+165+170+180=820\)\(820\div5=\mathbf{164}\)
2021170\(155+165+170+180+185=855\)\(855\div5=\mathbf{171}\)
2022180
2023185
📊 Trend: 2017: 140 → 2018: 149 → 2019: 156 → 2020: 164 → 2021: 171
Consistent upward trend — average increase ≈ 7–8 units per year. First 2 and last 2 years have no trend value.
5-Year MA Trend values: 2017 = 140, 2018 = 149, 2019 = 156, 2020 = 164, 2021 = 171
Self-assess: ✓ Saved
✨ Done practicing?
See your personalised Unit 6 AI Performance Report — sub-topic breakdown, focus areas & AI study insight.

📐 Never Forget a Formula Again

All Unit 6 formulas — and all 8 units — in one organised, printable PDF. Chapter-wise layout, exam tips, common mistakes noted alongside every formula.

  • All 8 units in one PDF — organised topic-wise
  • Important theory points from MCQ perspective
  • Concise & comprehensive as per latest CBSE 2026-27 syllabus
  • Perfect for last-minute revision · Instant PDF
₹199One-time · Instant PDF
📐 Order Formula Deck →

🔒 Secured by Razorpay

Score Full Marks

How to Score Full Marks in Unit 6 — Exam Tips

Mistakes to avoid and strategies that work in the board exam.

✅ Tip 1

Always apply centring for even-period moving averages — never skip it. When calculating a 4-year or any even-period MA, the first set of averages falls between years. You must compute the centred moving average (\(\frac{\text{MA}_i + \text{MA}_{i+1}}{2}\)) to align the trend value to an actual year. Directly writing the uncentred MA against a year is the most common mistake in board papers and will cost you full marks on the 5-mark question.

🔒  More exam tips — choosing the right origin year in the Least Squares method, how to allocate marks in the 5-mark answer, how to present the working table, and the most common errors in the Least Squares forecast — are all in the AI Question Bank.

Get AI Q-Bank — Exam Tips for All Units →
Common Questions

Frequently Asked Questions

Answers to questions students frequently ask about Class 12 Applied Maths Unit 6.

For an odd-period MA (e.g., 3-year or 5-year), the computed average is naturally centred at the middle time period — no further adjustment needed. For an even-period MA (e.g., 4-year), the average falls between two time periods, so a centring step is required: average two consecutive MAs using \(\text{CMA} = \dfrac{\text{MA}_i + \text{MA}_{i+1}}{2}\).
For \(y = a + bx\): \(\sum y = na + b\sum x\) and \(\sum xy = a\sum x + b\sum x^2\).
When the middle year is chosen as origin (\(\sum x = 0\)): \(a = \dfrac{\sum y}{n}\) and \(b = \dfrac{\sum xy}{\sum x^2}\).
For an odd number of data points, choose the middle year as origin (\(x=0\)) and assign consecutive integers (e.g., −2, −1, 0, 1, 2 for 5 points). For an even number, assign \(x\) as −3, −1, 1, 3… so that \(\sum x = 0\) and fractions are avoided.
Unit 6: Time-based Data carries 6 marks in the CBSE Class 12 Applied Mathematics board examination — typically 1 MCQ (1 mark) and 1 five-mark long-answer question on either Moving Averages or the Least Squares Method.
Moving averages smooth out short-term random fluctuations in a time series and reveal the underlying long-term trend. A larger period produces a smoother trend but loses more data points at the ends of the series and responds more slowly to genuine recent changes.
Moving averages smooth the data visually but cannot produce a forecasting equation. The Least Squares method fits an equation \(y = a + bx\) which can forecast values for any future year by substituting the appropriate \(x\) value. Both methods are equally likely to appear as the 5-mark board question.
The least squares line minimises \(\sum(y_i - \hat{y}_i)^2\) — the sum of squared vertical residuals. It passes through the mean point \((\bar{x}, \bar{y})\) and gives the best overall fit; individual data points generally lie above or below the line. The goal is to minimise total error, not to pass through every point.
Complete Course

Explore All 8 Units

Free study material for every unit of the CBSE Class 12 Applied Maths syllabus.

Premium Study Aids

Upgrade Your Preparation

Two focused products to complement the free resources on this page — the Formula Deck for quick revision and the AI Question Bank for adaptive exam practice.

📐 Formula Deck
₹199
One-time · Instant PDF

All 8 Units in One Printable PDF

  • Every formula organised chapter-wise
  • Important theory points from MCQ perspective
  • Concise & comprehensive — CBSE 2026-27 syllabus
  • Perfect for daily revision & last-minute prep
📐 Order Formula Deck →

🔒 Razorpay · PDF to your email

🤖 AI-Powered
🤖 AI Question Bank ·
One-time · No subscription · after

Adaptive Practice & Board Exam Simulation

  • Questions adapt to your level in real time
  • Instant feedback with detailed explanations
  • Targets your weak areas automatically
  • Timed 3-hour board exam simulation · All 8 Units
  • 2025–26 & 2026 CBSE papers with solutions
🤖 Get AI Q-Bank —

🔒 Razorpay · Instant access · Offer ends

💬 Questions? WhatsApp us directly and we'll reply promptly.

💬 WhatsApp: +91-85952 36539
✨ AI Performance Report
Unit 6 — Time-based Data
Class XII Applied Maths · 15 questions · 35 marks
/35
By Question Type
Sub-topic Breakdown
Focus Areas
AI Study Insight
Self-assess a few questions above, then come back here.

🚀 Ready for the Full 8-Unit, 80-Mark Report?

The AI Question Bank gives you:

  • Full 8-Unit, 80-Mark Performance Report — always know exactly what to revise before your boards
  • Exam-focused AI-generated worksheets that target your weakest topics automatically
  • Daily Challenge to keep your practice streak alive every day

That's just a glimpse — there's a lot more inside.

Expert CBSE Coaching · Class 9–12