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 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

Answer 1

Please give positive rating your feedback is valuable to me.

In case , any problem please leave a comment.

Classify the checking and savings account balances as low, medium, or high. A B с D Loan Purpose Checking Savings Gender E Marital Status 1 Education 2 Business 3 New Car 4 Furniture 5 Small Appliance 6 Business 7 Education 8 Retraining 9 Small Appliance 10 Repairs 600 1000 250 91 600 590 780 544 200 0 5500 900 250 4871 300 2000 700 2000 9000 800 Checking Account Status Medium Medium Medium Low Medium Medium Medium Medium Low Low Single Married Single Single Divorced Single Married Single Single Divorced G Savings Account Status High Meduim Meduim High Meduim Meduim Meduim Meduim High Meduim M M F M F M Account Status are classified based on the following criteria:- → Balance Less than 250 Low Balance from 250 but less than 2,000 Medium → Balance Above 2,000 High