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 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

Question

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  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

SolutionInn · Accepted Answer

a y 614930 10911 x b Intercept t calc 614930512343 12002 Slope t calc 109112513623 212...

Question: Below is a regression using X = average price, Y = units sold, n = 20 stores. (a) Write the fitted regression equation. (b) Write

Step by Step Solution

Document Format (1 attachment)

485-M-S-L-R (3526).docx

Students Have Also Explored These Related Statistics Questions!