Pete Zaria would like to study the relationship between pizza sales and advertis

Question

Pete Zaria would like to study the relationship between pizza sales and advertising, The following is the result of a regression analysis Pete conducted for monthly sales of pizza and advertising (both in thousands of dollars) The exercise involves filling in the values for the shaded cells bellow SUMMARY OUTPUT Regression Statistics 0.63699 Multiple R R Square 0.39762 Adjusted R Square Standard Error Observations ANOVA Significance F SS MS Regression 73 25.361 Residual Total 74 3115.482 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 66.6742 0.0000 63.4389 69.9095 1.6233 41.0721 Intercept 5.2282 ADVERT

Explanation / Answer

From ANOVA table

SS Residual= SSE=25.361*73 =1851.353

SS regression=SSR=SST-SSE=3115.482-1851.353 =1264.129

MS Regresion = 1264.129/1=1264.129

F=MSR/MSE=1264.129/25.361=49.85

Significance F=p-value=P(F(1,73)>49.85)= 8.05809E-10

From Regression statistics table

R-sqaure=SSR/SST=1264.129/3115.482=0.4058

Standard error =sqrt(MSE)=sqrt(25.361)= 5.04

Observations = df(SST)+1=74+1=75

Q-28

Standard error of slope=

To answer this we need to know standard deviation of advert which is not given. So unable to calculate it

Q-29

Error df=73

So, critical-t at 5% level =1.993

Q-30

This depends on 28 for which we are not given information

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.