CAT 2021 Slot 1 DILR Q2

  • Data Interpretation and Logical Reasoning
  • Data Interpretation › Bar Graphs
  • Easy
  • Multiple choice
  • CAT_2021_SLOT1_DILR_Q02

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.

Diagram

Question 2

The percentage increase in sales in Furniture category from 2019 to 2020 is closest to

  1. A

    20%

    Answer A in PrepSoc practice
  2. B

    1%

    Answer B in PrepSoc practice
  3. C

    8%

    Answer C in PrepSoc practice
  4. D

    25%

    Answer D in PrepSoc practice

Answer this questionOr tap an option. Opens in practice mode, free, no sign-in.

Show answer and solution

Answer: (C)

8%

Solution

Concept: Category-Level Percentage Growth Calculation

Master State Table

CategorySubcategory2019 (₹M)2020 (₹M)Change (₹M)Growth (%)
FurnitureBookcases1.902.20+0.30+15.8%
FurnitureChairs6.207.00+0.80+12.9%
FurnitureFurnishings2.052.10+0.05+2.4%
FurnitureTables4.404.50+0.10+2.3%
Office SuppliesBinders3.605.30+1.70+47.2%
Office SuppliesArt0.400.60+0.20+50.0%
Office SuppliesAppliances1.903.10+1.20+63.2%
Office SuppliesEnvelopes0.350.20-0.15-42.9%
Office SuppliesFasteners0.100.100.000.0%
Office SuppliesLabels0.200.30+0.10+50.0%
Office SuppliesPaper1.502.00+0.50+33.3%
Office SuppliesStorage4.305.10+0.80+18.6%
Office SuppliesSupplies1.101.20+0.10+9.1%
TechnologyAccessories3.104.40+1.30+41.9%
TechnologyCopiers3.604.60+1.00+27.8%
TechnologyMachines4.103.20-0.90-22.0%
TechnologyPhones5.807.70+1.90+32.8%

Question Deduction

• Scope & Constituent Subcategories:

• Furniture encompasses the top 4 subcategories: Bookcases, Chairs, Furnishings, and Tables.

• Sales Extraction (2019 vs. 2020):

• Reading 2019 ticks and 2020 bar endpoints:

• Bookcases: 2019 sales $\approx 1.90$ million ₹; 2020 sales $\approx 2.20$ million ₹.

• Chairs: 2019 sales $\approx 6.20$ million ₹; 2020 sales $= 7.00$ million ₹ (at 7.0 grid line).

• Furnishings: 2019 sales $\approx 2.05$ million ₹; 2020 sales $\approx 2.10$ million ₹.

• Tables: 2019 sales $\approx 4.40$ million ₹; 2020 sales $= 4.50$ million ₹ (at 4.5 grid line).

• Aggregate Growth & Percentage Change:

• Total Furniture sales in 2019:

$$\text{Sales}_{2019} = 1.90 + 6.20 + 2.05 + 4.40 = 14.55\text{ million ₹}$$

• Total Furniture sales in 2020:

$$\text{Sales}_{2020} = 2.20 + 7.00 + 2.10 + 4.50 = 15.80\text{ million ₹}$$

• Absolute sales increase:

$$\Delta = 15.80 - 14.55 = 1.25\text{ million ₹}$$

• Percentage increase:

$$\text{Percentage Increase} = \frac{1.25}{14.55} \times 100\% \approx 8.59\%$$

• Option Matching:

• Distance to given choices {20%,1%,8%,25%}\{20\%, 1\%, 8\%, 25\%\}:

• $\vert 8.59\% - 8\% \vert = 0.59\%$ (Closest)

• $\vert 8.59\% - 1\% \vert = 7.59\%$

• $\vert 8.59\% - 20\% \vert = 11.41\%$

• $\vert 8.59\% - 25\% \vert = 16.41\%$

• Matches Option 3 (8%).

Topper Take

• Benchmark test: 10%10\% of 14.5514.55 is ≈1.46\approx 1.46. Because the actual growth of 1.251.25 is slightly below 10%10\% and far above 1%1\%, 8%8\% is chosen instantly without manual division.

Other questions in this set

  1. Q1. The total sales (in million ₹) in 2019 from products in office supplies category is closest to
  2. Q3. How many subcategories had sales of ₹ 4 million or more in 2019 and registered an increase in sales in excess of 25%…
  3. 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

  1. CAT 2025 Slot 2 DILR Q15
    What was the total number of two-author and three-author papers written by Brajen?
  2. CAT 2025 Slot 2 DILR Q16
    Which of the following statements is/are NECESSARILY true? i. Chintan wrote exactly three two-author papers.…
  3. CAT 2025 Slot 2 DILR Q17
    Which of the following statements is/are NECESSARILY true? i. Arman wrote three-author papers only with…
  4. CAT 2025 Slot 2 DILR Q18
    If Devon wrote more than one two-author papers, then how many two-author papers did Chintan write?
  5. CAT 2024 Slot 1 DILR Q14
    What was the total number of stars received by D?

Practise this question with timing, notes and your mistake notebook.

Practise in PrepSoc