Data Interpretation: Tables, Graphs and Data Sufficiency
CSAT data interpretation with worked examples — tables, bar and line graphs, pie charts, approximation shortcuts, absolute vs relative change, and data sufficiency.
SyllabusCSAT · Data interpretation (charts, graphs, tables, data sufficiency) — Class X level
Prerequisites: Data Interpretation — overview · Percentages for CSAT · Ratio, Proportion and Averages
The Hook: The Biggest Jump That Wasn’t
A company’s sales report shows one product rising by 42,000 units in a year and another by only 15,000. Which grew faster? The first — if you mean absolute change. But if the first product started at 210,000 units and the second at 75,000, the first grew 20% and the second 20% too. And over a longer period, the “small” product may well have grown fastest of all.
CSAT data-interpretation questions are built on exactly this ambiguity: absolute versus relative change, share versus size, percentage versus percentage points. The arithmetic is easy; reading the question precisely is the skill.
The Core Concept
1. The five calculations behind almost every DI question
| Asked for | Formula | Watch out for |
|---|---|---|
| Percentage change | $\dfrac{\text{New} - \text{Old}}{\text{Old}} \times 100$ | Base is the earlier value |
| Share of total | $\dfrac{\text{Part}}{\text{Total}} \times 100$ | Use the right year’s total |
| Ratio | $a : b$, simplified | Order of terms as asked |
| Average | $\dfrac{\text{Sum}}{\text{Count}}$ | Count the number of years correctly |
| Difference | $a - b$ | Units (thousands, lakhs, crores) |
2. Tables — worked example
Table 1. Sales of four products (thousand units). Illustrative data — not real figures.
| Product | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|
| P | 120 | 150 | 180 | 165 |
| Q | 80 | 96 | 90 | 108 |
| R | 200 | 190 | 210 | 252 |
| S | 50 | 60 | 75 | 90 |
| Total | 450 | 496 | 555 | 615 |
(a) Percentage growth of P from 2021 to 2022: $\dfrac{150 - 120}{120} \times 100 = 25\%$.
(b) Which product grew most, in percentage terms, from 2021 to 2024?
| Product | Change | Growth |
|---|---|---|
| P | 120 → 165 | 37.5% |
| Q | 80 → 108 | 35% |
| R | 200 → 252 | 26% |
| S | 50 → 90 | 80% |
R had the largest absolute rise (52 thousand) but S had the largest percentage rise.
(c) Share of R in total 2024 sales: $\dfrac{252}{615} \times 100$. Approximate: $0.4 \times 615 = 246$; the remaining 6 is about 1% of 615 → about 41%.
(d) Average annual sales of S: $\dfrac{50 + 60 + 75 + 90}{4} = \dfrac{275}{4} = 68.75$ thousand.
(e) Which products fell in some year? P in 2024 (180 → 165, −8.33%), Q in 2023 (96 → 90, −6.25%), R in 2022 (200 → 190, −5%). S never fell.
3. Bar and line graphs
- Read the axis scale and unit first — “in ₹ crore”, “in ‘000 tonnes”, “index (2015 = 100)”.
- On a line graph, the steepest segment shows the largest absolute change. It is not necessarily the largest percentage change, which depends on the starting level.
- When two series share an axis, compare their gaps for differences and their slopes for rates of change.
- Do not read values more precisely than the gridlines allow; options in CSAT are usually spaced to permit approximate reading.
4. Pie charts
A full circle is $360^\circ = 100\%$, so
$$1\% = 3.6^\circ \qquad \text{and} \qquad \text{Value} = \frac{\text{Angle}}{360^\circ} \times \text{Total}$$Worked example. A household’s monthly income of ₹60,000 is spent as shown (illustrative data):
| Head | Share | Central angle | Amount |
|---|---|---|---|
| Food | 30% | 108° | ₹18,000 |
| Rent | 25% | 90° | ₹15,000 |
| Education | 15% | 54° | ₹9,000 |
| Transport | 10% | 36° | ₹6,000 |
| Savings | 20% | 72° | ₹12,000 |
| Total | 100% | 360° | ₹60,000 |
Trap: two pie charts for different years show shares, not amounts. A smaller slice next year can still be a larger amount if the total grew.
5. Approximation tools
- Fraction table: $\tfrac{1}{8} = 12.5\%$, $\tfrac{1}{6} = 16.67\%$, $\tfrac{1}{7} \approx 14.29\%$, $\tfrac{1}{9} \approx 11.11\%$ — see the percentages page.
- Compare fractions by cross-multiplying: is $\tfrac{46}{450}$ larger than $\tfrac{59}{496}$? $46 \times 496 = 22{,}816$ and $59 \times 450 = 26{,}550$ → the second is larger.
- Round only when options are far apart. If two options differ by less than about 2%, calculate more precisely.
6. Data sufficiency
The question asks whether the given statements are enough to answer — you need not compute the final value.
graph TD
A[Read the question: what exactly must be fixed?] --> B{Statement 1 alone sufficient?}
B -->|Yes| C{Statement 2 alone sufficient?}
B -->|No| D{Statement 2 alone sufficient?}
C -->|Yes| E[Either statement alone]
C -->|No| F[Statement 1 alone]
D -->|Yes| G[Statement 2 alone]
D -->|No| H{Both together sufficient?}
H -->|Yes| I[Both together needed]
H -->|No| J[Neither, even together]UPSC’s answer options for data-sufficiency questions vary in wording from question to question — read them each time and map them to the five outcomes in the diagram.
Worked example 1. What is the speed of a train?
- It crosses a pole in 10 seconds.
- It crosses a 200 m platform in 20 seconds.
Statement 1 alone: $L = 10v$ — two unknowns. Not sufficient. Statement 2 alone: $L + 200 = 20v$ — two unknowns. Not sufficient. Together: $10v + 200 = 20v$ → $v = 20$ m/s. Both together are needed.
Worked example 2. What is the two-digit number?
- The sum of its digits is 9, and its tens digit is twice its units digit.
- The number is divisible by 9.
Statement 1: $t + u = 9$ and $t = 2u$ → $u = 3$, $t = 6$ → 63. Sufficient. Statement 2: 18, 27, 36, … — many numbers. Not sufficient. Statement 1 alone.
Memory Anchors
- “Old is the base” — every percentage change divides by the earlier value.
- “3.6 degrees per per cent.”
- “Steep is big, not fast” — the steepest line segment is the largest absolute change, not necessarily the fastest growth.
- DS order: “One, Two, Then Both” — test each alone before combining; never compute more than needed.
| Confusable pair | Rule |
|---|---|
| Absolute vs percentage change | Difference vs difference ÷ base |
| Share vs amount (pie charts) | Shares compare within a year; amounts need the total |
| Percent vs percentage point | 4% → 5% is +1 point, +25 per cent |
For Prelims
- Check the unit in the title or axis before answering — thousands, lakhs and crores change the answer by factors of 100.
- A product with the largest absolute rise need not have the largest percentage rise.
- In a pie chart, value = angle ÷ 360 × total; 1% = 3.6°.
- In data sufficiency, a statement is sufficient only if it fixes a single answer.
- “Cannot be determined” is correct only when the data truly do not fix the answer — not when the calculation is merely long.
Speed Strategy
- Read all the questions in a DI set before calculating. Several often need the same column totals — compute them once.
- Look at the options before calculating. If they are far apart, approximate; if close, compute precisely.
- Use the totals row. Add a “Total” row or column to the table in pencil at the start; many questions need it.
- Data sufficiency: decide sufficiency, not the value. Stop as soon as you know the answer is fixed.
- What to skip: a DI set with many columns and a dense, unfamiliar layout can consume ten minutes. Attempt one question; if it takes over two minutes, move on and return later.
Common Traps
Practice
Prelims (CSAT)
Questions 1–3 are based on Table 1 above (illustrative data).
In which year did the total sales of the four products show the highest percentage increase over the previous year?
Solution
Totals: 450, 496, 555, 615.
- 2022: $\dfrac{46}{450} \approx 10.2\%$
- 2023: $\dfrac{59}{496} \approx 11.9\%$
- 2024: $\dfrac{60}{555} \approx 10.8\%$
2024 has the largest absolute increase (60), but 2023 has the highest percentage increase.
Answer: B
What was the approximate share of product P in total sales in 2023?
Solution
$\dfrac{180}{555} \times 100$. Since $\tfrac{1}{3}$ of 555 is 185, the share is a little below 33.3%: $\dfrac{180}{555} \approx 32.4\%$.
Answer: C
What is the ratio of the total sales of Q to the total sales of S over the four years 2021–2024?
Solution
Q: $80 + 96 + 90 + 108 = 374$. S: $50 + 60 + 75 + 90 = 275$.
$374 : 275$; both are divisible by 11 → $34 : 25$.
Answer: A
Question: What is the length of a train?
- The train crosses a signal post in 12 seconds.
- The train crosses a 180 m platform in 21 seconds.
Which of the following is correct?
Solution
- Statement 1: $L = 12v$ — two unknowns. Not sufficient.
- Statement 2: $L + 180 = 21v$ — two unknowns. Not sufficient.
- Together: $12v + 180 = 21v$ → $v = 20$ m/s → $L = 240$ m. Sufficient.
Answer: C
In a pie chart of a household’s monthly spending (total ₹60,000), the sector for savings has a central angle of 72°. How much does the household save each month?
Solution
$\dfrac{72^\circ}{360^\circ} = \dfrac{1}{5} = 20\%$. Savings $= 0.2 \times 60{,}000 = ₹12{,}000$.
Answer: D
Quick Revision
| Situation | Method |
|---|---|
| Percentage change | Divide by the earlier value |
| Share of total | Part ÷ that year’s total |
| Pie chart | 1% = 3.6°; value = angle ÷ 360 × total |
| Absolute vs relative | Largest rise ≠ fastest growth |
| Comparing fractions | Cross-multiply |
| Units | Check thousands / lakhs / crores first |
| Data sufficiency | Each statement alone → then together → single answer? |
Key Takeaways
- Five calculations — change, share, ratio, average, difference — cover almost every DI question.
- Read the unit and the base before calculating.
- Approximate when options are far apart; calculate precisely when they are close.
- In pie charts, shares are not amounts unless totals are equal.
- In data sufficiency, test each statement alone first, and stop once the answer is fixed.
Related Topics
- Data Interpretation — quick revision
- Data Interpretation — practice questions
- Percentages for CSAT
- Ratio, Proportion and Averages for CSAT
- Time, Speed, Distance and Work