Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Take the scenario presented in the Bank Loan case study. For this scenario, come up with 1) the Business opportunity, 2) Business Objectives, 3) Business

Take the scenario presented in the Bank Loan case study. For this scenario, come up with1) the Business opportunity, 2) Business Objectives, 3) Business Questions, 4) Data Analytic questions, 5) Data collection plan of action and 6) the actual hypothesis tests or regression analyses you would do to answer the questions in step 4. (You don't have to do the hypothesis tests or regression analysis here. Just mention what you would do.)

This case study concerns a bank's efforts to reduce the rate of loan defaults. A loan officer at a bank needs to be able to identify characteristics that are indicative of people who are likely to default on loans and use those characteristics to identify good and bad credit risks. The loan officer also needs to be able to better quantify an individual's credit risk level. Information on 850 past and prospective customers in contained in bank loan. The first 700 cases are customers who were previously given loans. The last 150 cases are prospective customers that the bank needs to assess. The data set includes the following variables: 1. Age: customer age in years. 2. College: an indicator of whether the customer has a college education 3. Employment: years that the customer has been with his/her current employer 4. Address: years that the customer has lived at his/her current address 5. Income: household annual income (in $1,000) 6. Debt _to _Income: debt to income ratio (x100) 7. Credit _Debt: credit card debt (in $1,000) 8. Other _Debt: other debt (in $1,000) 9. Risk _Score: Credit risk score (the higher the score, the more risky) 10. Default _Indicator: an indicator of whether the customer had previously defaulted

image text in transcribedimage text in transcribed
Age College Years Years at Household Debt Credit Other Credit Risk Previously in Education with current income in to card debt debt in Score Defaulted years cur rrent address thousands income in thousands employer ratio thousands (x100) 41 H 17 12 176 9.3 11.359392 5.008608 808.3943274 1 31 0 17.3 1.362202 4.000798 198.2974762 0 27 10 6 40 0 15 14 5.5 5.5 0.856075 2.168925 10.0361081 0 0 41 15 14 120 2.9 2.65872 0.82128 22.13828376 0 24 0 2 0 28 17.3 1.787436 3.056564 781.5883142 41 0 0 UT 5 25 10.2 0.3927 2.1573 216.7089415 39 0 0 20 NO 67 30.6 3.833874 16.668126 185.9601084 43 12 38 3.6 0.128592 1.239408 14.70865349 0 24 0 m 4 19 24.4 1.358348 3.277652 748.0412036 1 36 25 0 13 19.7 2.7777 2.1473 815.0570131 0 27 0 1.7 0.182512 0.089488 350.309226 25 0 4 0 23 5.2 0.252356 0.943644 239.0539023 0 24 79 10 3.9296 2.4704 9.790173473\f

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

Step: 3

blur-text-image

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

Quantitative Analysis For Management

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna

11th Edition

9780132997621, 132149117, 132997622, 978-0132149112

Students also viewed these Mathematics questions

Question

Teachers Role?

Answered: 1 week ago

Question

International conference on population and development ?

Answered: 1 week ago

Question

Approach to population ?

Answered: 1 week ago