a.

b.

c.

d.

I really need a,b,c,d please and thank you

Credit Risk Data 12 Loan Purpose Checking Small Appliance 0 Furniture 0 New Car 0 Fumiture 626 Education 971 Furniture 2,864 New Car 0 Business 0 Small Appliance 6,593 Small Appliance 998 Business 0 New Car 0 Business 336 New Car 0 New Car 411 Months Months Marital Credit Savings Customer Employed Status Job Risk 737 13 Single Unskilled Low 1,225 25 0) Divorced Skilled High 392 19 119 Single Management High 345 13 14 Single Unskilled High 4,736 401 45 Single Skilled Low 0 11 13 Married Skilled Low 254 13 16 Married Unskilled Low 522 14 2 Single Unskilled Low 503 37 9 Single Skilled High 0 25 Divorced SHilled High 997 49 0 Single Management High 3.551 11 15 Single Unskilled Low 584 1 Married Skilled Low 822 25 63 Single Skilled High 226 13 26 Single Unskilled Low 10 Low New Car Used Car Fumiture New Car Repairs Education 411 0 653 705 214 293 226 122 744 687 0 12.344 31 49 13 28 7 8 Divorced Management 4 Divorced Skilled 33 Single Skilled 116 Single Skilled 2 Divorced Skolled High Low Low High WIN a. Compute the combined checking and savings account balance for each record. Then sort the records by the number of months as a customer of the bank in descending order. Complete the table below with the missing values for the sorted, combined balances. Loan Purpose Checking Savings Months Customer 49 Combined Checking and Savings nt Business 0 997 Fumiture 653 744 Crui Education 971 40 4.736 503 6.593 37 Ext Co 0 122 31 Small Appliance Used Car Repairs Furniture 214 0 udy PI 0 1.225 25 998 0 25 Jideo & Library Small Appliance New Car D 822 0 New Car 392 Accessit 19 Business 0 522 14 Durch 0 737 Small Appliance Fumiture 626 345 13 New Car 0 254 13 New Car 411 226 13 New Car 705 687 Fumiture 2.864 0 11 11 New Car 0 3,551 11 Business 336 584 10 Education 293 12.344 7 PI From examining the data, does it appear that customers with a longer association with the bank have more assets? & ary There V to be a significant difference because the average amount in combined checking and savings for customers with greater than 24 months (2 years) of association with the bank is s and the average amount in combined checking and savings for customers with less than or equal to 24 months 2 years) of association with the bank is S (Round to the nearest cent as needed.) essit Tshas b. Apply Pareto analysis to draw conclusions about the combined amount of money in checking and savings accounts. Complete the Pareto analysis table below. (Type an integer or decimal rounded to two decimal places as needed Combined Checking Cumulative % % Cumulative % and Savings Customers 12,637 7,096 5,707 ui 3,551 2.864 1.397 By PI 1392 eo & orary 1,225 998 ccessit 997 971 920 822 737 637 522 392 254 E 214 122 PI What can be concluded about the combined amount of money in checking and savings accounts ? ary O A. Less than 25% of the customers have 80% of the total balance. OOO B. More than 25% of the customers have 80% of the total balance. essit C More than 80% of the customers have 25% of the total balance chas D. Less than 80% of the customers have 25% of the total balance 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 Divorced count count Loan Purpose Savings New Car 392 New Car 254 ui New Car 3,551 New Car 822 New Car 226 y PI New Car 522 20 & (Type whole numbers.) 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? Complete the table below with the missing values. Months Marital Credit Loan Purpose Employed Status Risk Furniture 0 Divorced High Low Count Count ui Business 0 Single Single Business 2 CO Education 2 Divorced y PI Furniture 4 Divorced Small Appliance 4 Divorced 7 eo & rary Used Car 8 Divorced cessik 9 Small Appliance Single V (Type whole numbers.) Can you draw any conclusions about the credit risk associated with these individuals? y A. Risk is never high when employment time is low. B. Risk is lower if employment time is low, C. Risk is never low when employment time is low. D. Risk is higher if employment time is low. E. There is no association between risk and employment time. esit Chas