A1 fx Loan Purpose B D E F G . 1 J Months Customer Checking 0 Credit Risk Low 13 0 25 Savings 741 1252 391 347 4877 0 19 High High High Low 639 13 971 40 2925 0 11 Low 0 227 13 Low 0 537 14 Low 494 37 6573 978 0 25 49 1 Loan Purpose 2 Small Appliance 3 Furniture 4 New Car 5 Furniture 6 Education 7 Furniture 8 New Car 9 Business 10 Small Appliance 11 Small Appliance 12 Business 13 New Car 14 Business 15 New Car 16 New Car 17 Used Car 18 Furniture 19 New Car 20 Repairs 21 Education 22 23 24 Months Employed Marital Status 12 Single O Divorced 119 Single 14 Single 45 Single 13 Married 16 Married 2 Single 9 Single 4 Divorced o Single 15 Single 14 Married 63 Single 26 Single 8 Divorced 4 Divorced 33 Single 116 Single 2 Divorced Job Unskilled Skilled Management Unskilled Skilled Skilled Unskilled Unskilled Skilled Skilled Management Unskilled Skilled Skilled Unskilled Management Skilled Skilled Skilled Skilled High High High Low 0 0 951 3394 574 11 338 10 0 25 823 228 Low High Low 408 13 0 127 31 733 49 661 702 Low High Low 687 13 0 28 215 286 Low High 12403 7 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? Complete the table below with the missing values. Marital Status Single count Married count Divorced count Loan Purpose Savings New Car 391 New Car 227 New Car 3,394 New Car 823 New Car 228 New Car 537 V (Type whole numbers.)