The worksheet Base Data in the Excel file

Credit Risk Dataopens in a new tab

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 enter your response here

b. How many customers applied for used-car loans enter your response here

c. How many customers applied for business loans enter your response here

d. How many customers applied for furniture loans enter your response here

e. The number of customers with checking account balances less than $500 enter your response here

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:

Credit Risk Data