Reference no: EM132513999
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
Use the COUNTIF function to? determine:
Question a. How many customers applied for? new-car loans
Question b. How many customers applied for ?used-car loans
Question c. How many customers applied for business loans
Question d. How many customers applied for furniture loans
Question e. The number of customers with checking account balances less than? $500