Study guide

4.5 Arithmetic-based DI (Profit-Loss, Time-Work, TSD) & Funnel/Scatter DI

SBI PO Probationary Officer

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Introduction & SBI PO Exam Architecture

1.1 SBI PO Exam Structure, Phases & Sectional Timing 1.2 Eligibility, Age Relaxation & Number of Attempts 1.3 Mark Calculation, One-Fourth Negative Marking & Cut-offs 1.4 Descriptive Communication Test (Email, Situation, Report/Précis) 1.5 Phase 3: Psychometric Test, Group Exercise & Interview Preparation 1.6 Recommended Study Plan & Mock Test Strategy

2 Chapter 2: Quantitative Aptitude — Foundation & Speed Math

2.1 Vedic Math, Fast Calculation & Approximation Techniques 2.2 Number Series (Missing & Wrong Number Patterns) 2.3 Quadratic Equations & Quantity Comparisons (Q1 vs Q2) 2.4 Simplification & Order of Operations 2.5 Data Sufficiency in Quantitative Aptitude

3 Chapter 3: Arithmetic & Applied Problem Solving

3.1 Percentages, Profit, Loss & Discount Calculations 3.2 Simple Interest & Compound Interest (Compounding Cycles & Differences) 3.3 Ratio & Proportion, Partnerships & Ages 3.4 Averages, Mixtures & Alligations 3.5 Time, Work, Efficiency & Pipes & Cisterns 3.6 Speed, Distance, Time, Trains & Boats/Streams 3.7 Permutation, Combination & Probability in Banking Exams

4 Chapter 4: Advanced Data Analysis & Data Interpretation (DI)

4.1 Table & Line Graph Data Interpretation 4.2 Bar Chart & Pie Chart Data Interpretation 4.3 Caselet Data Interpretation (Paragraph-based DI & Venn Caselets) 4.4 Missing Data DI & Radar/Spider Graph Interpretation 4.5 Arithmetic-based DI (Profit-Loss, Time-Work, TSD) & Funnel/Scatter DI

5 Chapter 5: Analytical Reasoning

5.1 Syllogisms (Only a few, Some not & Reverse Syllogism) 5.2 Coded & Mathematical Inequalities 5.3 Coding-Decoding (Coded Statements & Mains Patterns) 5.4 Blood Relations & Direction Sense 5.5 Input-Output Machine Rearrangement

6 Chapter 6: Puzzles & Seating Arrangement

6.1 Linear & Circular Seating Arrangement (Single/Parallel Rows & Variable Binding) 6.2 Floor & Box Puzzles (Multi-story, Vacant floor & Stacking Order) 6.3 Matrix & Category Puzzles (Department/Profession Allocation & Constraint Elimination) 6.4 Scheduling Puzzles (Day-Month-Year combinations & Time Slots)

7 Chapter 7: Critical Reasoning

7.1 Statement & Implicit Assumptions 7.2 Statement & Conclusions vs Strong/Weak Arguments 7.3 Statement & Course of Action 7.4 Cause & Effect Analysis 7.5 Critical Reasoning Passages (Strengthen/Weaken & Paradox Resolution)

8 Chapter 8: English Language

8.1 Reading Comprehension: Tone, Inference, Main Idea & Vocab in Context 8.2 Cloze Test & Double/Triple Fillers 8.3 Para Jumbles & Sentence Rearrangement 8.4 Error Spotting & Phrase Replacement (Grammar Rules) 8.5 Word Usage, Synonyms/Antonyms & Contextual Meaning 8.6 Match the Columns & Sentence Connectors/Starters

9 Chapter 9: Banking & Financial Awareness

9.1 Reserve Bank of India (RBI): History, Structure & Functions 9.2 Monetary Policy Framework: MPC, Repo Rate, SDF, MSF, CRR, SLR & Inflation Targeting 9.3 Indian Financial System: Commercial Banks, Small Finance Banks, Payment Banks & NBFCs 9.4 Financial Inclusion & Government Banking Schemes (PMJDY, PMSBY, PMJJBY, APY, MUDRA, KCC) 9.5 Banking Current Affairs & Financial News Dynamics

10 Chapter 10: General & Banking Awareness — Indian Economy, Financial Markets & Regulations

10.1 Economic Indicators: GDP, NNP, WPI, CPI, IIP & National Income 10.2 Forex & International Trade: Balance of Payments, LRS, NEER/REER & World Bank/IMF 10.3 Union Budget & Economic Survey: Fiscal Deficit, CapEx & Revenue Receipts 10.4 Money Market vs Capital Market: T-Bills, Commercial Paper, CD, Stocks, Bonds & SEBI 10.5 Priority Sector Lending (PSL), Non-Performing Assets (NPAs), SARFAESI, IBC & Basel III

11 Chapter 11: Computer Aptitude

11.1 Computer Fundamentals & Hardware Architecture 11.2 Operating Systems & System Software 11.3 Networking Concepts & Internet Protocols 11.4 Cybersecurity & Banking IT Security 11.5 Database Management Systems (DBMS) & MS Office Suite

4.5 Arithmetic-based DI (Profit-Loss, Time-Work, TSD) & Funnel/Scatter DI

Key Takeaways Explain This Topic AI

Arithmetic DI embeds core Quantitative Aptitude formulas (Profit-Loss, Time-Work, TSD, SI-CI) directly into graphical datasets.

In Profit & Loss DI, establish Cost Price (CP) as the 100% baseline before calculating Marked Price (MP), Discount %, and Selling Price (SP).

In Time & Work DI tables, convert worker time completion days into daily work efficiency rates (Rate = 1 / Days).

Funnel Charts represent multi-stage conversion pipelines, measuring stage-over-stage retention and drop-off percentages.

Scatter Plots display individual bivariate data points (X, Y) to test correlation, trend identification, and outlier detection.

Last updated: July 2026

4.5 Arithmetic-based DI (Profit-Loss, Time-Work, TSD) & Funnel/Scatter DI

Arithmetic-based Data Interpretation is the premier challenge of SBI PO Mains. These sets combine core arithmetic concepts— Profit, Loss & Discount , Time & Work , Time, Speed & Distance (TSD) , and Simple/Compound Interest —with complex graphical formats such as tables, Funnel Charts , and Scatter Plots .

1. Profit, Loss & Discount DI Mechanics

Profit-Loss DI sets present financial product data across columns representing Cost Price (CP), Marked Price (MP), Selling Price (SP), Discount Percentage, and Profit/Loss Percentage. Cost Price (CP) ----[ Markup % ]----> Marked Price (MP)

  • | |
  • | [ Discount % ]
  • v v
  • [ Profit / Loss % ] ----------------> Selling Price (SP)

Core Formulas for Chart Derivations Marked Price (MP) = CP × ( 1 + Markup % 100 ) \text{Marked Price (MP)} = \text{CP} \times \left( 1 + \frac{\text{Markup \%}}{100} \right) Marked Price (MP) = CP × ( 1 + 100 Markup % ​ ) Selling Price (SP) = MP × ( 1 − Discount % 100 ) \text{Selling Price (SP)} = \text{MP} \times \left( 1 - \frac{\text{Discount \%}}{100} \right) Selling Price (SP) = MP × ( 1 − 100 Discount % ​ ) Profit = SP − CP = CP × ( Profit % 100 ) \text{Profit} = \text{SP} - \text{CP} = \text{CP} \times \left( \frac{\text{Profit \%}}{100} \right) Profit = SP − CP = CP × ( 100 Profit % ​ ) Discount Amount = MP − SP = MP × ( Discount % 100 ) \text{Discount Amount} = \text{MP} - \text{SP} = \text{MP} \times \left( \frac{\text{Discount \%}}{100} \right) Discount Amount = MP − SP = MP × ( 100 Discount % ​ )

2. Time & Work DI Mechanics

Time & Work DI tables specify the number of days individual workers or pipes require to complete tasks. You must convert these time values into daily efficiency rates. Work Rate (Efficiency) = 1 Time (Days) \text{Work Rate (Efficiency)} = \frac{1}{\text{Time (Days)}} Work Rate (Efficiency) = Time (Days) 1 ​ Total Work = LCM of individual completion times (in units) \text{Total Work} = \text{LCM of individual completion times (in units)} Total Work = LCM of individual completion times (in units) Combined Rate (A + B) = 1 T A + 1 T B = T A + T B T A × T B \text{Combined Rate (A + B)} = \frac{1}{T_A} + \frac{1}{T_B} = \frac{T_A + T_B}{T_A \times T_B} Combined Rate (A + B) = T A ​ 1 ​ + T B ​ 1 ​ = T A ​ × T B ​ T A ​ + T B ​ ​

  • 3. Modern Visual Formats: Funnel Charts & Scatter Plots
  • Funnel Charts (Conversion Pipelines)

Funnel charts track customer progression through sequential process stages (e.g., Banking App Funnel: Downloads → \to → Registrations → \to → KYC Verification → \to → Account Opened). Stage 1: App Downloads [ 100,000 ] ------------------------------ (100% Base)

  • Stage 2: Registrations [ 60,000 ] ------------ (60% Conversion from Stage 1)
  • Stage 3: KYC Completed [ 36,000 ] ------ (60% Conversion from Stage 2)
  • Stage 4: Active Accounts[ 18,000 ] --- (50% Conversion from Stage 3)

Stage-to-Stage Conversion Rate : Conversion % = ( Volume in Stage k Volume in Stage k − 1 ) × 100 \text{Conversion \%} = \left( \frac{\text{Volume in Stage } k}{\text{Volume in Stage } k-1} \right) \times 100 Conversion % = ( Volume in Stage k − 1 Volume in Stage k ​ ) × 100

Overall Pipeline Conversion Rate : Overall Conversion % = ( Volume in Final Stage Volume in Initial Stage ) × 100 \text{Overall Conversion \%} = \left( \frac{\text{Volume in Final Stage}}{\text{Volume in Initial Stage}} \right) \times 100 Overall Conversion % = ( Volume in Initial Stage Volume in Final Stage ​ ) × 100

Scatter Plots (Bivariate Data Distributions)

Scatter plots display individual data points plotted on Cartesian coordinates ( X , Y ) (X, Y) ( X , Y ) , such as Interest Rate ( X X X ) vs. Loan Default Rate ( Y Y Y ).

Positive Correlation : Data points trend upward from left to right.

Negative Correlation : Data points trend downward from left to right.

Outliers : Isolated points situated far from the primary cluster trendline.

4. Realistic Worked Example 1: Profit & Loss DI Set

Data Set Description: A table provides pricing details for 4 banking investment products.

  • Investment Product Cost Price (₹) Markup (%) Discount (%) Profit / Loss (%)
  • Product Alpha 5,000 40% 15% ---
  • Product Beta --- 50% 20% Profit 20%
  • Product Gamma 8,000 --- 10% Profit 35%
  • Product Delta 10,000 30% --- Profit 17%
  • Problem 1: Profit Percentage of Product Alpha

Question: What is the Profit Percentage earned on Product Alpha?

Step-by-step Solution:

Cost Price (CP) = INR 5 , 000 = \text{INR }5,000 = INR 5 , 000

Marked Price (MP) = 5 , 000 × ( 1 + 0.40 ) = 5 , 000 × 1.40 = INR 7 , 000 = 5,000 \times (1 + 0.40) = 5,000 \times 1.40 = \text{INR }7,000 = 5 , 000 × ( 1 + 0.40 ) = 5 , 000 × 1.40 = INR 7 , 000

Selling Price (SP) = 7 , 000 × ( 1 − 0.15 ) = 7 , 000 × 0.85 = INR 5 , 950 = 7,000 \times (1 - 0.15) = 7,000 \times 0.85 = \text{INR }5,950 = 7 , 000 × ( 1 − 0.15 ) = 7 , 000 × 0.85 = INR 5 , 950

Profit Amount = SP − CP = 5 , 950 − 5 , 000 = INR 950 = \text{SP} - \text{CP} = 5,950 - 5,000 = \text{INR }950 = SP − CP = 5 , 950 − 5 , 000 = INR 950

Profit Percentage = ( 950 5 , 000 ) × 100 = 19.0 % = \left( \frac{950}{5,000} \right) \times 100 = 19.0\% = ( 5 , 000 950 ​ ) × 100 = 19.0%

Problem 2: Cost Price of Product Beta

Question: If the Selling Price of Product Beta is ₹7,200, find its Cost Price.

Step-by-step Solution:

Given Profit = 20 % ⟹ SP = 1.20 × CP = 20\% \implies \text{SP} = 1.20 \times \text{CP} = 20% ⟹ SP = 1.20 × CP

7 , 200 = 1.20 × CP ⟹ CP = 7 , 200 1.20 = INR 6 , 000 7,200 = 1.20 \times \text{CP} \implies \text{CP} = \frac{7,200}{1.20} = \text{INR }6,000 7 , 200 = 1.20 × CP ⟹ CP = 1.20 7 , 200 ​ = INR 6 , 000

5. Realistic Worked Example 2: Digital Loan Funnel DI Set

Data Set Description: SBI digital loan application funnel with an initial top-stage volume of 200 , 000 200,000 200 , 000 initial applications:

  • Stage 1 (Application Received) : 200 , 000 200,000 200 , 000
  • Stage 2 (Document Verification) : 65 % 65\% 65% conversion from Stage 1
  • Stage 3 (Credit Audit Approval) : 80 % 80\% 80% conversion from Stage 2
  • Stage 4 (Loan Sanctioned) : 75 % 75\% 75% conversion from Stage 3
  • Stage 5 (Loan Disbursed) : 90 % 90\% 90% conversion from Stage 4
  • Problem: Disbursed Loan Volume & Overall Conversion

Question: How many loans were ultimately disbursed (Stage 5), and what is the overall funnel conversion percentage?

Step-by-step Solution:

  • Stage 2 Volume = 200 , 000 × 0.65 = 130 , 000 = 200,000 \times 0.65 = 130,000 = 200 , 000 × 0.65 = 130 , 000
  • Stage 3 Volume = 130 , 000 × 0.80 = 104 , 000 = 130,000 \times 0.80 = 104,000 = 130 , 000 × 0.80 = 104 , 000
  • Stage 4 Volume = 104 , 000 × 0.75 = 78 , 000 = 104,000 \times 0.75 = 78,000 = 104 , 000 × 0.75 = 78 , 000

Stage 5 Disbursed Volume = 78 , 000 × 0.90 = 70 , 200 loans = 78,000 \times 0.90 = 70,200\text{ loans} = 78 , 000 × 0.90 = 70 , 200 loans

Overall Conversion Rate: Overall Conversion = ( 70 , 200 200 , 000 ) × 100 = 35.1 % \text{Overall Conversion} = \left( \frac{70,200}{200,000} \right) \times 100 = 35.1\% Overall Conversion = ( 200 , 000 70 , 200 ​ ) × 100 = 35.1%

6. Strategic Mastery for Mains Arithmetic DI

Formula Verification : Write down fundamental arithmetic formulas on your scratch sheet before solving complex sets.

Track Intermediate Steps : In multi-stage Funnel charts, avoid rounding intermediate values; calculate cumulative product multipliers (Base * p1 * p2 * p3) in a single continuous calculation.

Scatter Plot Axis Scale Alignment : Carefully check grid unit steps on both X and Y axes to prevent incorrect point coordinate readings.