mcs3500 a2
.pdf
keyboard_arrow_up
School
University of Guelph *
*We aren’t endorsed by this school
Course
3500
Subject
Marketing
Date
Apr 3, 2024
Type
Pages
8
Uploaded by CorporalDragonflyMaster637
Marketing Analytics M
C
S
3500
_S
ec. 2
(
Winter 2023)
Assignment 2: Market Response Model (100 Points)
Due on
March 03
(by mid
-
night)
Data:
boston housing.
csv
–
randomly sample only
406
house prices
from 50
6
house prices.
For all
questions
, use
log(
medv
)
as outcome
or dependent
variable
(
see data description
in next page
)
Multiple
Linear
Regression
(50
points
)
:
Q 1 (A).
Identify most important variables
using
best subset
algorithm
to
predict house
prices
using three
model selection
criteria (
RSS
= residual sum of square; adjr^2 = adjusted R^2 and
BIC
=Bayesian
information criteria).
20
points
Q 1 (B).
Develop a conceptual framework using
important variables identified in
Q 1 (A
). Also,
provide
descriptive
statistics
for
the
identified important variables
in
Q 1 (A)
.
(5 + 5 =
10
points
)
Q 1 (C).
Run multiple linear regression model with these identified variables
in Q 1 (A)
. Write regression
equation and
i
nterpret
any
four
regression coefficients.
20
points
Multiple
Linear Regression with Quadratic Effects (30
points
)
:
Q 2 (A).
Run multiple regression analysis with the variables identified in
Q 1 (A)
with adding quadratic
effects of
average numbers of rooms
(
rm
) and provide average marginal effects (ame)
with comments.
10
points
Q 2 (B).
Plot and interpret prediction and average marginal effects of
average number of rooms
(
rm
)
.
20
points
Multivariate Adaptive Splines (MARS)
(20
points
)
:
Q 3 (A).
Run MARS
using all variables in
the
housing data
to investigate non
-
linear response patterns.
Comments on your findings
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
NING SYSTEM (ACADEMIC)
Series forecasting for Business ||
The F-test used in testing the significance of a regression model is
O a. Upper tailed test
O b. Two tailed test
O c. Lower tailed test
O d. None
OUS PAGE
arrow_forward
After graduation, you take a position at Top-Slice, a well-known manufacturer of golf balls. One of your duties is to
forecast monthly demand for golf balls. Using the following data, you developed a regression model that expresses
monthly sales as a function of average temperature for the month:
Click the icon to view the additional data.
a. Show how the â and ɓ values of - 337.0 and 88.9 were calculated.
Calculate the slope coefficient, ɓ (enter your responses as whole numbers).
(755)(63110)
4252000
Б
12
= 88.9
(755)
50665
12
Monthly sales - 337.0+88.9 × (average temperature)
Calculate the intercept term, â (enter your responses rounded to one decimal place).
â= 5259.2 -88.9 × 62.92 = - 337.0
b. Use the regression forecasting model to forecast total golf ball sales for June and July 2018. Average temperatures are expected to be 73 degrees in June and 82 degrees in July.
The forecast of total golf ball sales for June 2018 is (Enter your response rounded to the nearest whole number.)…
arrow_forward
a) Using the trend-projection (regression) method, develop a forecastfor the sales of Volkswagen Beetles in Nevada through year 6.b) What is the MAD?~c) What is the MSE?
arrow_forward
After graduation, you take a position at Top-Slice, a well-known manufacturer of golf balls. One of your duties is to
forecast monthly demand for golf balls. Using the following data, you developed a regression model that expresses
monthly sales as a function of average temperature for the month:
Monthly sales=-202.2+86.5x (average temperature)
Click the icon to view the additional data.
a. Show how the a and 6 values of -202.2 and 86.5 were calculated.
Calculate the slope coefficient, b (enter your responses as whole numbers).
(745)
12
12
2
=86.5
More Info
March 2017
April
May
June
July
August
September
October
November
December
January 2018
February
Monthly Sales
5,300
3,990
5,700
6,520
7,600
7,420
Print
6,710
4,870
3,990
3,900
3,320
2,670
Temperature
51
56
Done
64
80
79
87
83
67
58
41
39
40
X
arrow_forward
Help please
arrow_forward
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month Gershe
collected the data shown in the following table
17
on 18
ne solve this Calculator Ask my instructor
!
1
Q
This exercise contains only parts b, c, and d.
b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places):
Y=0+0x
F1
@
2
W
F2
#3
C
80
F3
$
54
4
888
F4
do 5
%
Maroon 5 TV Appearances
Demand for Guitars
14
FO
A
6
MacBook Air
F6
&
1
7
8:
F7
00 *
8
358 57 7
368 4 9 6
DII
FB
(
9
DD
F9
)
0
O
A
F10
Clear all
?
C
F11
+ 11
=
Check answer
F12
delete
arrow_forward
Need both b and c
arrow_forward
Regression analysis. The owner of a small hardware store has noted a sales pattern for window locks that seems to parallel the number of break-ins reported each week in the newspaper. The data are:
Sales: 46 18 20 22 27 34 14 37 30Break-ins: 9 3 3 5 4 7 2 6 4a. Plot the data to determine which type of equation, linear or nonlinear, is appropriate.b. Obtain a regression equation for the data.c. Estimate average sales when the number of break-ins is five.
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Give typed full explanation
arrow_forward
The following data relate the sales figures of the barin Mark Kaltenbach’s small bed-and-breakfast inn in Portand, tothe number of guests registered that week:WEEK GUESTS BAR SALES1 16 $3302 12 2703 18 3804 14 300
a) Perform a linear regression that relates bar sales to guests (notto time).b) If the forecast is for 20 guests next week, what are the salesexpected to be? PX
arrow_forward
A study to determine the correlation between bankdeposits and consumer price indices in Birmingham, Alabama,revealed the following (which was based on n = 5 years of da ta):• LX = 15• Lx2 = 55• Lxy = 70• Ly = 20• L/ = 130a) What is the equation of the least-squares regression line?b) Find the coefficient of correlation. What does it imply to you?c) What is the standard error of the estimate?
arrow_forward
145) help with this please!!
arrow_forward
eBook
Problem 6-23 (Algorithmic)
The medical community unanimously agrees on the health benefits of regular exercise, but are adults listening? During each of the past 15 years, a polling organization has surveyed americans about their exercise habits. In the most recent of these polls, slightly over half of all American adults reported that they
exercise for 30 or more minutes at least three times per week. The following data show the percentages of adults who reported that they exercise for 30 or more minutes at least three times per week during each of the 15 years of this study.
Year
1
2
3
A
4
5
5
6
6
7
2
A
4
9
10
11
12
13
14
15
Percentage of Adults Who Exercise 30 or
more minutes at least three times per
week
41.2
45.1
47.3
45.6
46.6
44.5
47.8
50
48.1
49.1
50.1
52.1
50.8
54.6
52.4
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Related Questions
- NING SYSTEM (ACADEMIC) Series forecasting for Business || The F-test used in testing the significance of a regression model is O a. Upper tailed test O b. Two tailed test O c. Lower tailed test O d. None OUS PAGEarrow_forwardAfter graduation, you take a position at Top-Slice, a well-known manufacturer of golf balls. One of your duties is to forecast monthly demand for golf balls. Using the following data, you developed a regression model that expresses monthly sales as a function of average temperature for the month: Click the icon to view the additional data. a. Show how the â and ɓ values of - 337.0 and 88.9 were calculated. Calculate the slope coefficient, ɓ (enter your responses as whole numbers). (755)(63110) 4252000 Б 12 = 88.9 (755) 50665 12 Monthly sales - 337.0+88.9 × (average temperature) Calculate the intercept term, â (enter your responses rounded to one decimal place). â= 5259.2 -88.9 × 62.92 = - 337.0 b. Use the regression forecasting model to forecast total golf ball sales for June and July 2018. Average temperatures are expected to be 73 degrees in June and 82 degrees in July. The forecast of total golf ball sales for June 2018 is (Enter your response rounded to the nearest whole number.)…arrow_forwarda) Using the trend-projection (regression) method, develop a forecastfor the sales of Volkswagen Beetles in Nevada through year 6.b) What is the MAD?~c) What is the MSE?arrow_forward
- After graduation, you take a position at Top-Slice, a well-known manufacturer of golf balls. One of your duties is to forecast monthly demand for golf balls. Using the following data, you developed a regression model that expresses monthly sales as a function of average temperature for the month: Monthly sales=-202.2+86.5x (average temperature) Click the icon to view the additional data. a. Show how the a and 6 values of -202.2 and 86.5 were calculated. Calculate the slope coefficient, b (enter your responses as whole numbers). (745) 12 12 2 =86.5 More Info March 2017 April May June July August September October November December January 2018 February Monthly Sales 5,300 3,990 5,700 6,520 7,600 7,420 Print 6,710 4,870 3,990 3,900 3,320 2,670 Temperature 51 56 Done 64 80 79 87 83 67 58 41 39 40 Xarrow_forwardHelp pleasearrow_forwardMark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month Gershe collected the data shown in the following table 17 on 18 ne solve this Calculator Ask my instructor ! 1 Q This exercise contains only parts b, c, and d. b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y=0+0x F1 @ 2 W F2 #3 C 80 F3 $ 54 4 888 F4 do 5 % Maroon 5 TV Appearances Demand for Guitars 14 FO A 6 MacBook Air F6 & 1 7 8: F7 00 * 8 358 57 7 368 4 9 6 DII FB ( 9 DD F9 ) 0 O A F10 Clear all ? C F11 + 11 = Check answer F12 deletearrow_forward
- Need both b and carrow_forwardRegression analysis. The owner of a small hardware store has noted a sales pattern for window locks that seems to parallel the number of break-ins reported each week in the newspaper. The data are: Sales: 46 18 20 22 27 34 14 37 30Break-ins: 9 3 3 5 4 7 2 6 4a. Plot the data to determine which type of equation, linear or nonlinear, is appropriate.b. Obtain a regression equation for the data.c. Estimate average sales when the number of break-ins is five.arrow_forwardNote:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forward
- Give typed full explanationarrow_forwardThe following data relate the sales figures of the barin Mark Kaltenbach’s small bed-and-breakfast inn in Portand, tothe number of guests registered that week:WEEK GUESTS BAR SALES1 16 $3302 12 2703 18 3804 14 300 a) Perform a linear regression that relates bar sales to guests (notto time).b) If the forecast is for 20 guests next week, what are the salesexpected to be? PXarrow_forwardA study to determine the correlation between bankdeposits and consumer price indices in Birmingham, Alabama,revealed the following (which was based on n = 5 years of da ta):• LX = 15• Lx2 = 55• Lxy = 70• Ly = 20• L/ = 130a) What is the equation of the least-squares regression line?b) Find the coefficient of correlation. What does it imply to you?c) What is the standard error of the estimate?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningMarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing