QUESTION 1 Answer following questions based on the Excel le Credit Risk Data. You can download the CreditRiskData.xlsx from the book datasets in the course content. How many individuals with new-car loans are single, married, and divorced? 0 Single: 59 Married: 8 Divorced: 3? 0 Single: 79 Married: 13 Divorced: 27 0 Single: 29 Married: 18 Divorced: 2? 0 Single: 69 Married: 12 Divorced: 57 Use Excel's filtering capability to extract all records for individuals employed less than 12 months. How many of of these individuals are High Credit risk and how many are Low credit risk? 0 High: 82 Low: 63 0 High: 52 Low: 13 0 High: 132 Low: 3 0 High: 32 Low: 93 QUESTION 3 How many divorced females applied for New Car loan? 0 37 O 32 O 0 O 34 QUESTION 4 How many single females applied for New Car loan? 0 0 O 34 O 37 O 32 How many loans for furniture are applied by single individuals who rent? 0 4 O 25 O 26 O 6 QUESTION 6 How many education loans are applied by unskilled workers? 0 6 O IDC, IDK O 14 O 23 QUESTION 7 How many car loans {new or old) are applied by the individuals who are employed 12 months or less? 0 34 O 14 O 48 O 35 How many car loans {new or used) are applied by males who have been employed at least 36 months. 035 046 021 095