4.

Excel file Credit Risk Data provides information about 425 bank customers who applied for loans. The data include 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. a. Use an Excel function to determine how many customers applied for different loan purpose such as new-car, used-car, business, education, small-appliance, and furniture loans. b. Figure out the number of customers who applied for new car with at least $1,000 savings account balance.