Chapter 2, Problem 15PE

Use the Excel file Credit Risk Data that was introduced in this chapter to perform the following activities:

1. Compute the combined checking and savings account balance for each record in the Base Data worksheet. Then sort the records by the number of months as a customer of the bank. From examining the data, does it appear that customers with a longer association with the bank have more assets?
2. Apply Pareto analysis to draw conclusions about the combined amount of money in checking and savings accounts.
3. Use Excel’s filtering capability to extract all records for new-car loans. How many individuals with new-car loans are single, married, and divorced?
4. Use Excel’s filtering capability to extract all records for individuals employed less than $12$ months. Can you draw any conclusions about the credit risk associated with these individuals?