# Question: Below is a regression using X average price Y

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.

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

**View Solution:**## Answer to relevant Questions

Moviegoer Snack Spending (n = 10) (a) Use Excel's Data Analysis > Regression (or MegaStat or MINITAB) to obtain regression estimates. (b) Interpret the 95 percent confidence interval for the slope. Does it contain zero? (c) ...Refer to the Revenue and Pro t data set below. Data are in billions of dollars. (a) Use Mega-Stat or MINITAB to find confidence and prediction intervals for Y using the following set of x values: 1.8, 15, and 30. (b) Report ...Moviegoer Snack Spending (n = 10) (a) Make a scatter plot of the data. What does it suggest about the correlation between X and Y? (b) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. (c) Use Excel ...(a) Make a histogram (or normal probability plot) of the residuals and discuss its appearance. (b) Do you see evidence that your regression may violate the assumption of normal errors? In the following regression, X = total assets ($ billions), Y = total revenue ($ billions), and n = 64 large banks. (a) Write the fitted regression equation. (b) State the degrees of freedom for a two-tailed test for zero ...Post your question