Case: "GoodBelly using stats to justify marketing expense"
Given data: please see the picture attached.
Question: Is the in-store demo an effective promotion? Does the increase in sales adequately cover the cost of running the demo? Why?
SUMMARY OUTPUT-FINAL OUTPUT
able[[Regression Statistics],[Multiple R,0.81992],[R Square,0.67227],[Adjusted R Square,0.67084],[Standard Error,63.68280],[Observations,1386]]
ANOVA
able[[,df,SS,MS,F,Significance F]]
Regression Residual Total
Coefficients Standard Error t Stat p-value Lower 95% Upper 95%
Intercept 18.635 0.000 263.220 325.158
Average Retail Price -7.253 0.000 -36.347 20.871
Sales Rep 20.035 0.000 69.417 84.486
Endcap 33.831 0.000 287.277 322.643
Demo 15.033 0.000 96.742 125.779
Demo1-3 15.060 0.000 64.068 83.258
Demo4-5 10.353 0.000 54.872 80.528