Below is a regression using X = average price, Y = units sold, n = 20 stores.
(a) Write the fitted regression equation.
(b) Write the formula for each t statistic and verify the t statistics shown below.
(c) State the degrees of freedom for the t tests and find the two-tail critical value for t by using Appendix D.
(d) Use Excel's function = T.DIST.2T (t, d.f.) to verify the p-value shown for each t statistic (slope, intercept).
(e) Verify that F = t2 for the slope.
(f) In your own words, describe the t of this regression.

Transcribed Image Text:

0.200 Std. Error 26.128 20 ANOVA table Source Regression df MS p-value 3,080.89 12,288.31 15,369.20 13,080.89 682.68 4.51 0478 Residual 18 Total 19 Regression output variables coefficients std. error t(df-18) p-value 95% lower 95% upper Intercept 6149300 51.2343 12.002 00 507.2908 722.5692 confidence interval Slope 109.1120 51.3623 2.124 0478-217.0202 -1.2038