MGMT 414: Management Analytics Lab Assignment: Chapter 9
1. When interest rates decline, Patriot Bank has found they get inundated with
requests to refinance home mortgages. To better plan its staffing needs in the
mortgage processing area of its operations, Patriot wants to develop a
regression model to help predict the total number of mortgage applications
(Y) each month as a function of the prime interest rate (X1). The bank
collected the data shown in the file PatriotBank.xlsx representing the average
prime interest rate and total number of mortgage applications in 20 different
months.
1. Prepare a scatter plot of these data. Does there appear to be a linear
relationship between these variables.
2. Obtain a simple linear regression model by producing output tables.
3. Interpret the R^2 for the model you obtained.
4. What is the number of mortgage applications Patriot could expect to
receive in a month where the interest rate is 6%.
2. A recruiter for Big Box stores has collected the data in the file BigBox.xlsx
summarizing the amount of money the company spent on print, web, and TV
advertising in California over the past 22 months and the resulting number of
applications received from job applicants during the same months. The
recruiter would like to build a regression model to predict the number of
applications the company should expect based on a given advertising mix.
1. Prepare scatter plots showing the relationship between the number of
applications received and each of the independent variables. What sort
of relationship does each plot suggest?
2. If the recruiter wanted to build a regression model using only one
independent variable to predict the number of applications received,
what variable should be used?
3. What set of independent variables results in the highest value for the
adjusted-R 2 statistic?
4. Suppose the recruiter chooses to use the regression function with all
independent variables X1, X2, and X3. What is the estimated regression
function?
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
