Join Testzone, Smartkeeda’s Test Series Platform for:

High Level Missing Table Data Interpretation Quiz for Syndicate Bank PO, Canara Bank PO and other Bank PO Exams

Join Testzone, Smartkeeda’s Test Series Platform for:

Syndicate Bank PO Online Mock Test Series
IBPS Clerk Mains 2017 Online Mock Test Series
SSC CHSL 2017 Online Mock Test Series

Directions: Study the following information carefully and answer the questions given beside:

A company Airtel Limited arranges a training programme for its employees from Marketing, Finance and HRD Departments. Each participant is awarded a grade at the end of the training programme.
 
The total number of employees of the Finance Department participating in the programme is twice the number of candidate of HRD Department who have secured ‘Above Average’ grade. The total number of candidates who have obtained ‘Average grade’, is six times the number of candidates of the Marketing Department who have obtained ‘Excellent’ grade and the number of candidates of the HRD Department with ‘Above Average’ grade is 1/3rd the total number of candidates of the HRD Department. Your superior has given you an incomplete chart to be completed

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6   32    
HRD 2 5     48
Finance   7      
Total 13 31     137

1
The total number of employees getting an Above Average grade is:
» Explain it
A
Following the common explanation, we get

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137

From the above table, we get

∴   Total number of above average grade employees = 57

Hence, option A is correct.


Common Explanation:

Number of HRD employees given an above average grade = 1/3rd of the total number of employees in HRD
 
∴ Number of employees from HRD given an above average grade = (1/3) × 48 = 16
 
Total number of employees given an average grade = 6 × Number of employees from Marketing department given an Excellent grade

∴ Total number of Average grade employees = 6 × 6 = 36

Total number of participating employees from Finance Department = 2 × Number of above average grade employees from HRD

∴ Total number of participating employees from the Finance Department = 2 × 16 = 32

Total Number of participating employees = (Number of Excellent grade employees) + (Number of Very good grade employees) + (Number of above Average grade employees) + (Number of Average grade employees)

∴ 137 = 13 + 31 + Number of above average grade employees + 36

∴ Total number of above average grade employees = 57

Total number of excellent grade employees = Sum of the number of Excellent grade employees from Marketing, HRD and Finance department

Doing the above for each grade we get.

Number of excellent grade employees in Finance department = 15

Number of very good grade employees in Marketing department = 19

Number of above average grade employees in Finance department = 9

Total number of participants = sum of the number of participants from all branches

∴   137 = Number of employees in Marketing department + 48 + 32

∴ Total number of employees in Marketing department = 57

Number of Excellent + very good + above average + average employees in every department = Total number of participating employees in respective department

From this, we get that the average grade employees in Marketing, HRD and Finance Departments are 0, 25 and 11 respectively.

From the above information, we complete the table as follows

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137

2
» Explain it
A
From the following explanation, we get the table as follows

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137

From the above table, we get

∴   Marketing department has the least number of Average grade Employees.

Hence, option A is correct.

Common Explanation:

Number of HRD employees given an above average grade = 1/3rd of the total number of employees in HRD
 
∴ Number of employees from HRD given an above average grade = (1/3) × 48 = 16
 
Total number of employees given an average grade = 6 × Number of employees from Marketing department given an Excellent grade

∴ Total number of Average grade employees = 6 × 6 = 36

Total number of participating employees from Finance Department = 2 × Number of above average grade employees from HRD

∴ Total number of participating employees from the Finance Department = 2 × 16 = 32

Total Number of participating employees = (Number of Excellent grade employees) + (Number of Very good grade employees) + (Number of above Average grade employees) + (Number of Average grade employees)

∴ 137 = 13 + 31 + Number of above average grade employees + 36

∴ Total number of above average grade employees = 57

Total number of excellent grade employees = Sum of the number of Excellent grade employees from Marketing, HRD and Finance department

Doing the above for each grade we get.

Number of excellent grade employees in Finance department = 15

Number of very good grade employees in Marketing department = 19

Number of above average grade employees in Finance department = 9

Total number of participants = sum of the number of participants from all branches

∴   137 = Number of employees in Marketing department + 48 + 32

∴ Total number of employees in Marketing department = 57

Number of Excellent + very good + above average + average employees in every department = Total number of participating employees in respective department

From this, we get that the average grade employees in Marketing, HRD and Finance Departments are 0, 25 and 11 respectively.

From the above information, we complete the table as follows

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137
3
The number of employees of the HRD Department getting ‘Above Average’ grade form approximately what percent of the total number of employees participating in the programme?
» Explain it
D
From the common explanation, we get the table as follows:

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137

From the above table, we get
 
∴ % out of total number of participating employees = (16/137) × 100

∴ required % = 11.678 ≈ 12 %

Hence, option D is correct.


Common Explanation:

Number of HRD employees given an above average grade = 1/3rd of the total number of employees in HRD
 
∴ Number of employees from HRD given an above average grade = (1/3) × 48 = 16
 
Total number of employees given an average grade = 6 × Number of employees from Marketing department given an Excellent grade

∴ Total number of Average grade employees = 6 × 6 = 36

Total number of participating employees from Finance Department = 2 × Number of above average grade employees from HRD

∴ Total number of participating employees from the Finance Department = 2 × 16 = 32

Total Number of participating employees = (Number of Excellent grade employees) + (Number of Very good grade employees) + (Number of above Average grade employees) + (Number of Average grade employees)

∴ 137 = 13 + 31 + Number of above average grade employees + 36

∴ Total number of above average grade employees = 57

Total number of excellent grade employees = Sum of the number of Excellent grade employees from Marketing, HRD and Finance department

Doing the above for each grade we get.

Number of excellent grade employees in Finance department = 15

Number of very good grade employees in Marketing department = 19

Number of above average grade employees in Finance department = 9

Total number of participants = sum of the number of participants from all branches

∴   137 = Number of employees in Marketing department + 48 + 32

∴ Total number of employees in Marketing department = 57

Number of Excellent + very good + above average + average employees in every department = Total number of participating employees in respective department

From this, we get that the average grade employees in Marketing, HRD and Finance Departments are 0, 25 and 11 respectively.

From the above information, we complete the table as follows

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137

 
 
4
The company Airtel is charged Rs. 5,570/ - per employee towards the cost of training. If it is offered a discount of 7.5% to those candidates who secured ‘Average’ grade, them, what is the total fee payable by company Airtel to the training company, to the nearest thousand?
» Explain it
C
From the common explanation, we get the table as follows

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137

From the above table, we get

Total number of Average grade employees in Airtel = 0 + 25 + 11 = 36

Number of employees from Airtel getting a grade except Average grade = 137 – 36 = 101

∴ Total cost payable = 36 × discounted amount + 101 × 5570

∴ Total cost payable = 36 × 5152.25 + 101 × 5570

∴ Total cost payable = 1,85,481 + 5,62,570 = 7,48,051

∴ The payable cost rounded to the nearest thousand is Rs .7,48,000
 
Hence, option C is correct.


Common Explanation:

Number of HRD employees given an above average grade = 1/3rd of the total number of employees in HRD
 
∴ Number of employees from HRD given an above average grade = (1/3) × 48 = 16
 
Total number of employees given an average grade = 6 × Number of employees from Marketing department given an Excellent grade

∴ Total number of Average grade employees = 6 × 6 = 36

Total number of participating employees from Finance Department = 2 × Number of above average grade employees from HRD

∴ Total number of participating employees from the Finance Department = 2 × 16 = 32

Total Number of participating employees = (Number of Excellent grade employees) + (Number of Very good grade employees) + (Number of above Average grade employees) + (Number of Average grade employees)

∴ 137 = 13 + 31 + Number of above average grade employees + 36

∴ Total number of above average grade employees = 57

Total number of excellent grade employees = Sum of the number of Excellent grade employees from Marketing, HRD and Finance department

Doing the above for each grade we get.

Number of excellent grade employees in Finance department = 15

Number of very good grade employees in Marketing department = 19

Number of above average grade employees in Finance department = 9

Total number of participants = sum of the number of participants from all branches

∴   137 = Number of employees in Marketing department + 48 + 32

∴ Total number of employees in Marketing department = 57

Number of Excellent + very good + above average + average employees in every department = Total number of participating employees in respective department

From this, we get that the average grade employees in Marketing, HRD and Finance Departments are 0, 25 and 11 respectively.

From the above information, we complete the table as follows

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137
5
The number of employees of the Marketing Department getting ‘Above Average’ grade form what percent of the total number of employees participating in the programme?
» Explain it
B
From the common explanation, we get the table as follows

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137

From  the above table, we get

Number of employees from Marketing Department getting an above average grade = 32

∴  % out of total number of participating employees = (32/137) × 100

  Required % = 23.36%

Hence, option B is correct.

Common Explanation:

Number of HRD employees given an above average grade = 1/3rd of the total number of employees in HRD
 
∴ Number of employees from HRD given an above average grade = (1/3) × 48 = 16
 
Total number of employees given an average grade = 6 × Number of employees from Marketing department given an Excellent grade

∴ Total number of Average grade employees = 6 × 6 = 36

Total number of participating employees from Finance Department = 2 × Number of above average grade employees from HRD

∴ Total number of participating employees from the Finance Department = 2 × 16 = 32

Total Number of participating employees = (Number of Excellent grade employees) + (Number of Very good grade employees) + (Number of above Average grade employees) + (Number of Average grade employees)

∴ 137 = 13 + 31 + Number of above average grade employees + 36

∴ Total number of above average grade employees = 57

Total number of excellent grade employees = Sum of the number of Excellent grade employees from Marketing, HRD and Finance department

Doing the above for each grade we get.

Number of excellent grade employees in Finance department = 15

Number of very good grade employees in Marketing department = 19

Number of above average grade employees in Finance department = 9

Total number of participants = sum of the number of participants from all branches

∴   137 = Number of employees in Marketing department + 48 + 32

∴ Total number of employees in Marketing department = 57

Number of Excellent + very good + above average + average employees in every department = Total number of participating employees in respective department

From this, we get that the average grade employees in Marketing, HRD and Finance Departments are 0, 25 and 11 respectively.

From the above information, we complete the table as follows

Class GRADES
Excellent Very Good  Above Average Average Total
Marketing 6 19 32 0 57
HRD 2 5 16 25 48
Finance 5 7 9 11 32
Total 13 31 57 36 137

 


Missing Table Data Interpretation questions are regularly asked in all the major Bank and other entrance exams in present competitive exam scenario. We at www.smartkeeda.com keep updating the Data Interpretation Questions and Answers topic with the best DI quizzes for you to pratise and improve your Data Interpretation solving skills. Practise one such Missing Table Chart DI Set or Missing Table Chart Data Interpretation Set and get detailed solution of each DI question of this complete Missing Table Chart Data Interpretation Quiz at Smartkeeda. This High Level DI quiz based on Missing Data provides you with an opportunity to understand Missing Data DI techniques which are important for upcoming exams like Syndicate Bank PO, IBPS Clerk Mains, SBI PO Pre and Mains 2018, IBPS PO Pre and Mains 2018, IBPS RRB Office Assistant Pre and Mains 2018, IBPS RRB Scale 1 Pre and Mains 2018, IBPS SO Pre 2018, MAT May 2018, etc. Attempt the given Missing Data Table Chart DI based Missing Data Interpretation Quiz and try solving all the DI questions correctly.