Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Credit Risk Data file posted on Campus Web contains data on loan applications and measures of credit risk for the applicants. The database contains the

Credit Risk Data file posted on Campus Web contains data on loan applications and measures of credit risk for the applicants. The database contains the purpose of the loan, the balance of checking and savings accounts, the length of time the applicant has been a customer and other demographic data. Your supervisor asks you to create a useful dashboard to present this data to the board of directors to convey the information about the loan applicants, their demographic, and credit risk. How would you present it?

Loan Purpose Checking Savings Months Customer Months Employed Gender Marital Status Age Housing Years Job Credit Risk
Small Appliance $0 $739 13 12 M Single 23 Own 3 Unskilled Low
Furniture $0 $1,230 25 0 M Divorced 32 Own 1 Skilled High
New Car $0 $389 19 119 M Single 38 Own 4 Management High
Furniture $638 $347 13 14 M Single 36 Own 2 Unskilled High
Education $963 $4,754 40 45 M Single 31 Rent 3 Skilled Low
Furniture $2,827 $0 11 13 M Married 25 Own 1 Skilled Low
New Car $0 $229 13 16 M Married 26 Own 3 Unskilled Low
Business $0 $533 14 2 M Single 27 Own 1 Unskilled Low
Small Appliance $6,509 $493 37 9 M Single 25 Own 2 Skilled High
Small Appliance $966 $0 25 4 F Divorced 43 Own 1 Skilled High
Business $0 $989 49 0 M Single 32 Rent 2 Management High
New Car $0 $3,305 11 15 M Single 34 Rent 2 Unskilled Low
Business $322 $578 10 14 M Married 26 Own 1 Skilled Low
New Car $0 $821 25 63 M Single 44 Own 1 Skilled High
New Car $396 $228 13 26 M Single 46 Own 3 Unskilled Low
Used Car $0 $129 31 8 M Divorced 39 Own 4 Management Low
Furniture $652 $732 49 4 F Divorced 25 Own 2 Skilled High
New Car $708 $683 13 33 M Single 31 Own 2 Skilled Low
Repairs $207 $0 28 116 M Single 47 Own 4 Skilled Low
Education $287 $12,348 7 2 F Divorced 23 Rent 2 Skilled High
Furniture $0 $17,545 34 16 F Divorced 22 Own 4 Skilled High
Furniture $101 $3,871 13 5 F Divorced 26 Rent 4 Skilled High
Furniture $0 $0 25 23 M Married 19 Own 4 Skilled High
Furniture $0 $485 37 23 F Divorced 27 Own 2 Management High
New Car $0 $10,723 11 15 M Single 39 Rent 2 Unskilled Low
Business $141 $245 22 33 M Single 26 Own 3 Skilled Low
Used Car $0 $0 19 58 M Single 50 Other 4 Skilled High

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

Financial Management Principles And Practices

Authors: Timothy J. Gallagher

9th Edition

1954156103, 978-1954156104

More Books

Students also viewed these Finance questions