Question
A loan department of a large bank is to analyze recent loans of a sample of 66 clients. A risk management officer collected data regarding
A loan department of a large bank is to analyze recent loans of a sample of 66 clients. A risk management officer collected data regarding the education level of the head of the household, family monthly income, monthly mortgage payment, gender of the head of the household, value of the house, and the location of the house (whether in the city, suburb, or in a town near the city). Based on the monthly income and mortgage, the risk management officer has calculated the Mortgage to Income Ratio (MTIR) and classified the loan as High or Low risk (High = 1, Low = 0). A colleague in the analytics department informed the officer that much more descriptive and inferential analysis can be conducted to obtain deeper insights. In particular, the officer must analyze the variables using appropriate descriptive techniques and interpret results. Also, the officer must analyze the characteristics of recent loans by determining the relationships between the variables. Finally, the officer must describe the characteristics of high-risk loans. The officer has reached out to your statistical consultancy group to help him with this task. Please support your findings by using appropriate hypothesis testing. Your task starts with a clear statement of your objectives. It would be beneficial to add at the beginning of your presentation a list of the parameters to be estimated and hypotheses to be tested whenever possible. Try to justify the methods you use to address your objectives. The presentation of the statistical techniques is expected to be formal. In addition, the source of the data analysis results must be documented and interpreted. Finally, managerial implications and conclusions are to be provided. Also, how to use megaStat to show correlation and regression with ANOVA with the significance, spss to determine if its two tailed or not, and tableau for this case study?
Step by Step Solution
3.33 Rating (159 Votes )
There are 3 Steps involved in it
Step: 1
objectives Analysis of recent loans from his 66 clients at major banks Describe the characteristics of recent loans by determining the relationships between variables Determining the characteristics o...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