The worksheet Base Data in the Excel file Credit Risk Data provides information about $425$ bank customers who had applied for loans. The data includes the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, age, housing status and number of years at current residence, job type, and credit$-$risk classification by the bank. $1$

Provide and use the COUNTIF function to determine:

a$.$ How many customers applied for new$-$car loans

b$.$ How many customers applied for used$-$car loans

c$.$ How many customers applied for business loans

d$.$ How many customers applied for furniture loans

e$.$ The number of customers with checking account balances less than $$500$

The worksheet Base Data in the Excel file Credit Risk Data provides information about $425$ bank customers who had applied for loans. The data includes the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, age, housing status and number of years at current residence, job type, and credit$-$risk classification by the bank. $1$

Provide and use the COUNTIF function to determine: