Question

Regression Analysis r^2 0.762 n 7 R 0.873 k 1 Std. Error 11.547 Dep. Var. Sales ANOVA Source SS df MS F p-value Regression 2,133.3333 1 2,133.3333 16.00 0.0103 Residual 666.6667 5 133.3333 Total 2,800.0000 6 Regression output Confidence interval Variables Coefficients std. error t(df = 5) p-value 95% lower 95% upper Intercept 63.3333 7.9682 7.948 0.0005 42.8505 83.8162 Advertising 6.6667 1.6667 4.000 0.0103 40) A local grocery store wants to predict its daily sales in dollars. The manager believes that the amount of newspaper advertising significantly affects sales. He randomly selects 7 days of data consisting of daily grocery store sales (in thousands of dollars) and advertising expenditures (in thousands of dollars). The Excel/MegaStat output given above summarizes the results of the regression model. 40) At a significance level of .05, test the significance of the slope and state your conclusion. 41) What percent of the change in the dependent variable can be explained by the independent variables? 42) What is the correlation?

          Regression Analysis
r^2 0.762 n 7
R 0.873 k 1
Std. Error 11.547 Dep. Var. Sales
ANOVA
Source SS df MS F p-value
Regression 2,133.3333 1 2,133.3333 16.00 0.0103
Residual 666.6667 5 133.3333
Total 2,800.0000 6
Regression output
Confidence interval
Variables Coefficients std. error t(df = 5) p-value 95% lower 95% upper
Intercept 63.3333 7.9682 7.948 0.0005 42.8505 83.8162
Advertising 6.6667 1.6667 4.000 0.0103
40) A local grocery store wants to predict its daily sales in dollars. The manager believes that the amount of newspaper advertising significantly affects sales. He randomly selects 7 days of data consisting of daily grocery store sales (in thousands of dollars) and advertising expenditures (in thousands of dollars). The Excel/MegaStat output given above summarizes the results of the regression model.
40) At a significance level of .05, test the significance of the slope and state your conclusion.
41) What percent of the change in the dependent variable can be explained by the independent variables?
42) What is the correlation?

Regression Analysis
r^2 0.762 n 7
R 0.873 k 1
Std. Error 11.547 Dep. Var. Sales
ANOVA
Source SS df MS F p-value
Regression 2,133.3333 1 2,133.3333 16.00 0.0103
Residual 666.6667 5 133.3333
Total 2,800.0000 6
Regression output
Confidence interval
Variables Coefficients std. error t(df = 5) p-value 95% lower 95% upper
Intercept 63.3333 7.9682 7.948 0.0005 42.8505 83.8162
Advertising 6.6667 1.6667 4.000 0.0103
40) A local grocery store wants to predict its daily sales in dollars. The manager believes that the amount of newspaper advertising significantly affects sales. He randomly selects 7 days of data consisting of daily grocery store sales (in thousands of dollars) and advertising expenditures (in thousands of dollars). The Excel/MegaStat output given above summarizes the results of the regression model.
40) At a significance level of .05, test the significance of the slope and state your conclusion.
41) What percent of the change in the dependent variable can be explained by the independent variables?
42) What is the correlation?

Added by Julie Q.

Question

Please give Ace some feedback