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

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 Accounting Questions!