A loan department of a large bank is to analyze recent loans of a sample of 66
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 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?