Data Interpretation – DILR (MBA)
Program: CAT | Subject: DILR | Topic: Data Interpretation
Data Interpretation (DI) is the systematic analysis of data presented in tables, graphs, charts, and figures. It is a core component of the CAT and many management entrance exams. Mastery of DI requires quick comprehension, logical reasoning, and efficient calculation.
1. Simple Explanation
DI asks you to read a data set and answer questions that test your ability to:
- Extract relevant information (numbers, percentages, ratios, etc.).
- Compare values across rows/columns or time periods.
- Calculate derived figures (growth rates, averages, percentages, etc.) using minimal arithmetic.
- Interpret the underlying trend or pattern.
Example: A table shows sales of a product for 4 quarters. A question might ask for the quarter with the highest growth rate or the overall percentage increase.
2. Key Points & Concepts
| # | Concept | Why It Matters | Quick Tips |
|---|---|---|---|
| 1 | Data Types | Tables, bar/line graphs, pie charts, scatter plots, box plots | Know how to read each quickly |
| 2 | Units & Scale | Units (dollars, units, %, time) | Convert units if needed; note the scale (e.g., 0–100 vs. 0–10) |
| 3 | Derived Measures | Mean, median, mode, percentage change, CAGR, ratio | Practice formulas; use mental math tricks |
| 4 | Comparative Analysis | Highest/lowest, difference between two items, trend direction | Use “top‑to‑bottom” or “left‑to‑right” strategy |
| 5 | Logical Deduction | Inference from given data (e.g., if X > Y and Y > Z, then X > Z) | Write inferences in one sentence |
| 6 | Answering in One Step | Many CAT DI questions need a single step solution | Avoid unnecessary calculations; use shortcuts |
| 7 | Time Management | 30–35 min for 12–15 DI questions | Allocate 2–3 min per question; skip if stuck > 5 min |
| 8 | Accuracy vs. Speed | Aim for ≥ 80 % accuracy | Practice with timed mock tests |
3. Types of DI Questions (Common Formats)
| Format | Typical Question | Example |
|---|---|---|
| Single-Table | Largest value, ratio, growth | “Which quarter had the highest growth?” |
| Multiple-Table | Compare two tables (e.g., sales vs. profit) | “Which product had the highest profit margin?” |
| Graphical | Bar/line chart trend, pie chart proportion | “What is the percentage of market share held by Company X?” |
| Data Sufficiency | Determine if given data is enough | “Can you determine the average growth rate?” |
| Data Interpretation + Reasoning | Combine DI with reasoning (e.g., “If A > B and B > C, which is largest?”) | Standard CAT DI style |
4. Worked Example
Problem Statement
A company’s quarterly sales (in ₹ lakhs) for FY 2023–24 are given below:
| Quarter | Sales (₹ lakhs) | Units Sold (units) |
|---|---|---|
| Q1 | 1,200 | 30,000 |
| Q2 | 1,500 | 32,000 |
| Q3 | 1,350 | 28,000 |
| Q4 | 1,800 | 40,000 |
Questions
a) Which quarter had the highest sales growth compared to the previous quarter?
b) What is the average units sold per ₹ lakh of sales for the year?
c) In which quarter did the company achieve the highest units sold per ₹ lakh of sales?
Step‑by‑Step Solution
a) Highest Sales Growth
- Compute growth percentages for Q2, Q3, Q4 relative to the previous quarter.
- Q2: ((1500 - 1200)/1200 \times 100 = 25%)
- Q3: ((1350 - 1500)/1500 \times 100 = -10%)
- Q4: ((1800 - 1350)/1350 \times 100 = 33.33%)
- Highest growth = 33.33 % in Q4.
b) Average Units Sold per ₹ Lakh of Sales
- Total units sold = 30,000 + 32,000 + 28,000 + 40,000 = 130,000 units
- Total sales = 1,200 + 1,500 + 1,350 + 1,800 = 5,850 ₹ lakhs
- Average units per ₹ lakh = (130,000 ÷ 5,850 ≈ 22.22) units per ₹ lakh.
c) Highest Units Sold per ₹ Lakh
Compute units per ₹ lakh for each quarter:
| Quarter | Units | Sales | Units per ₹ lakh |
|---|---|---|---|
| Q1 | 30,000 | 1,200 | 25.00 |
| Q2 | 32,000 | 1,500 | 21.33 |
| Q3 | 28,000 | 1,350 | 20.74 |
| Q4 | 40,000 | 1,800 | 22.22 |
Highest ratio = 25.00 (Q1).
Quick Answer Summary
| Q | Answer |
|---|---|
| a | Q4 (33.33 %) |
| b | 22.22 units per ₹ lakh |
| c | Q1 (25.00 units per ₹ lakh) |
5. Quick Revision Summary (Bullet Points)
- Read the data first – note units, scale, and any special symbols.
- Identify what the question asks: largest, smallest, ratio, trend, difference.
- Use mental math:
- Percent change ≈ (Δ/previous) × 100.
- Ratios can be