Question
Loan Purpose Checking Savings Months Customer Months Employed Marital Status Job Credit Risk Small Appliance 0 743 13 12 Single Unskilled Low Furniture 0 1,247
Loan Purpose Checking Savings Months Customer Months Employed Marital Status Job Credit Risk Small Appliance 0 743 13 12 Single Unskilled Low Furniture 0 1,247 25 0 Divorced Skilled High New Car 0 391 19 119 Single Management High Furniture 624 345 13 14 Single Unskilled High Education 968 4,748 40 45 Single Skilled Low Furniture 2,907 0 11 13 Married Skilled Low New Car 0 232 13 16 Married Unskilled Low Business 0 541 14 2 Single Unskilled Low Small Appliance 6,528 491 37 9 Single Skilled High Small Appliance 936 0 25 4 Divorced Skilled High Business 0 981 49 0 Single Management High New Car 0 3,489 11 15 Single Unskilled Low Business 322 577 10 14 Married Skilled Low New Car 0 825 25 63 Single Skilled High New Car 405 233 13 26 Single Unskilled Low Used Car 0 122 31 8 Divorced Management Low Furniture 678 743 49 4 Divorced Skilled High New Car 701 689 13 33 Single Skilled Low Repairs 216 0 28 116 Single Skilled Low Education 283 12,468 7 2 Divorced Skilled High
0 345 sz2 577 Use the accompanying Credit Risk Data to perform the activities in parts a through d below Click the icon to view the Credit Risk Data. 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 Combined Checking and Customer Savings Business 0 981 49 981 Furniture 678 743 49 1421 Education 968 4.748 40 5716 Small Appliance 6.528 491 37 7019 Used Car o 122 31 122 Repairs 216 28 216 Furniture 0 1.247 25 1247 Small Appliance 936 0 25 936 New Car 0 825 25 825 New Car 391 19 391 Business o 541 14 541 Small Appliance 0 743 13 743 Furniture 624 13 969 New Car o 232 13 232 New Car 405 233 13 638 New Car 701 689 13 1390 Furniture 2,907 0 2907 New Car 0 3.489 11 3489 Business 10 899 Education 12.468 7 12751 From examining the data, does it appear that customers with a longer association with the bank have more assets? There does not appear 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 $ 2053.67 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 $ 2268.18 (Round to the nearest cent as needed.) 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 and Savings Customers 12751 29.36 29.36 5 7,019 16.16 45.52 10 5,716 13.16 58.68 15 3.489 8.03 66 71 20 2,907 6.69 73.41 25 1,421 3.27 76.68 30 1.390 3.20 79.88 35 1,247 2.87 82.75 40 981 2.26 85 45 969 87.24 50 936 2.16 89.39 55 899 2.07 91.46 825 1.90 93.36 65 743 95.07 70 638 1.47 96.54 75 541 1.25 97.79 80 391 0.90 98.69 85 232 0.53 99.22 90 216 0.50 99.72 95 122 0.29 100 100 Cumulative Cumulative 2.23 171 What can be concluded about the combined amount of money in checking and savings accounts? O A Less than 80% of the customers have 25% of the total balance OB Less than 25% of the customers have 90% of the total balance C. More than 25% of the customers have 80% of the total balance. OD. More than 80% of the customers have 25% of the total balance. c. Use Excels 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 Single Married Divorced Loan Purpose Savings Status count count count New Car 391 New Car 232 New Car 3.489 New Car 825 V New Car 233 New Car (Type whole numbers.) 40 45 37 Loan Purpose Checking Small Appliance 0 Furniture 0 New Car 0 Furniture 624 Education 968 Furniture 2,907 New Car 0 Business 0 Small Appliance 6,528 Small Appliance 936 Business 0 New Car 0 Business 322 New Car 0 New Car 405 Used Car 0 Furniture 678 New Car 701 Repairs 216 Education 283 Months Months Marital Savings Customer Employed Status Job 743 13 12 Single Unskilled 1,247 25 0 Divorced Skilled 391 19 119 Single Management 345 13 14 Single Unskilled 4,748 Single Skilled 0 11 13 Married Skilled 232 13 16 Married Unskilled 541 14 2 Single Unskilled 491 9 Single Skilled 0 25 4 Divorced Skilled 981 49 0 Single Management 3,489 11 15 Single Unskilled 577 10 14 Married Skilled 825 25 Single Skilled 233 13 26 Single Unskilled 122 31 8 Divorced Management 743 49 4 Divorced Skilled 689 Single Skilled 0 28 116 Single Skilled 12,468 7 2 Divorced Skilled Credit Risk Low High High High Low Low Low Low High High High Low Low High Low Low High Low Low High 63 13 33 0 345 sz2 577 Use the accompanying Credit Risk Data to perform the activities in parts a through d below Click the icon to view the Credit Risk Data. 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 Combined Checking and Customer Savings Business 0 981 49 981 Furniture 678 743 49 1421 Education 968 4.748 40 5716 Small Appliance 6.528 491 37 7019 Used Car o 122 31 122 Repairs 216 28 216 Furniture 0 1.247 25 1247 Small Appliance 936 0 25 936 New Car 0 825 25 825 New Car 391 19 391 Business o 541 14 541 Small Appliance 0 743 13 743 Furniture 624 13 969 New Car o 232 13 232 New Car 405 233 13 638 New Car 701 689 13 1390 Furniture 2,907 0 2907 New Car 0 3.489 11 3489 Business 10 899 Education 12.468 7 12751 From examining the data, does it appear that customers with a longer association with the bank have more assets? There does not appear 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 $ 2053.67 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 $ 2268.18 (Round to the nearest cent as needed.) 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 and Savings Customers 12751 29.36 29.36 5 7,019 16.16 45.52 10 5,716 13.16 58.68 15 3.489 8.03 66 71 20 2,907 6.69 73.41 25 1,421 3.27 76.68 30 1.390 3.20 79.88 35 1,247 2.87 82.75 40 981 2.26 85 45 969 87.24 50 936 2.16 89.39 55 899 2.07 91.46 825 1.90 93.36 65 743 95.07 70 638 1.47 96.54 75 541 1.25 97.79 80 391 0.90 98.69 85 232 0.53 99.22 90 216 0.50 99.72 95 122 0.29 100 100 Cumulative Cumulative 2.23 171 What can be concluded about the combined amount of money in checking and savings accounts? O A Less than 80% of the customers have 25% of the total balance OB Less than 25% of the customers have 90% of the total balance C. More than 25% of the customers have 80% of the total balance. OD. More than 80% of the customers have 25% of the total balance. c. Use Excels 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 Single Married Divorced Loan Purpose Savings Status count count count New Car 391 New Car 232 New Car 3.489 New Car 825 V New Car 233 New Car (Type whole numbers.) 40 45 37 Loan Purpose Checking Small Appliance 0 Furniture 0 New Car 0 Furniture 624 Education 968 Furniture 2,907 New Car 0 Business 0 Small Appliance 6,528 Small Appliance 936 Business 0 New Car 0 Business 322 New Car 0 New Car 405 Used Car 0 Furniture 678 New Car 701 Repairs 216 Education 283 Months Months Marital Savings Customer Employed Status Job 743 13 12 Single Unskilled 1,247 25 0 Divorced Skilled 391 19 119 Single Management 345 13 14 Single Unskilled 4,748 Single Skilled 0 11 13 Married Skilled 232 13 16 Married Unskilled 541 14 2 Single Unskilled 491 9 Single Skilled 0 25 4 Divorced Skilled 981 49 0 Single Management 3,489 11 15 Single Unskilled 577 10 14 Married Skilled 825 25 Single Skilled 233 13 26 Single Unskilled 122 31 8 Divorced Management 743 49 4 Divorced Skilled 689 Single Skilled 0 28 116 Single Skilled 12,468 7 2 Divorced Skilled Credit Risk Low High High High Low Low Low Low High High High Low Low High Low Low High Low Low High 63 13 33Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started