The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross r
ID: 3313030 • Letter: T
Question
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Click on the webfile logo to reference the data WEB file Excel or Minitab users: The data set is available in file named Showtime. All data sets can be found on the premium online website. Weekly Gross Revenue ($1000s) 96 90 95 92 95 94 94 94 Television Advertising ($1000s) 5.0 2.0 4.0 2.5 3.0 3.5 2.5 3.0 Newspaper Advertising ($1000s) 1.5 2.0 1.5 2.5 3.3 2.3 4.2 2.5 a. Use .01 to test the hypotheses Ha: 1 and/or is not equal to zero for the model y = 0 + 1X1 + 2x2 + , where x,-television advertising ($1000s) x2-newspaper advertising ($1000s)Explanation / Answer
from above below is output:
a) F test statistic =28.38
b) t test statistic =7.53
c) t test statistic =4.06
Regression Statistics Multiple R 0.9587 R Square 0.9190 Adjusted R Square 0.8866 Standard Error 0.6426 Observations 8.0000 ANOVA df SS MS F Significance F Regression 2.0000 23.4354 11.7177 28.3778 0.0019 Residual 5.0000 2.0646 0.4129 Total 7.0000 25.5000 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 83.2301 1.5739 52.8825 0.0000 79.1843 87.2759 TV ads 2.2902 0.3041 7.5319 0.0007 1.5086 3.0718 newspaper Ads 1.3010 0.3207 4.0567 0.0098 0.4766 2.1254