Table-Based Data Interpretation
Subject: Reasoning (Data Interpretation) | Frequency: 3-5 questions per APPSC paper | Time: 45-60 sec/question
Introduction
Table DI questions present data in rows and columns, followed by 3-5 questions requiring percentage, ratio, average, or comparison calculations. APPSC favours percentage change, averages, and "which is highest/lowest" questions. Approximate aggressively — exam options are usually spaced far enough for estimation.
Core Method
- Read the table structure — understand rows (items/years) and columns (categories/values)
- Read the question carefully — identify EXACTLY which cells you need
- Extract relevant data — ignore irrelevant rows/columns
- Perform the calculation — percentage, ratio, average, difference
- Approximate when possible — options usually 10%+ apart
- Double-check units — lakhs vs crores, thousands vs actual
Key Formulas
| Calculation | Formula |
|---|---|
| Percentage | (Part / Whole) x 100 |
| % Change | ((New - Old) / Old) x 100 |
| Average | Sum / Count |
| Ratio | A : B (simplify by GCD) |
| % of a number | (Percentage / 100) x Number |
Quick Percentage Shortcuts
| Fraction | Percentage |
|---|---|
| 1/2 | 50% |
| 1/3 | 33.33% |
| 1/4 | 25% |
| 1/5 | 20% |
| 1/6 | 16.67% |
| 1/8 | 12.5% |
| 1/10 | 10% |
| 2/3 | 66.67% |
| 3/4 | 75% |
Worked Examples
Example Table: Production of Cars (in thousands)
| Year | Company A | Company B | Company C | Company D | Company E |
|---|---|---|---|---|---|
| 2018 | 40 | 35 | 50 | 45 | 30 |
| 2019 | 45 | 40 | 48 | 50 | 35 |
| 2020 | 38 | 42 | 55 | 48 | 32 |
| 2021 | 50 | 45 | 60 | 52 | 40 |
| 2022 | 55 | 50 | 58 | 55 | 45 |
Easy
Q1: Total production of Company C across all years?
- 50 + 48 + 55 + 60 + 58 = 271 thousand
Q2: Percentage increase in Company A from 2018 to 2022?
- Change = 55 - 40 = 15
- % increase = (15/40) x 100 = 37.5%
Q3: Which year had the highest total production?
- 2018: 200, 2019: 218, 2020: 215, 2021: 247, 2022: 263
- Answer: 2022 (263 thousand)
Medium
Q4: Ratio of Company B (2019) to Company D (2020)?
- B(2019) = 40, D(2020) = 48
- 40:48 = 5:6
Q5: Average production of Company E across all years?
- (30 + 35 + 32 + 40 + 45) / 5 = 182/5 = 36.4 thousand
Q6: Which company showed maximum % increase from 2020 to 2021?
- A: (50-38)/38 x 100 = 31.6%
- B: (45-42)/42 x 100 = 7.1%
- C: (60-55)/55 x 100 = 9.1%
- D: (52-48)/48 x 100 = 8.3%
- E: (40-32)/32 x 100 = 25%
- Answer: Company A (31.6%)
Hard
Q7: What percentage of total 2021 production does Company D account for?
- D(2021) = 52, Total(2021) = 247
- % = (52/247) x 100 = approx 21%
Q8: If Company C's production increases by 10% in 2023 over 2022, what is 2023 production?
- C(2022) = 58
- 58 x 1.10 = 63.8 thousand
Q9: Which company had the most consistent production (smallest range)?
- A: 55-38=17, B: 50-35=15, C: 60-48=12, D: 55-45=10, E: 45-30=15
- Answer: Company D (range = 10)
Shortcuts & Tricks
| Shortcut | When to Use |
|---|---|
| Approximate early | If options differ by >5%, rough calculation suffices |
| Fraction shortcuts | 1/4=25%, 1/3=33%, 1/5=20% — use instead of dividing |
| Compare, don't calculate | For "which is highest", visual comparison often works |
| % change: focus on ratio | If new is ~1.5x old, increase is ~50% |
| Round to nearest 5 or 10 | 48 becomes 50, 42 becomes 40 for quick estimation |
| Column sums: add largest+smallest first | Gives a range to check against |
Common Mistakes
- Reading wrong row/column — double-check year and company before extracting
- % OF vs % CHANGE — "what % of total" uses total as denominator; "% change" uses OLD value
- Wrong denominator — % change uses OLD value, not new
- Unit confusion — check if table is in thousands, lakhs, or crores
- Not simplifying ratios — 40:48 should be 5:6
Exam Strategy
- Read table structure first, then go question by question
- Approximate aggressively — options are designed for estimation
- APPSC gives 3-5 questions from one table — invest time understanding the table
- Time: 45-60 seconds per question after understanding the table
- For "which year/company" questions, visual comparison is faster than full calculation
- Negative marking: -0.333 — approximation makes you fast AND confident
Practice Questions
Using the table above:
- Total production of all companies in 2019? → 45+40+48+50+35 = 218 thousand
- % decrease in Company C from 2019 to 2020? → (48-55)/48... wait, C went UP. Let me recheck: C 2019=48, 2020=55. Increase, not decrease. → No decrease; it increased by 14.6%
- Ratio of A(2021) to E(2021)? → 50:40 = 5:4
- Average production of Company B? → (35+40+42+45+50)/5 = 212/5 = 42.4 thousand
- Year with maximum total production increase over previous year? → 2018→2019: +18, 2019→2020: -3, 2020→2021: +32, 2021→2022: +16 → 2021 (+32)
Key Terms / Formulas
| Term | Meaning |
|---|---|
| % Change | ((New - Old) / Old) x 100 |
| Ratio | A : B simplified by GCD |
| Average | Sum / Count |
| Range | Maximum - Minimum (measures consistency) |
| CAGR | ((Final/Initial)^(1/n) - 1) x 100 |