Use the Excel file credit risk data that was introduced in this chapter to perform the following activities: $$A$)$ Compute the combine 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?$$ B$)$ Apply Pareto analysis to draw conclusions about the combined amount of money in the checking and savings accounts.$$ c$)$ 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?$$ D$)$ 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?