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.
| Loan Purpose | Checking | Savings | Gender | Marital Status |
|
|---|---|---|---|---|---|
| Education | 600 | 5500 | M | Single | |
| Business | 1000 | 900 | F | Married | |
| New Car | 250 | 250 | M | Single | |
| Furniture | 91 | 4871 | F | Single | |
| Small Appliance | 600 | 300 | M | Divorced | |
| Business | 590 | 2000 | M | Single | |
| Education | 780 | 700 | F | Married | |
| Retraining | 544 | 2000 | M | Single | |
| Small Appliance | 200 | 9000 | F | Single | |
| Repairs | 0 | 800 | M | Divorced |
Classify the checking and savings account balances as low, medium, or high.
| A | B | C | D | E | F | G | |
| 1 | Loan Purpose | Checking | Savings | Gender | Marital Status | Checking Account Status | Savings Account Status |
| 2 | Education | 600 | 5500 | M | Single | Low High Medium | Low High Medium |
| 3 | Business | 1000 | 900 | F | Married | Medium Low High | Medium Low High |
| 4 | New Car | 250 | 250 | M | Single | Low High Medium | High Low Medium |
| 5 | Furniture | 91 | 4871 | F | Single | High Low Medium | Low Medium High |
| 6 | Small Appliance | 600 | 300 | M | Divorced | Medium High Low | Medium Low High |
| 7 | Business | 590 | 2000 | M | Single | Medium High Low | Low High Medium |
| 8 | Education | 780 | 700 | F | Married | High Medium Low | High Low Medium |
| 9 | Retraining | 544 | 2000 | M | Single | High Low Medium | Low Medium High |
| 10 | Small Appliance | 200 | 9000 | F | Single | Medium Low High | Medium High Low |
| 11 | Repairs | 0 | 800 | M | Divorced | Medium High Low | Low High Medium |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
