Comparative Tables (5 questions) — Study Notes

Overview

Comparative tables present multiple rows and columns where data from different categories, time periods, regions, or entities must be analyzed together. In UPSSSC PET, you will face **5 questions** based on one or two comparative tables, requiring you to extract information, compute percentages, find ratios, identify trends, and perform multi-step calculations. Unlike simple single-table problems, comparative analysis demands careful cross-referencing between rows and columns, attention to units, and often mental arithmetic under time pressure.

Mastery of comparative tables directly impacts your score in the Data Interpretation section. Questions typically involve year-wise production data, state-wise expenditure, company performance metrics, or demographic statistics across regions. The key to success is structured reading: identify headers, scan row/column labels first, understand units (lakhs, crores, thousands), and then approach questions methodically. Since you have roughly **one minute per question**, efficient scanning and approximation skills are essential.

This topic tests numerical ability, logical reasoning, and attention to detail simultaneously. Strong preparation here helps you tackle similar formats in other state-level and banking exams as well.

Key Concepts

• **Row-Column Structure**: Comparative tables have multiple rows (e.g., states, years, products) and multiple columns (e.g., parameters like production, sales, exports). Always identify which dimension is in rows vs. columns before solving.

• **Units Matter**: Data may be in thousands, lakhs, crores, or percentages. Misreading units is the most common error. Always check the table header or footnote for unit specifications.

• **Cross-Referencing**: Questions often require comparing values across different rows or columns — e.g., "Which state had the highest growth from 2015 to 2020?" You must locate multiple cells and compute differences or ratios.

• **Percentage Change Formula**: Percentage change = [(New Value − Old Value) / Old Value] × 100. Used frequently when comparing data across years or categories.

• **Ratio and Proportion**: Questions may ask for the ratio of two quantities (e.g., ratio of exports to imports for State A). Simplify ratios to lowest terms for clarity.

• **Averaging and Aggregation**: Some questions require summing multiple values (e.g., total production across all states) or calculating averages (e.g., average sales over five years).

• **Ranking and Ordering**: Identify the highest, lowest, or median values. Quickly scan columns/rows instead of calculating every entry when ranking is asked.

• **Approximation Skills**: Exact calculations waste time. Round numbers intelligently (e.g., 4987 ≈ 5000) to speed up mental math without compromising accuracy significantly.

Formulas / Key Facts

• **Percentage Change** = [(New Value − Old Value) / Old Value] × 100
• **Percentage Increase** = [(Increase) / Original Value] × 100
• **Percentage Decrease** = [(Decrease) / Original Value] × 100
• **Ratio** = Value A : Value B (simplify by dividing both by their GCD)
• **Average** = Sum of all values / Number of values
• **Total** = Sum of individual components (watch for units)
• **Growth Rate** = [(Final Value − Initial Value) / Initial Value] × 100
• **Contribution Percentage** = (Part / Whole) × 100
• **Difference** = Larger Value − Smaller Value
• **Sum of Percentages**: When data is given as percentages of a total, ensure percentages add up to 100% if all categories are included.

Worked Examples

**Example 1: Percentage Change Comparison**

| State | Production 2018 (in '000 tons) | Production 2020 (in '000 tons) | |-----------|-------------------------------|-------------------------------| | Uttar Pradesh | 450 | 540 | | Bihar | 320 | 352 | | Haryana | 280 | 350 |

**Question**: Which state had the highest percentage increase in production from 2018 to 2020?

**Solution**:

• **UP**: Change = 540 − 450 = 90; Percentage = (90/450) × 100 = 20%
• **Bihar**: Change = 352 − 320 = 32; Percentage = (32/320) × 100 = 10%
• **Haryana**: Change = 350 − 280 = 70; Percentage = (70/280) × 100 = 25%

**Answer**: Haryana had the highest percentage increase (25%).

---

**Example 2: Ratio Calculation**

| Company | Revenue (₹ crores) | Expenditure (₹ crores) | |---------|-------------------|------------------------| | A | 120 | 90 | | B | 150 | 100 | | C | 200 | 160 |

**Question**: What is the ratio of profit to expenditure for Company B?

**Solution**:

• Profit for B = Revenue − Expenditure = 150 − 100 = 50 crores
• Ratio = Profit : Expenditure = 50 : 100 = 1 : 2

**Answer**: 1 : 2

---

**Example 3: Multi-Step Aggregation**

| Year | Export (₹ lakhs) | Import (₹ lakhs) | |------|-----------------|-----------------| | 2017 | 250 | 180 | | 2018 | 300 | 210 | | 2019 | 350 | 240 |

**Question**: What is the average trade surplus over the three years? (Trade surplus = Export − Import)

**Solution**:

• 2017 surplus = 250 − 180 = 70
• 2018 surplus = 300 − 210 = 90
• 2019 surplus = 350 − 240 = 110
• Total surplus = 70 + 90 + 110 = 270
• Average = 270 / 3 = 90 lakhs

**Answer**: ₹90 lakhs

Common Mistakes

• **Mistake**: Reading the wrong row or column due to careless scanning → **Fix**: Use a finger or pen to trace rows/columns; double-check labels before picking values.

• **Mistake**: Ignoring units and mixing lakhs with crores → **Fix**: Convert all values to the same unit before calculation. Remember: 1 crore = 100 lakhs.

• **Mistake**: Calculating percentage change as (New − Old) without dividing by Old → **Fix**: Always divide by the base (old) value and multiply by 100 for percentage.

• **Mistake**: Adding percentages directly when they refer to different bases → **Fix**: Convert percentages back to absolute values, perform operations, then reconvert if needed.

• **Mistake**: Spending too much time on exact arithmetic for options that are far apart → **Fix**: Use approximation. If options are 12%, 25%, 40%, 58%, rough rounding gives the answer quickly.

Quick Reference

• **First Step**: Identify row/column headers and units before reading any question.
• **Percentage Change Formula**: [(New − Old) / Old] × 100 — base is always the "old" or initial value.
• **Ratio Simplification**: Divide both terms by their HCF to get the simplest form.
• **Average = Total / Count** — sum all relevant values first, then divide.
• **Approximation saves time** — round intelligently when answer choices are distinct.
• **Cross-check units** — lakhs vs. crores, thousands vs. absolute numbers; convert before calculating.