All our Essay orders are Original, and are written from scratch. Try us today at 30% off

Determine the graphical display tool (Interaction Effects Chart, Scatter Chart, et cetera) that you would use to present the results of the DOE you conducted in Question 1. Provide a rationale for your response.

CASE STUDY: MORTGAGE APPROVAL TIME STUDY

Case Study: 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 good versus fair credit history, the size of the mortgage (less than $500,000 versus greater than $500,000), and the region of the United States (western versus eastern) on the 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 chosen 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 to determine the nature and magnitude of the effects of the three variables on mortgage approval times. Identify the key drivers of this process.

2. Determine the graphical display tool (Interaction Effects Chart, Scatter Chart, et cetera) that you would use to present the results of the DOE you conducted in Question 1. Provide a rationale for your response.

3. Assess the data sampling method:

. Determine if the sample size is sufficient.

. Identify circumstances under which would it have been appropriate to select a larger sample. Determine whether a sample of five mortgages is adequate to access the relative magnitudes of the effects of the variables.

. Recommend a sample size for future study and discuss what analysis can be made with a larger sample size. (Hint: Look back at Chapters 2, 3, 5, and 6 for discussion of sampling.)

· 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?)

· Propose one overall recommendation to the financial services company based on the DOE that could help reduce mortgage approval times.

· Use Basic Search: Strayer University Online Library to identify at least two quality references to support your discussion. Note: Wikipedia and other websites do not qualify as academic resources.

Second, create a PowerPoint presentation to communicate the data analysis you completed. Your submission must meet these requirements:

· A PowerPoint presentation with at least 10 content slides that include the answers to questions 1 through 5.

· A reference slide and cover slide with the title of the assignment, your name, the professor’s name, the course title, and the date.

. Note: The cover and reference slides are not included in the required number of slides.

· Formatting of the slides should be consistent and easy to read.

This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.

The specific course learning outcome associated with this assignment is:

· Develop recommendations to improve business processes using statistical tools and analysis.
The post Determine the graphical display tool (Interaction Effects Chart, Scatter Chart, et cetera) that you would use to present the results of the DOE you conducted in Question 1. Provide a rationale for your response. first appeared on Assignment writing service.

  

Testimonials

Best Service

The book review I asked for is so amazing! Endless thanks to your team for completing my review and for...

Comes through every time

I have used this website for many times, and each time they found perfect writers for me and they produce...

No Complaints So far Guys

Yeah …I really like all the discounts that they offer, the prices are very flexible. Plus they have different promotions...

Great Job

Great job! Those were you, guys, who made my coursework perfect in time according to all my requirements. I will...

Best

They look cool and trustworthy enough to me. I gather they made discounts as their prices are quite affordable if...

Mh! not bad…

The worst part ever was to find my deadline postponed for 1 hour ! They couldn`t finish the essay within...

CLICK HERE  To order your paper

About Scholarfront Essay writing service

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for upto 20% off in their first Order. Our payment method is safe and secure.

 CLICK HERE to Order Your Assignment

 

ORDER WITH 15% DISCOUNT

Let your paper be done by an expert

Custom Essay Writing Service

Our custom essay writing service has already gained a positive reputation in this business field. Understandably so, all custom papers produced by our academic writers are individually crafted from scratch and written according to all your instructions and requirements. We offer Havard, APA, MLA, or Chicago style papers in more than 70 disciplines. With our writing service, you can get quality custom essays, as well as a dissertation, a research paper, or term papers for an affordable price. Any paper will be written on time for a cheap price.

Professional Essay writing service

When professional help in completing any kind of homework is all you need, scholarfront.com is the right place to get it. We guarantee you help in all kinds of academia, including essay, coursework, research, or term paper help etc., it is no problem for us. With our cheap essay writing service, you can be sure to get credible academic aid for a reasonable price, as the name of our website suggests. For years, we have been providing online custom writing assistance to students from countries all over the world, including the United States, Canada, the United Kingdom, Australia, Italy, New Zealand, China, and Japan.