Edit question

Complete the exercise copy and paste the output (cells A1 through i30) to your MS Word file for this assignment. Use the output to answer the following questions:

1. What is the estimated regression equation?
2. Is the slope statistically significant (not zero) at 0.05 level? What is the p-value?
3. What percentage of variability in quarterly sales can be explained by the student population?

Info you need

The ANOVA table is printed below the heading Analysis of Variance. The label Error is used for the error source of variation. Note that DF is an abbreviation for degrees of freedom and that MSR is given in the Regression row under the column Adj MS as 14,200 and MSE is given in the Error row under Adj MS as 191.2. The ratio of these two values provides the F value of 74.25 and the corresponding p-value of .000. Because the p-value is zero (to three decimal places), the relationship between Sales and Population is judged statistically significant.

Under the heading Model Summary, the standard error of the estimate, s=13.8293, is given as well as information about the goodness of fit. Note that R-sq=90.27% is the coefficient of determination expressed as a percentage. The value R-Sq(adj)=89.06% is discussed in Chapter 15.

A table is printed that shows the values of the coefficients b0 and b1, the standard deviation of each coefficient, the t value obtained by dividing each coefficient value by its standard deviation, and the p-value associated with the t test. This appears under the heading Coefficients. Because the p-value is zero (to three decimal places), the sample results indicate that the null hypothesis (H0:1=0) should be rejected. Alternatively, we could compare 8.62 (located in the T-Value column) to the appropriate critical value. This procedure for the t test was described in Section 14.5.

Under the heading Regression Equation, the estimated regression equation is given: Sales=60.00+5.000 Population.

The 95% confidence interval estimate of the expected sales and the 95% prediction interval estimate of sales for an individual restaurant located near a campus with 10,000 students are printed below the ANOVA table. The confidence interval is (98.5830, 121.4417) and the prediction interval is (76.1275, 143.873) as we showed in Section 14.6.

Hint on what it should start off looking like

Analysis of Variance DF Adj MS 14200.0 F-Value 74.25 P-Value .000 Source Regression Error Total Adj SS 14200.0 1530.0 15730.0 1 8 9 - ANOVA table 191.2 Model Summary S R-sq 13.8293 90.27% R-sq(adj) 89.06% Coefficients Term Constant Population Coef 60.00 5.000 SE Coef 9.23 .580 T-Value 6.50 8.62 P-Value .000 .000 Regression Equation Sales = 60.00 + 5.000 Population -Estimated Regression Equation Prediction for Sales Variable Population Setting 10 Fit SE Fit 95% CI 95% PI 110 4.95099 (98.5830, 121.417) (76.1275, 143.873) Interval Estimates Output for the Armand's Pizza Parlors problem E G H B Population Sales 58 105 88 118 117 Or 1 Restaurant 2 3 4 5 6 7 8 9 10 11 10 12 13 14 15 16 12 16 20 20 22 26 olalalala OLOS 137 157 169 149 202