Missing Data Interpretation Questions Quiz for SBI PO, IBPS PO, SBI CLERK, IBPS CLERK, 2020

Directions: Study the following table chart carefully and answer the questions given beside.

The following table shows the amount of bills (in Rs.) of 3 families, Phone bills (P), Electricity bills (E) and Water bills (W) for 5 months:

 
 Months  Sharma's Gupta's Agrawal's Total
P E W P E W P E W
Jan  1200   1000   550  900   800 1450 2500 1000 10900
Feb 1400 1100 500  1400   1500   500   1350     950   10100 
March 1500 550 350 1250 400   1100 2500 250 8500
April 2550 950 1500 1650 500 1500   1250 350 11500
May       1150 1500 1200 1450 1150 850 9600
Total 7900 4050             3400 50600
1
What is the ratio between the total amount paid on Phone bills and Electricity bills for the family who paying the highest amount in January on Electricity?
» Explain it
B
Following the common explanation, we get

Total amount paid on Phone bills by Agrawal's family = 6600

And the total amount paid on Electricity = 8800

Required ratio = 6600 : 8800 = 3 : 4

Hence, option B is correct.

Common explanation: After filling the data in table, we get

Months Sharma's Gupta's Agrawal's Total
P E W P E W P E W  
Jan 1200 1000 550 900 1500 800 1450 2500 1000 10900
Feb 1400 1100 500 1400 1500 500 1350 1400 950 10100
March 1500 550 350 1250 400 600 1100 2500 250 8500
April 2550 950 1500 1650 500 1500 1250 1250 350 11500
May 1250 450 600 1150 1500 1200 1450 1150 850 9600
Total 7900 4050 3500 6350 5400 4600 6600 8800 3400 50600

2
The average amount paid on Water bills by Sharma's family is more/less than the average amount paid by Gupta's family on Water bills?
» Explain it
A
Following the common explanation, we get

Average amount paid on Water bills by Sharma's family

=   3500  = 700
5

Average amount paid by Gupta's family on Water bills
4600  = 920
5

Required difference = 920 - 700 = 220

Hence, option A is correct.
Common explanation: After filling the data in table, we get
 
Months Sharma's Gupta's Agrawal's Total
P E W P E W P E W  
Jan 1200 1000 550 900 1500 800 1450 2500 1000 10900
Feb 1400 1100 500 1400 1500 500 1350 1400 950 10100
March 1500 550 350 1250 400 600 1100 2500 250 8500
April 2550 950 1500 1650 500 1500 1250 1250 350 11500
May 1250 450 600 1150 1500 1200 1450 1150 850 9600
Total 7900 4050 3500 6350 5400 4600 6600 8800 3400 50600

3
The amount paid on phone bills by Gupta's family is more than what percent by his amount paid on Electricity bills over the given months?
» Explain it
B
Following the common explanation, we get

Amount paid on Phone bills by Gupta's family = 6350

And, the amount paid on Electricity bills = 5400

Required percentage

=   6350 – 5400  × 100 = 17.59% ≈ 18%
5400
Hence, option B is correct.

Common explanation: After filling the data in table, we get
 
Months Sharma's Gupta's Agrawal's Total
P E W P E W P E W  
Jan 1200 1000 550 900 1500 800 1450 2500 1000 10900
Feb 1400 1100 500 1400 1500 500 1350 1400 950 10100
March 1500 550 350 1250 400 600 1100 2500 250 8500
April 2550 950 1500 1650 500 1500 1250 1250 350 11500
May 1250 450 600 1150 1500 1200 1450 1150 850 9600
Total 7900 4050 3500 6350 5400 4600 6600 8800 3400 50600
4
Given that the amount paid on Phone bill, Electricity bill and Water bill by Sharma's family in the month of June was increased by 12%, 16% and 25% as per the data given for the month of May. Find his total amount paid on all the three bills in the month of June?
» Explain it
C
Following the common explanation, we get 
 
Amount paid on Phone bill, Electricity and Water bill by Sharma's family in the month of June
 
= 112% of 1250 + 116% of 450 + 125% of 600
 
= 1400 + 522 + 750
 
= 2672
 
Hence, option C is correct.

Common explanation: After filling the data in table, we get

Months Sharma's Gupta's Agrawal's Total
P E W P E W P E W  
Jan 1200 1000 550 900 1500 800 1450 2500 1000 10900
Feb 1400 1100 500 1400 1500 500 1350 1400 950 10100
March 1500 550 350 1250 400 600 1100 2500 250 8500
April 2550 950 1500 1650 500 1500 1250 1250 350 11500
May 1250 450 600 1150 1500 1200 1450 1150 850 9600
Total 7900 4050 3500 6350 5400 4600 6600 8800 3400 50600

5
What is the difference between the total amount paid on Electricity bills by all three families in the month of February and the total amount paid on Phone bills by all three families in the month of April?
» Explain it
E
Following the common explanation, we get 
 
Amount paid on Electricity bill by all three of families in February
 
= 1100 + 1500 + 1400 = 4000
 
Amount paid on Phone bills by all three families in April
 
= 2550 + 1650 + 1250
 
= 5450
 
Required difference = 5450 – 4000 = 1450
 
Hence, option E is correct.

Common explanation: After filling the data in table, we get

Months Sharma's Gupta's Agrawal's Total
P E W P E W P E W  
Jan 1200 1000 550 900 1500 800 1450 2500 1000 10900
Feb 1400 1100 500 1400 1500 500 1350 1400 950 10100
March 1500 550 350 1250 400 600 1100 2500 250 8500
April 2550 950 1500 1650 500 1500 1250 1250 350 11500
May 1250 450 600 1150 1500 1200 1450 1150 850 9600
Total 7900 4050 3500 6350 5400 4600 6600 8800 3400 50600