Use the accompanying Credit Risk Data to perform the activities in parts a through d below.

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	951	49	951
Furniture	661	733	4949	1394
Education	971	4,877	40	5848
Small Appliance	6,573	494	37	7067
Used Car	0	127	31	127
Repairs	215	0	2828	215
Furniture	0	1,252	25	1252
Small Appliance	978	0	25	978
New Car	0	823	2525	823

New Car	0	391	19	391
Business	0	537	14	537
Small Appliance	0	741	1313	741
Furniture	639	347	13	986
New Car	0	227	13	227
New Car	408	228	13	636
New Car	702	687	1313	1389
Furniture	2,925	0	11	2925
New Car	0	3,394	11	3394
Business	338	574	10	912
Education	286	12,403	7	12689

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 nothing?

Answer rating: 100% (QA)

Loan Purpose Checking Savings Months Combined checkings an... View the full answer