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

X Modify the accompanying credit risk data using IF functions to include

X 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. Credit Risk Data 0 A B C D E F G Loan Purpose Checking Savings Gender 1 Loan Purpose Checking Savings Gender Marital Status Checking Savings Account Status Account Status Education 600 3500 M Marital Status Single 2 Education 600 3500 M Single Business 900 1100 F Married New Car 250 250 M Single 3 Business 900 1100 F Married Furniture 91 4871 F Single 4 New Car 250 250 M Single Small Appliance 700 300 M Divorced 5 Furniture 91 4871 F Single Business 890 2000 M Single Education 580 500 F Married 6 Small Appliance 700 300 M Divorced Retraining 344 2000 M Single 7 Business 890 2000 M Single Small Appliance 100 9000 F Single 8 Education 580 500 F Married Repairs 0 800 M Divorced 9 Retraining 344 2000 M Single 10 Small Appliance 100 9000 F Single 11 Repairs 800 M Divorced

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!