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:
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.
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.
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 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.
Sample Solution
cerebrums What to think about cerebrum tumors This purchaser article clarifies the side effects, finding, and treatment of mind tumors. Presentation Each year I feel that in excess of 17,000 individuals in the United States are experiencing mind tumors. The National Cancer Institute (NCI) has made this booklet to support patients, their families and companions better comprehend mind tumors. We likewise need others to peruse it to get familiar with these tumors. This booklet clarifies the side effects, finding and treatment of mind tumors. Mind tumor is the multiplication of irregular cells in cerebrum tissue. Cerebrum tumor is amiable, there are no disease cells or dangerous tumors, and malignant growth cells quickly multiply. There is additionally an essential cerebrum tumor got from the mind. Others are metastatic, moving from the remainder of the body to the mind. The specialist analyze the mind tumor through assessment, for example, neurological assessment, MRI, CT sweep, biopsy, etc. Therapy alternatives incorporate perception pause, medical procedure, radiation treatment, chemotherapy, and focused on treatment. Directed treatment utilizes substances that assault disease cells without hurting typical cells. Numerous individuals get different medicines How to treat cerebrum metastasis? The fundamental therapies for cerebrum metastasis are medical procedure, radiation treatment, and medication treatment. The sort of therapy relies upon a few factors, for example, the kind of essential malignancy being analyzed, the quantity of tumors and the situation in the cerebrum, the hereditary change found in disease cells, general human wellbeing, Depends on. Components Patients may consider inspecting clinical preliminaries. Patients ordinarily get steroids to help lessen growing Radiation treatment Pediatric or grown-up radiation oncologists treat mind and spinal rope to execute disease cells utilizing high vitality radiation, (for example, X-beams or proton bars). Standard radiotherapy can be utilized, however proton treatment – accessible in a predetermined number of significant human services communities in the United States – limits radiation introduction to close by sound tissue and takes into account mind tumor Provide higher objective radiation portion. Chemotherapy utilizes medicine to slaughter tumor cells. For the most part, medulloblastoma youngsters and grown-ups intravenously (intravenous chemotherapy) these medications. Chemotherapy is suggested simultaneously as medical procedure or radiation treatment, or at times with radiation treatment. Sometimes, immature microorganism salvage (undifferentiated organism transplantation utilizing patient’s own undeveloped cells) is conceivable in the wake of utilizing high-portion chemotherapy.>
cerebrums What to think about cerebrum tumors This purchaser article clarifies the side effects, finding, and treatment of mind tumors. Presentation Each year I feel that in excess of 17,000 individuals in the United States are experiencing mind tumors. The National Cancer Institute (NCI) has made this booklet to support patients, their families and companions better comprehend mind tumors. We likewise need others to peruse it to get familiar with these tumors. This booklet clarifies the side effects, finding and treatment of mind tumors. Mind tumor is the multiplication of irregular cells in cerebrum tissue. Cerebrum tumor is amiable, there are no disease cells or dangerous tumors, and malignant growth cells quickly multiply. There is additionally an essential cerebrum tumor got from the mind. Others are metastatic, moving from the remainder of the body to the mind. The specialist analyze the mind tumor through assessment, for example, neurological assessment, MRI, CT sweep, biopsy, etc. Therapy alternatives incorporate perception pause, medical procedure, radiation treatment, chemotherapy, and focused on treatment. Directed treatment utilizes substances that assault disease cells without hurting typical cells. Numerous individuals get different medicines How to treat cerebrum metastasis? The fundamental therapies for cerebrum metastasis are medical procedure, radiation treatment, and medication treatment. The sort of therapy relies upon a few factors, for example, the kind of essential malignancy being analyzed, the quantity of tumors and the situation in the cerebrum, the hereditary change found in disease cells, general human wellbeing, Depends on. Components Patients may consider inspecting clinical preliminaries. Patients ordinarily get steroids to help lessen growing Radiation treatment Pediatric or grown-up radiation oncologists treat mind and spinal rope to execute disease cells utilizing high vitality radiation, (for example, X-beams or proton bars). Standard radiotherapy can be utilized, however proton treatment – accessible in a predetermined number of significant human services communities in the United States – limits radiation introduction to close by sound tissue and takes into account mind tumor Provide higher objective radiation portion. Chemotherapy utilizes medicine to slaughter tumor cells. For the most part, medulloblastoma youngsters and grown-ups intravenously (intravenous chemotherapy) these medications. Chemotherapy is suggested simultaneously as medical procedure or radiation treatment, or at times with radiation treatment. Sometimes, immature microorganism salvage (undifferentiated organism transplantation utilizing patient’s own undeveloped cells) is conceivable in the wake of utilizing high-portion chemotherapy.>
