Write a short recommendation you would make to the Bank executives base on your analysis...

80.2K

Verified Solution

Question

Finance

  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

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!
Become a Member

Other questions asked by students