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.

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$,,$G$,],[1,$Loan Purpose,Checking,Savings,Gender,$\backslash$table$[[$Marital$],[$Status$]],\backslash$table$[[$Checking$],[$Account$]],\backslash$table$[[$Status$]],\backslash$table$[[$Savings$],[$Account$]],\backslash$table$[[$Status$]]],[2,$Education,$400,3500,$M$,$Single,V$,,$V$,],[3,$Business,$1000,800,$F$,$Married,V$,,$V$,],[4,$New Car,$250,250,$M$,$Single,grad,,V$,],[5,$Furniture,$91,2871,$F$,$Single,$\backslash ,,$V$,],[6,$Small Appliance,$800,600,$M$,$Divorced,V$,,$v$,],[7,$Business,$990,3000,$M$,$Single,V$,,$V$,],[8,$Education,$680,700,$F$,$Married,V$,,$v$,],[9,$Retraining,$444,2000,$M$,$Single,V$,,$V$,],[10,$Small Appliance,$200,10000,$F$,$Single,V$,,$V$,],[11,$Repairs,$0,900,$M$,$Divorced,V$,,$v$,]]$