Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a short recommendation you would make to the Bank executives base on your analysis of the dat Support your reasoning with the pivot tables

  1. Write a short recommendation you would make to the Bank executives base on your analysis of the dat Support your reasoning with the pivot tables you calculated for the problem.
Row Labels Count of Loan Purpose
Small Appliance 105
New Car 104
Furniture 85
Business 44
Used Car 40
Education 23
Repairs 12
Other 6
Large Appliance 4
Retraining 2
Grand Total 425

Row Labels Average of Checking Average of Savings
Business $1,764.70 $1,421.82
Education $726.70 $1,337.39
Furniture $740.04 $1,916.22
Large Appliance $0.00 $4,555.50
New Car $1,359.78 $1,518.74
Other $379.17 $979.67
Repairs $339.83 $753.50
Retraining $322.00 $301.50
Small Appliance $1,167.70 $2,393.32
Used Car $427.98 $1,778.68
Grand Total $1,048.01 $1,812.56

Count of Credit Risk Column Labels
Row Labels High Low Grand Total
Business 23 21 44
Education 14 9 23
Furniture 43 42 85
Large Appliance 3 1 4
New Car 65 39 104
Other 4 2 6
Repairs 4 8 12
Retraining 1 1 2
Small Appliance 42 63 105
Used Car 12 28 40
Grand Total 211 214 425

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Fundamentals Of Multinational Finance

Authors: Michael H. Moffett, Arthur I. Stonehill, David K. Eiteman

1st Edition

0201844842, 978-0201844849

More Books

Students also viewed these Finance questions