Answered step by step
Verified Expert Solution
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
- 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
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