Credit Risk Data

$\backslash$table$[[$Loan Purpose,Checking,Savings,$\backslash$table$[[$Months$],[$Customer$]],\backslash$table$[[$Months$],[$Employed$]],\backslash$table$[[$Marital$],[$Status$]],$Job,$\backslash$table$[[$Credit$],[$Risk$]]],[$Small Appliance,$0,721,13,12,$Single,Unskilled,Low$],[$Furniture$,0,1,251,25,0,$Divorced,Skilled,High$],[$New Car,$0,384,19,119,$Single,Management,High$],[$Furniture$,631,355,13,14,$Single,Unskilled,High$],[$Education$,956,4,821,40,45,$Single,Skilled,Low$],[$Furniture$,2,841,0,11,13,$Married,Skilled,Low$],[$New Car,$0,241,13,16,$Married,Unskilled,Low$],[$Business$,0,526,14,2,$Single,Unskilled,Low$],[$Small Appliance,$6,545,499,37,9,$Single,Skilled,High$],[$Small Appliance,$948,0,25,4,$Divorced,Skilled,High$],[$Business$,0,954,49,0,$Single,Management,High$],[$New Car,$0,3,379,11,15,$Single,Unskilled,L inw$],[$Business$,348,587,10,14,$Married,Skilled,Low$],[$New Car,$0,826,25,63,$Single,Skilled,High$],[$New Car,$409,234,13,26,$Single,Unskilled,Low$],[$Used Car,$0,127,31,8,$Divorced,Management,Low$],[$Furniture$,673,736,49,4,$Divorced,Skilled,High$],[$New Car,$707,686,13,33,$Single,Skilled,Low$],[$Repairs$,209,0,28,116,$Single,Skilled,Low$],[$Education$,285,12,301,7,2,$Divorced,Skilled,High$]]$

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

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$,$G$],[1,1$ Loan Purpose C$,$Checking S$,$Savings Ge$,$Gender

$\backslash$table$[[$M$],[$S$]],\backslash$table$[[$Marital$],[$Status$]],\backslash$table$[[$Checking$],[$Account S$]],\backslash$table$[[$Status$]],\backslash$table$[[$Savings$],[$Account$]],\backslash$table$[[$Status$]]],[2,$Education $4,400,3500$ M$,M$ M$,$Single,$\backslash ,,7,],[3,$Business $90,900,1100$ F$,$F$,$Married,$,,,],[4,$New Car $2,250,250$ M$,$M S$,$Single,$,,$grad,$],[5,$Furniture $9,914,4871$ F$,$F S$,$Single,grad,,$7,],[6,$Small Appliance $70,700,500$ M$,$M D$,$Divorced,grad,,$7,],[7,$Business $790,790,2000$ M$,M$ S$,$Single,grad,,grad,$],[8,$Education $68,680,500$ F$,$F$,$Married,grad,,$,],[9,$Retraining $44,444,2000$ M$,$M S$,$Single,grad,,grad,$],[105,$Small Appliance $10,100,9000,$S$,$Single,grad,,grad,$],[11,$Repairs $0,0,70,700$ M$,$M D$,$Divorced,grad,,$7,]]$