Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A B D E F G H Credit Risk Checking 0 Months Customer 13 Low 0 25 Savings 718 1251 391 363 4875 0 19

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

A B D E F G H Credit Risk Checking 0 Months Customer 13 Low 0 25 Savings 718 1251 391 363 4875 0 19 High High High Low 13 639 964 2808 40 0 11 Low 0 13 0 242 531 493 6585 14 37 25 981 0 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 Months Employed Marital Status 12 Single 0 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 0 49 11 347 984 3515 575 827 231 10 Low Low High High High Low Low High Low Low High Low Low High 0 25 13 402 0 31 138 738 684 49 13 677 705 212 304 0 28 12445 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 Combined Checking and Savings Business 0 984 49 984 Furniture 677 738 49 1415 Education 964 4,875 40 5839 Small Appliance 6,585 493 37 7078 Used Car O 138 31. 138 Repairs 212 O 28 212 Furniture 0 1,251 25 1251 981 ON 25 981 Small Appliance New Car 0 827 25 827 New Car 0 391 19 391 Business 0 531 14 531 0 718 13 718 Small Appliance Furniture 639 363 13 1002 New Car 0 242 13 242 New Car 402 231 13 633 New Car 705 684 13 1389 Furniture 2,808 O 11 2808 New Car 0 3,515 11 3515 Business 347 575 10 922 Education 304 12,445 7 12749 From examining the data, does it appear that customers with a longer association with the bank have more assets? and the average amount in There 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 $ combined checking and savings for customers with less than or equal to 24 months (2 years) of association with the bank is $ (Round to the nearest cent as needed.) From examining the data, does it appear that customers with a longer association with the bank have more assets? There and the average amount in combir (Rounc 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 $ for customers with less than or equal to 24 months (2 years) of association with the bank is $ does not appear eded.) Enter y appears alds and then click Check

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions