Wan Lu, 00321433
MKTG 352-006
Assignment 6
Please use the “DanoPizza_assign4.xlsx” data file to answer the following questions. These
data are from a comprehensive, large scale marketing research study on two researc
...
Wan Lu, 00321433
MKTG 352-006
Assignment 6
Please use the “DanoPizza_assign4.xlsx” data file to answer the following questions. These
data are from a comprehensive, large scale marketing research study on two research
questions: (a) consumer behavior and satisfaction of Dano’s Pizza, and (b) effectiveness of a
recent promotion program of Dano’s Pizza. As a result, the data file includes (1) survey
questions regarding dining habits, satisfaction, and demographic information of consumers of
Dano’s Pizza, and (2) records on consumers’ spending on Dano’s Pizza after receiving
coupons from social media or coupons from mails. The questions that correspond to each
variable can be seen by clicking on the “variable view” sheet of the data file and looking at
the “labels”.
1. Regression: Acquiring or attracting new consumers is one of the most important issues for
the service firms. Since positive word of mouth from existing consumers serves as the most
effective way to attract new consumers, Dano’s Pizza wants to know what factors drive
positive word of mouth. Use regression to help Dano’s Pizza to understand this issue. Use
LikeRecom as the dependent variable Use satis_food (satisfaction regarding food) and
overall_online_exp (ratings regarding online order experience) as the independent variables.
a. What is the magnitude of R2 and what does it mean?
The magnitude of R2 is 0.133. It means approximately 13.33% of the variation in Likely to
recommend is explained by stratification regarding food (satis_food) and ratings regarding
online order experience (overall_online_exp) together.
b. Which variables are significant predictors of likelihood to recommend?
Step 1. Regression Model: Like to recommend = 1.89 + 0.16 satis_food + 0.2 online_exp +
error
Step 2. Hypothesis:
H0 = Regression Model is not significant
H1= Regression Model is significant
The regression model is significant since the level of significance at 5% is significantly better
than the significance F 0.013 so reject the null hypothesis and confirm the alternative
hypothesis which indicates that it explains the likelihood together when the stratification
regarding food (satis_food) and ratings regarding online order experience (online_exp) takes
together
[Show More]