CAT 2021 Slot 1 DILR Q3
- Data Interpretation and Logical Reasoning
- Data Interpretation › Bar Graphs
- Easy
- Type in the answer (TITA)
- CAT_2021_SLOT1_DILR_Q03
Data set · questions 1–4
The horizontal bars in the above diagram represent 2020 aggregate sales (in million ₹) of accompany for the different subcategories of its products. The top four product subcategories (Bookcases, Chairs, Furnishings, Tables) belong to furniture product category; the bottom four product subcategories (Accessories, Copiers, Machines, Phones) belong to the technology product category while all other product subcategories belong to the office supply product category. For each of the product subcategories, there is a vertical line indicating the sales of the corresponding subcategory in 2019.
Question 3
How many subcategories had sales of ₹ 4 million or more in 2019 and registered an increase in sales in excess of 25% in 2020?
Type-in-the-answer (TITA) question: no options are given; enter the value.
Show answer and solution
Answer:
1
Solution
Concept: Dual-Threshold Filtering & Compound Growth Screening
Master State Table
| Category | Subcategory | 2019 (₹M) | 2020 (₹M) | Change (₹M) | Growth (%) |
|---|---|---|---|---|---|
| Furniture | Bookcases | 1.90 | 2.20 | +0.30 | +15.8% |
| Furniture | Chairs | 6.20 | 7.00 | +0.80 | +12.9% |
| Furniture | Furnishings | 2.05 | 2.10 | +0.05 | +2.4% |
| Furniture | Tables | 4.40 | 4.50 | +0.10 | +2.3% |
| Office Supplies | Binders | 3.60 | 5.30 | +1.70 | +47.2% |
| Office Supplies | Art | 0.40 | 0.60 | +0.20 | +50.0% |
| Office Supplies | Appliances | 1.90 | 3.10 | +1.20 | +63.2% |
| Office Supplies | Envelopes | 0.35 | 0.20 | -0.15 | -42.9% |
| Office Supplies | Fasteners | 0.10 | 0.10 | 0.00 | 0.0% |
| Office Supplies | Labels | 0.20 | 0.30 | +0.10 | +50.0% |
| Office Supplies | Paper | 1.50 | 2.00 | +0.50 | +33.3% |
| Office Supplies | Storage | 4.30 | 5.10 | +0.80 | +18.6% |
| Office Supplies | Supplies | 1.10 | 1.20 | +0.10 | +9.1% |
| Technology | Accessories | 3.10 | 4.40 | +1.30 | +41.9% |
| Technology | Copiers | 3.60 | 4.60 | +1.00 | +27.8% |
| Technology | Machines | 4.10 | 3.20 | -0.90 | -22.0% |
| Technology | Phones | 5.80 | 7.70 | +1.90 | +32.8% |
Question Deduction
• Dual Criteria Definition:
• Criterion 1: (vertical tick at or right of 4.0 line).
• Criterion 2: (percentage growth strictly ).
• Filtering by 2019 Baseline ( Million ₹):
• Examining all 17 subcategories across the chart:
• Exactly 5 qualify: Chairs ($6.20$), Tables ($4.40$), Storage ($4.30$), Machines ($4.10$), and Phones ($5.80$).
• All remaining 12 subcategories have 2019 ticks $< 4.0$ million ₹ and are eliminated.
• Evaluating Criterion 2 on the 5 Candidates:
• Chairs: . Hurdle . Actual (Fails).
• Tables: . Hurdle . Actual (Fails).
• Storage: . Hurdle . Actual (Fails).
• Machines: Sales dropped from to million ₹ (negative growth, fails).
• Phones: . Hurdle . Actual (Satisfies!).
• Numerical Answer:
• Exactly 1 subcategory (Phones) meets both criteria simultaneously.
• Final Answer: 1.
Topper Take
• Visual scan: Only 5 subcategories cross the 4.0 tick line. A >25% increase requires the bar to outstretch the tick mark by at least one-quarter of baseline length; only Phones displays this prominent extension.
Other questions in this set
- Q1. The total sales (in million ₹) in 2019 from products in office supplies category is closest to
- Q2. The percentage increase in sales in Furniture category from 2019 to 2020 is closest to
- Q4. The improvement index for a category is the maximum percentage increase in sales from 2019 to 2020 among any of its…
Bar Graphs questions from other CAT papers
- CAT 2025 Slot 2 DILR Q15
- CAT 2025 Slot 2 DILR Q16
- CAT 2025 Slot 2 DILR Q17
- CAT 2025 Slot 2 DILR Q18
- CAT 2024 Slot 1 DILR Q14
Practise this question with timing, notes and your mistake notebook.
Practise in PrepSoc