Yale University Mortgage Approval Time Study Case Study Presentation

Need help with my Economics question – I’m studying for my class.

Case Study 2: Mortgage Approval Time Study

Read the following case study:

A major financial services company wishes to better understand its mortgage approval process. In particular, the company is interested in learning about the effects of credit history (good versus fair), the size of the mortgage (<$500,000 versus >$500,000), and the region of the United States (western versus eastern) on the amount of time it takes to get a mortgage approved. The database of mortgages approved in the last year is accessed, and a random sample of five approved mortgages is selected for each of the eight combinations of the three variables. The data are shown in the table

Mortgage Approval Time Study
Credit History Mortgage Size Region Approval Times (days) Approval Times (days) Approval Times (days) Approval Times (days) Approval Times (days)
Good <$500,000 Western 59 50 64 62 47
Fair <$500,000 Western 81 58 69 65 74
Good >$500,000 Western 38 52 58 60 65
Fair >$500,000 Western 146 159 133 143 129
Good <$500,000 Eastern 28 26 38 41 21
Fair <$500,000 Eastern 42 53 40 50 64
Good >$500,000 Eastern 49 31 49 42 38
Fair >$500,000 Eastern 106 115 126 118 138

First, conduct an analysis using the following steps:

  1. Use the data shown in the table to conduct a design of experiment (DOE) in Microsoft Excel in order determine the nature and magnitude of the effects of the three variables on mortgage approval times. What are the key drivers of this process?
  2. Determine the graphical display tool (e.g., Interaction Effects Chart, Scatter Chart, et cetera) that you would use to present the results of the DOE that you conducted in Question 1. Provide a rationale for your response.
  3. Assess the data sampling method. Our sample contained only five mortgages per combination. Under what circumstances would it have been appropriate to select a larger sample? Is a sample of five mortgages adequate to access the relative magnitudes of the effects of the variables? What sample size would you recommend? What could you learn from a larger sample size? (Hint: Look back at chapter 2, 3, 5, and 6 for discussion of sampling.)
  4. Provide other variable responses that might be of interest to measure and study. (Hint: If you were getting a mortgage or a loan, what are the two most important measures of the process you would have to go through?)
  5. Propose one overall recommendation to the financial services company, based on the DOE, that could help reduce mortgage approval times.
  6. identify at least two quality references to support your discussion. Note: Wikipedia and other websites do not qualify as academic resources.

Second, create a PPT presentation to communicate the data analysis you completed. Your presentation must follow these formatting requirements:

  • A PPT presentation with at least 10 slides that include the answers to questions 1 through 5.
  • A reference slide which follows APA format. Check with your professor for any additional instructions.
  • Formatting of the slides should be consistent and easy to read.
  • Cover slide containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date.
  • Note: The cover slides and the reference slides are not included in the required assignment slides length.

The specific course learning outcome associated with this assignment is:

  • Develop recommendations to improve business processes, using statistical tools and analysis.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyhomeworkGeeks
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business and administrative studies
looks good thank you
Customer 452773, March 3rd, 2023
Business and administrative studies
excellent paper
Customer 452773, March 3rd, 2023
Social Work and Human Services
Great work I would love to continue working with this writer thought out the 11 week course.
Customer 452667, May 30th, 2021
Business and administrative studies
Excellent job
Customer 452773, March 17th, 2023
Sociology
THANK YOUUUUU
Customer 452591, March 18th, 2021
Nursing
I just need some minor alterations. Thanks.
Customer 452547, February 10th, 2021
Leadership Studies
excellent job as always
Customer 452773, September 2nd, 2023
business
Thank you for your hard work and help.
Customer 452773, February 13th, 2023
Human Resources Management (HRM)
excellent, great job
Customer 452773, June 19th, 2023
Criminal Justice
This has been the greatest help while I am recovering from an illness. Thank your team so much.
Customer 452671, May 2nd, 2021
10th grade English
very good
Customer 452773, March 26th, 2023
Business and administrative studies
Thank you
Customer 452773, March 19th, 2023
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Close

Sometimes it is hard to do all the work on your own

Let us help you get a good grade on your paper. Get professional help and free up your time for more important courses. Let us handle your;

  • Dissertations and Thesis
  • Essays
  • All Assignments

  • Research papers
  • Terms Papers
  • Online Classes
Live ChatWhatsApp