An Initiative by SAARTHI IAS
Maarg Manthan · Topic 25.8

Data Interpretation Involving Ratio and Percentage Change Across Multiple Years

Quantitative Aptitude › Data Interpretation · Topic 25.8

Data interpretation involving ratio and percentage change across multiple years compares how two or more quantities move over time. The solver finds year-on-year percentage changes, ratios between series, and total growth between the first and last year.

Share:
Data Interpretation Involving Ratio and Percentage Change Across Multiple Years - Quantitative Aptitude - MaargX UPSC Maarg Manthan

Quick Answer

Data interpretation involving ratio and percentage change across multiple years compares how two or more quantities move over time. The solver finds year-on-year percentage changes, ratios between series, and total growth between the first and last year.

At a Glance

  • Year-on-year change (This year – Last year) / Last year
  • Total growth (Last year – First year) / First year
  • Ratio of series A : B each year
  • Base year The year used as the reference
  • Trap Adding yearly percentages
  • Data used here Fictional practice data

Where Does It Fit?

This topic follows Missing Data/Value Estimation in Data Interpretation Sets and builds on Data Interpretation Involving Percentage, Ratio and Average Calculations. It applies the growth ideas of Successive Percentage Change (Two or More Successive Changes) to a table that spans several years, and prepares for the approximation methods of Approximation-Based Techniques for Fast Calculation in Data Interpretation.

How Do You Read a Multi-Year Table?

In short: a multi-year table has one column per series and one row per year. Each question compares two years or two series, so mark the years first.

The fictional set below gives the exports of two firms over five years, with ratios and percentage changes already calculated so that you can follow the working.

Year Firm A exports (Rs crore) Firm B exports (Rs crore) A : B A change % B change %
2021 200 150 4 : 3 – –
2022 220 180 11 : 9 10% 20%
2023 275 216 275 : 216 25% 20%
2024 330 270 11 : 9 20% 25%
2025 363 297 11 : 9 10% 10%

Formulas

  • Year-on-year change = (This year – Previous year) / Previous year × 100.
  • Total growth over the period = (Last year – First year) / First year × 100.
  • Ratio of A to B in a year = A’s value : B’s value, reduced.
  • Difference between series = Larger value – Smaller value.

What Is the Base-Year Trap?

In short: percentage changes in consecutive years cannot be added, because each year’s change is on a different base.

  • Firm A: yearly changes are 10%, 25%, 20% and 10%. Their sum is 65%, but the total growth is (363 – 200) / 200 = 81.5%.
  • Firm B: yearly changes are 20%, 20%, 25% and 10%. The total growth is (297 – 150) / 150 = 98%.
  • Successive changes: multiply the factors instead. For A, 1.10 × 1.25 × 1.20 × 1.10 = 1.815, which is 81.5% growth.
  • Percentage points: a fall from 25% to 10% is 15 percentage points. See Percentage Points vs Percentage Change Distinction Problems.

How Do You Compare Two Series Over Time?

In short: compare ratios year by year to see whether one series is catching up, and compare totals for the combined picture.

  • Ratio trend: A : B is 4 : 3 in 2021 and 11 : 9 in 2022, 2024 and 2025. Since 4 : 3 is 1.33 and 11 : 9 is 1.22, B has moved closer to A.
  • Difference trend: the gap A – B is 50, 40, 59, 60 and 66, so the gap is not steadily falling even though the ratio is.
  • Combined growth: the sum of both firms was 350 in 2021 and 660 in 2025, a growth of 310 / 350 = 88.57%.
  • Which grows faster: B’s total growth of 98% is higher than A’s 81.5%, even though A’s exports are larger.

Solved Examples

Example 1

Question: What was the percentage change in Firm A’s exports from 2022 to 2023?

  1. 2022 = 220 and 2023 = 275.
  2. Change = 55.
  3. 55 / 220 × 100 = 25%.

Answer: 25%.

Example 2

Question: What is the ratio of Firm A’s exports to Firm B’s exports in 2025?

  1. A = 363 and B = 297.
  2. HCF of 363 and 297 is 33.
  3. 363 / 33 = 11 and 297 / 33 = 9.

Answer: 11 : 9.

Example 3

Question: What is Firm B’s total percentage growth from 2021 to 2025?

  1. 2021 = 150 and 2025 = 297.
  2. Increase = 147.
  3. 147 / 150 × 100 = 98%.

Answer: 98%.

Example 4

Question: By what percentage did the combined exports of both firms grow from 2021 to 2025 (to two decimal places)?

  1. Combined 2021 = 200 + 150 = 350.
  2. Combined 2025 = 363 + 297 = 660.
  3. Growth = 310 / 350 × 100 = 88.57%.

Answer: About 88.57%.

Example 5

Question: In which year did Firm B show the highest year-on-year growth?

  1. B’s changes: 20%, 20%, 25%, 10%.
  2. The highest is 25%, from 2023 to 2024.

Answer: 2024.

Shortcuts and Tricks

  • Never add yearly percentages. Multiply growth factors or use first and last values.
  • Use the first year as the base for total growth.
  • Reduce ratios by the HCF, and convert them to decimals only to compare trends.
  • Write year-on-year changes in a short row before answering the questions.
  • Check that the final-year value equals the first-year value times the product of the factors.

Common Mistakes

  • Adding yearly percentage changes to get total growth.
  • Using the last year as the base for total growth.
  • Reversing the ratio of the two series.
  • Confusing a smaller gap with a smaller ratio.
  • Ignoring that a larger firm can grow more slowly than a smaller one.

Practice Questions

  1. What was Firm B’s percentage change from 2023 to 2024?
  2. What is Firm A’s total percentage growth from 2021 to 2025?
  3. What is the difference between the exports of the two firms in 2024?
  4. What is the ratio of Firm A’s 2021 exports to Firm A’s 2025 exports?
  5. What is the average of Firm B’s exports over the five years?
  6. Is Firm A’s exports ratio to Firm B’s higher in 2021 or in 2025?

Answers: 1) 25%; 2) 81.5%; 3) Rs 60 crore; 4) 200 : 363; 5) Rs 222.6 crore; 6) 2021 (4 : 3 against 11 : 9).

Why Is This Topic Important?

  • Frequency Multi-year sets are among the most common DI sets.
  • Concept They test growth and successive change from Successive Percentage Change (Two or More Successive Changes).
  • Trap awareness Adding percentages is a classic error.
  • Next step Speed methods in Approximation-Based Techniques for Fast Calculation in Data Interpretation are used here.

What Comes Next?

The next topic is Data Interpretation with Two-Variable Comparison Charts (Radar, Scatter and Combination Graphs). It looks at charts with two variables, such as scatter, radar and combination graphs.

Key Terms and Formulas

  • Year-on-year Compared with the previous year
  • Base year The year used as reference
  • Growth factor 1 + percentage change as a decimal
  • Total growth Change from first to last year
  • Ratio trend How a ratio moves over time
  • Gap The difference between two series

Exam Corner

Points to Remember

  • Yearly percentage changes cannot be added.
  • Total growth uses the first year as base.
  • Reduce ratios to the lowest terms.
  • Compare series by ratio and by difference.
  • A bigger series can grow slower.

Do Not Confuse With

  • Year-on-year vs total growth One compares adjacent years, and the other compares first and last years.
  • Ratio vs difference A shrinking ratio does not mean a shrinking gap.
  • Percentage vs percentage point Percentage points are a plain subtraction of two percentages.
  • Growth factor vs percentage A factor of 1.25 means 25 per cent growth.

Memory Hook

Multiply the changes, never add them.

GS Relevance

Multi-year ratio and percentage-change data interpretation for SSC CGL, CAT and CSAT: year-on-year growth, ratios between series and overall growth.

Frequently Asked Questions

How do you find year-on-year percentage change in a DI table?

Year-on-year percentage change is found by subtracting last year's value from this year's, dividing by last year's value and multiplying by 100. Exports rising from 220 to 275 crore is a change of 55 on a base of 220, which is 25 per cent.

Why can yearly percentage changes not be added?

Yearly percentage changes cannot be added because each change is measured on a different base, the previous year's value. Firm A's yearly changes of 10, 25, 20 and 10 per cent sum to 65, but its true total growth from 200 to 363 crore is 81.5 per cent.

How do you calculate total growth over several years?

Total growth over several years is found by subtracting the first year's value from the last year's, dividing by the first year's value and multiplying by 100. Firm B growing from 150 to 297 crore has a total growth of 147 divided by 150, which is 98 per cent.

How do you compare two series across years?

Two series are compared across years by calculating the ratio between them each year and by checking the difference. Firm A's ratio to Firm B fell from 4 to 3 in 2021 to 11 to 9 later, so B grew faster, even though A's lead in rupees was still larger.

What is a growth factor?

A growth factor is one plus the percentage change expressed as a decimal, so a 25 per cent rise has a factor of 1.25. Successive changes are found by multiplying factors, and the product minus one gives the total percentage change over the whole period.

PYQ Practice — Statement Analysis

1 Total growth over four years equals the sum of the four yearly percentage changes.
False

Each change has a different base, so the factors must be multiplied.

2 Total growth is measured on the first year as the base.
True

It is the change from first to last year divided by the first year's value.

3 Firm A's exports grew from 200 to 363 crore, a total growth of 81.5 per cent.
True

163 / 200 = 0.815.

4 A smaller ratio between two series always means a smaller difference.
False

The ratio can fall while the gap in rupees rises.

Share: