Question

In: Statistics and Probability

The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a...

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. Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 97 5 1.5 90 2 3 96 4 2.5 92 2.5 2.5 95 3 3.3 95 3.5 2.3 95 2.5 4.2 95 3 3.5 Use = .01 to test the hypotheses for the model y = 0 + 1 x 1 + 2 x 2 + , where Compute the F test statistic (to 2 decimals). Use F table. What is the p-value? What is your conclusion? Use = .05 to test the significance of 1. Compute the t test statistic (to 2 decimals). Use t table. What is the p-value? What is your conclusion? Should x 1 be dropped from the model? Use = .05 to test the significance of 2. Compute the t test statistic (to 2 decimals). Use t table. What is the p-value? What is your conclusion? Should x 2 be dropped from the model? Hide Feedback Partially Correct Check My Work Icon Key Question 2 of 2 Exercise 15.23 (Self-Test) Algorithmic

Solutions

Expert Solution

Using Minitab software, (Stat -> Regression -> Regression -> Fit Regression model), we get the following output :

To test the overall significance of the model,

The value of test statistic F = 42.89

P-value = 0.001

Since P-value < 0.01, so we reject the null hypothesis at 5% level of significance and we can conclude that the overall model is significant.

From the above table, it can be seen that both predictors x1 and x2 are significant, there is no need to drop any of the variables.


Related Solutions

The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a...
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 has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Weekly Gross Revenue ($1000s) Television Advertising ($1000s) Newspaper Advertising($1000s) 97 6 1.5 91 2 2 96 5 1.5 93 2.5 2.5 95 4 3.3 94 3.5 2.3 95...
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a...
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. Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 97 5 1.5 90 2 3    96 4 2.5 93    3.5 2.5 96 3 4.3 94    3.5 2.3 95    2.5 5.2 95 3 3.5 a. Use  to test the hypotheses and/or  is not equal to zero for the model , where television advertising...
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a...
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. Weekly Gross Revenue ($1,000s) Television Advertising ($1,000s) Newspaper Advertising ($1,000s) 96 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 95 3.0 3.3 94 3.5 2.3 94 2.5 4.2 94 3.0 2.5 (a) Develop an estimated regression equation with the amount of television advertising as the independent variable. (Round...
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a...
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. Weekly Gross Revenue ($1,000s) Television Advertising ($1,000s) Newspaper Advertising ($1,000s) 96 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 95 3.0 3.3 94 3.5 2.3 94 2.5 4.2 94 3.0 2.5 (a) Develop an estimated regression equation with the amount of television advertising as the independent variable. (Round...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Television Newspaper Radio Revenue Advertising Advertising Advertising ($1000s) ($1000s) ($1000s) ($1000s) 96 5 1.5 0.3 90 2 2 0.2 95 4 1.5 0.3 92 2.5 2.5 0.1 95 3 3.3 0.4 94 3.5 2.3 0.4 94 2.5 4.2 0.3 94 3 2.5 0.3 Is the estimated regression equation...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Television Newspaper Radio Revenue Advertising Advertising Advertising ($1000s) ($1000s) ($1000s) ($1000s) 96 5 1.5 0.3 90 2 2 0.2 95 4 1.5 0.3 92 2.5 2.5 0.1 95 3 3.3 0.4 94 3.5 2.3 0.4 94 2.5 4.2 0.3 94 3 2.5 0.3 Use the F test to...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Television Newspaper Radio Revenue Advertising Advertising Advertising ($1000s) ($1000s) ($1000s) ($1000s) 96 5 1.5 0.3 90 2 2 0.2 95 4 1.5 0.3 92 2.5 2.5 0.1 95 3 3.3 0.4 94 3.5 2.3 0.4 94 2.5 4.2 0.3 94 3 2.5 0.3 Develop an estimated regression equation...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Television Newspaper Radio Revenue Advertising Advertising Advertising ($1000s) ($1000s) ($1000s) ($1000s) 96 5 1.5 0.3 90 2 2 0.2 95 4 1.5 0.3 92 2.5 2.5 0.1 95 3 3.3 0.4 94 3.5 2.3 0.4 94 2.5 4.2 0.3 94 3 2.5 0.3 Develop an estimated regression equation...
The owner of Showtime Movie Theaters would like to estimate weekly gross revenue as a function...
The owner of Showtime Movie Theaters would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are as below: Week Weekly gross revenue ($1000s) TV Advertising ($1000s) Newspaper Advertising ($1000s) 1 96 5.0 1.5 2 90 2.0 2.0 3 95 4.0 1.5 4 92 2.5 2.5 5 95 3.0 3.3 6 94 3.5 2.3 7 94 2.5 4.2 8 94 3.0 2.5 Following are the regression results for the...
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.
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. Weekly Television Newspaper Gross Revenue Advertising Advertising ($1,000s) ($1,000s) ($1,000s) 100 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 103 3.0 3.3 94 3.5 2.3 94 2.5 4.2 94 3.0 2.5 Develop an estimated regression equation with the amount of television advertising as the independent variable (to 1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT