Case Study - Mortgage Approval Time Study

Use the data shown in the table to conduct a design of experiment (DOE) in MS Excel to test cause-and-effect relationships in the mortgage approval time for the financial services company. Identify the key drivers of the process.

Thoroughly used the data shown in the table to conduct a design of experiment (DOE) to test cause-and-effect relationships in the mortgage approval time for the financial services company. Thoroughly identified the key drivers of the process.

Determine the graphical display tool (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.

Determined the graphical display tool (interaction effects chart, scatter chart, et cetera) that you would use to present the results of the DOE that you conducted in Question 1. Thoroughly provided a rationale for your response.

Assess the data sampling method by determining if the sample size is sufficient, determining if effects of variables can be measured, recommending a sample size for future study, and stating what analysis can be done with larger sample sizes.

Thoroughly assessed the data sampling method by determining if the sample size is sufficient, determining if effects of variables can be measured, recommending a sample size for future study, and stating what analysis can be done with larger sample sizes.

Provide other variable responses that might be of interest to measure and study.

Thoroughly provided other variable responses that might be of interest to measure and study.

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

Proposed one overall recommendation to the financial services company, based on the DOE, that could help reduce mortgage approval times. Thoroughly provided a rationale for your response.

Writing and support for ideas.

Consistently uses reasons and evidence that logically support ideas.

Complete presentation requirements.

Presentation includes 10 or more slides in addition to a cover slide and a reference slide. There is a consistent theme or design throughout and all slides are easy to read.

Writing mechanics, grammar, and formatting.

Error-free or almost error-free grammar, spelling, punctuation, and formatting.