Skip to content
Milestone -3
Chapter -9 : Practice Questions & Materials
School Admission
KMS Mumbai is one of the reputed school and every year so many students apply for admission in 11th standard. The table has marks for every students for 5 different subjects. The marks are given out of 100 for every subject. While filling the form of admission, students have also filled the department preference. Using the information available in data, create following columns
1. Assign financial status to every student based on the salary of parents. Students having parent’s salary below 20K will be poor, from 20K to 80K middle class and above 80K upper middle class.
2. Selected vs Rejected: Students having total score less than 40% will be rejected. Hence create a flag having “Selected” or “Rejected” based on the info
3. Create a column called “Department for above 70% marks” For all the students who score more than 70% marks , the department preference will be filled by students will be given.
4. Create a column called “Department for below 70%”. For these students, the department will be given using following logic.
a. Biology: Above 120 total marks in science and maths
b. Science Math: From 100 to 120 total marks in science and maths
c. Commerce : 80 to 100 total marks in science and maths
d. Arts : Below 80
5. A new rule from govt has come where every School has to take all the students who are falling in poor category. Identify additional students apart from previous selected students.
Vaccine Data:
The sheet has vaccine data for a apartment. 1 represent shot is successfully given while 0 means shot is not given.
Loan application:
SBI is getting thousands of loan application data every single data. The details for the loan application are mentioned in ‘Loan Eligibility’. Find out how many citizens will get loan approval following conditions. Find of the percentage of people will get loan approval if:
1. Approval is given to citizens who are asking loan for less than 4 times of the monthly salary
2. Citizens having less than 750 credit score is given loan are not given any loan
3. Citizen having salary less than 30k and having at least 2 loans are not given any loan
4. Citizens having credit score from 750 to 780(including both the numbers) and have 4 loans are not given loan.
Dataset -
Workbook (1).xlsx
31.2 kB
Solution Sheet -
3.2 Workbook - Operators Solution .xlsx
72.7 kB
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.