Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... 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

Accounting Information System

Authors: James A. Hall

7th Edition

978-1439078570, 1439078572

More Books

Students also viewed these Accounting questions

Question

4. (8 points) Fill in with =, >, >=,

Answered: 1 week ago

Question

Name this molecule. OH Ci

Answered: 1 week ago

Question

Working with athletes who dope

Answered: 1 week ago

Question

Give an application for a replicated database.

Answered: 1 week ago

Question

Define commodity IT asset.

Answered: 1 week ago

Question

Name the three types of addresses used on the Internet.

Answered: 1 week ago