4.1 Table & Line Graph Data Interpretation

4.1 Table & Line Graph Data Interpretation

Data Interpretation (DI) forms the backbone of the Quantitative Aptitude section in the SBI PO Preliminary Examination and constitutes the entire quantitative paper in SBI PO Mains (titled Data Analysis & Interpretation). Among all graphical representations, Tables and Line Graphs are the most frequently tested formats. They test a candidate's ability to extract raw numerical information, process multi-variable relationships, apply rapid mental arithmetic, and make precise analytical comparisons under strict sectional time constraints.

---

1. Structural Anatomy of Banking Data Tables

Data tables in SBI PO are rarely simple two-column lookup charts. Instead, SBI designs tables with multiple nested variables, cumulative subtotals, ratios, and percentages that require multi-stage decoding.

Types of Table Sets in SBI PO

1. Ratio & Percentage Distribution Tables: Data is presented as total values alongside male-to-female ratios, officer-to-clerk ratios, or percentage breakdowns across departments.
2. Cumulative Data Tables: Values represent running totals over successive years or quarters. To find single-period values, you must subtract the previous period's value from the current period.
3. Financial Statement & Banking Tables: Data reflects financial metrics such as Total Deposits, Advances, Gross Non-Performing Assets (GNPA %), Net Interest Margin (NIM %), and Capital Adequacy Ratios across multiple bank branches or fiscal years.

Exam Tip: Notice how the table above does not directly provide Total Loans or Retail Loan amounts. To calculate the Retail Loans for South Zone, you must perform a 3-step chain calculation:
$\text{Total Loans} = 18,200 \times 0.65 = 11,830\text{ Cr}$ $\text{Retail Loans} = 11,830 \times \left(\frac{3}{5 + 3}\right) = 11,830 \times \frac{3}{8} = 4,436.25\text{ Cr}$

---

2. Line Graph Dynamics & Dual-Axis Interpretation

Line graphs track continuous data trends over consecutive time intervals (months, quarters, years). SBI PO tests both single-line and multi-line graphs, as well as complex Dual Y-Axis Line Graphs where two different metrics with distinct units are plotted on separate vertical axes.

  (Y1: Loans Disbursed in ₹ Cr)                     (Y2: NPA Rate %) 
   500 |-------------------● (480 Cr)                10% |---------● (9.2%)
   400 |--------● (390 Cr)     \                     8%  |---● (7.5%)
   300 |---● (280 Cr)           ● (310 Cr)           6%  |            ● (5.1%)
   200 |                                             4%  |
       +----------------------------------               +----------------------
         2021     2022     2023                            2021   2022   2023

Key Concepts for Line Graph Analysis

• Slope as Rate of Change: The steepness of a line segment represents the rate of growth or decline. A sharp upward slope indicates rapid percentage growth, whereas a shallow slope indicates modest growth.
• Visual Slope Comparison: If asked to find the year with the maximum percentage increase, compare the visual steepness of line segments before doing manual calculations. Eliminate shallow segments immediately.
• Dual Axis Alignment: Ensure you read each data line against its correct Y-axis. Placing a metric measured on the left axis against the right axis scale is a classic trap.

---

3. High-Speed Calculation Shortcuts for SBI PO DI

To complete 5 questions in under 4 minutes, traditional multiplication and division methods must be replaced by high-speed mental shortcuts.

Essential Percentage-to-Fraction Equivalents

$\frac{1}{6} \approx 16.67\% \quad | \quad \frac{1}{7} \approx 14.28\% \quad | \quad \frac{1}{8} = 12.50\% \quad | \quad \frac{1}{9} \approx 11.11\%$ $\frac{1}{11} \approx 9.09\% \quad | \quad \frac{1}{12} \approx 8.33\% \quad | \quad \frac{3}{8} = 37.50\% \quad | \quad \frac{5}{8} = 62.50\%$ $\frac{4}{7} \approx 57.14\% \quad | \quad \frac{5}{6} \approx 83.33\% \quad | \quad \frac{7}{9} \approx 77.78\% \quad | \quad \frac{7}{12} \approx 58.33\%$

The Split-and-Merge Percentage Method

To calculate $17.5%$ of $48,000$:

1. Find $10% = 4,800$
2. Find $5% = 2,400$ (half of $10%$)
3. Find $2.5% = 1,200$ (half of $5%$)
4. Sum: $4,800 + 2,400 + 1,200 = 8,400$

Percentage Change Formula

$\text{Percentage Change} = \left( \frac{\text{Final Value} - \text{Initial Value}}{\text{Initial Value}} \right) \times 100$

---

4. Realistic Worked Example 1: Multi-Year Bank Performance Table

Directions (Q1–Q2): Study the following table showing financial parameters of 4 Public Sector Banks over 3 fiscal years (values in ₹ Crores) and answer the questions.

Problem 1: Absolute Gross NPA Calculation

Question: What is the total amount of Gross NPA (in ₹ Crores) combined for all 4 banks in FY22?

Step-by-step Solution:

1. Calculate Gross NPA for Bank A (FY22):
   $\text{NPA}_A = 6.5\% \text{ of } 52,000 = 0.065 \times 52,000 = 3,380\text{ Cr}$
2. Calculate Gross NPA for Bank B (FY22):
   $\text{NPA}_B = 8.5\% \text{ of } 36,000 = 0.085 \times 36,000 = 3,060\text{ Cr}$
3. Calculate Gross NPA for Bank C (FY22):
   $\text{NPA}_C = 4.0\% \text{ of } 70,000 = 0.040 \times 70,000 = 2,800\text{ Cr}$
4. Calculate Gross NPA for Bank D (FY22):
   $\text{NPA}_D = 9.0\% \text{ of } 32,000 = 0.090 \times 32,000 = 2,880\text{ Cr}$
5. Sum the values:
   $\text{Total Gross NPA} = 3,380 + 3,060 + 2,800 + 2,880 = 12,120\text{ Crores}$

Problem 2: Percentage Reduction in Gross NPA Amount

Question: Which bank experienced the highest percentage reduction in its absolute Gross NPA amount from FY21 to FY23?

Step-by-step Solution:

1. Bank A:
   • FY21 NPA $= 8% \times 45,000 = 3,600$
   • FY23 NPA $= 5% \times 65,000 = 3,250$
   • Absolute Reduction $= 3,600 - 3,250 = 350$
   • % Reduction $= (350 / 3,600) \times 100 = 9.72%$
2. Bank B:
   • FY21 NPA $= 10% \times 30,000 = 3,000$
   • FY23 NPA $= 6% \times 45,000 = 2,700$
   • Absolute Reduction $= 3,000 - 2,700 = 300$
   • % Reduction $= (300 / 3,000) \times 100 = 10.00%$
3. Bank C:
   • FY21 NPA $= 5.5% \times 60,000 = 3,300$
   • FY23 NPA $= 3.5% \times 80,000 = 2,800$
   • Absolute Reduction $= 3,300 - 2,800 = 500$
   • % Reduction $= (500 / 3,300) \times 100 = 15.15%$
4. Bank D:
   • FY21 NPA $= 12% \times 25,000 = 3,000$
   • FY23 NPA $= 7.5% \times 40,000 = 3,000$
   • Absolute Reduction $= 3,000 - 3,000 = 0$
   • % Reduction $= 0%$

Conclusion: Bank C achieved the highest percentage reduction in absolute Gross NPA at 15.15%.

---

5. Realistic Worked Example 2: Dual Line Graph Set

Data Set Description: A line graph provides quarterly data for two parameters of an IT services firm across four quarters (Q1 to Q4):

• Line 1 (Revenue): Q1 = $400$ Cr, Q2 = $480$ Cr, Q3 = $540$ Cr, Q4 = $600$ Cr.
• Line 2 (Operating Margin %): Q1 = $15%$, Q2 = $20%$, Q3 = $18%$, Q4 = $25%$.

Problem: Operating Profit Ratio

Question: Find the ratio of operating profit in Q2 to the operating profit in Q4.

Step-by-step Solution:

1. Formula: $\text{Operating Profit} = \text{Revenue} \times \text{Operating Margin %}$
2. Q2 Operating Profit $= 480 \times 0.20 = 96\text{ Crores}$
3. Q4 Operating Profit $= 600 \times 0.25 = 150\text{ Crores}$
4. Required Ratio $= 96 : 150$
5. Simplify by dividing by 6:
   $\frac{96}{6} = 16, \quad \frac{150}{6} = 25 \implies 16 : 25$

---

6. Strategic Exam Tactics & Common Traps

1. The 'Speed Breaker' Trap: Every DI set contains 1–2 questions with intense multi-step calculations designed to consume time. Identify these early and defer them until you have answered the simpler direct ratio/percentage questions.
2. Units & Scale Confusion: Watch for axis labels given in Thousands while questions ask for answers in Lakhs or Millions. Always write down the conversion factor before computing.
3. Base Value Shift: When calculating percentage growth over multiple periods, ensure you use the correct denominator (Initial Value). For instance, percentage growth from 2021 to 2023 requires the 2021 value as the base, not the 2022 value.
4. Approximation Boundaries: If options are close ($24.2%$, $24.8%$, $25.4%$), do NOT approximate. If options are widely spaced ($15%$, $25%$, $38%$, $50%$), round off to the nearest hundred or thousand for rapid resolution.