Question: Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance

Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least $250 but less than $2000, and high otherwise. Click the icon to view the Credit Risk data, Classify the checking and savings account balances as low, medium, or high. B D E F 1 Loan Purpose Checking Savings Gender Marital Checking Savings Account Status Account Status Status 2 Education 400 3500 M Single 3 Business 900 900 F Married 4 New Car 250 250 M Single 5 Furniture 101 3871 F Single 400 M Divorced 4000 M Single 600 F Married 6 Small Appliance 800 7 Business 690 8 Education 580 9 Retraining 544 10 Small Appliance 100 11 Repairs 0 2000 M 8000 F F Single Single Divorced 800 M V i Credit Risk Data X Savings 3500 900 900 Gender M F M F Loan Purpose Checking Education 400 Business New Car 250 Furniture 101 Small Appliance 800 Business 690 Education 580 Retraining 544 Small Appliance 100 Repairs 0 250 3871 400 4000 600 2000 8000 800 M M F Marital Status Single Married Single Single Divorced Single Married Single Single Divorced M F M Print Done
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
