Question

The following data represent a company's yearly sales volume and its advertising expenditure over a period of 8 years.             

Sales (Millions)	Advertising ($10,000)
15	32
16	33
18	35
17	34
16	36
19	37
19	39
24	42

To make sure the Excel regression package is installed.

Click “Tools”, à“Add-Ins” àchoose “Analysis Toolpak” and click “OK”.

To use the Excel regression package,                                                      

Click “Tools”, à“Data Analysis” and click “Regression”.

   f.    Use the F test to determine whether or not the regression model is significant at a= 0.05.

            g.   Use the t test to determine whether the slope of the regression model is significant at a= 0.05.

            h.         Develop a 99% confidence interval for the slope of the regression model

Answer 1