Write a short recommendation you would make to the Bank executives base on your analysis...
80.2K
Verified Solution
Link Copied!
Question
Finance
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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!