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
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.
Use = .01 to test the hypotheses for the model y = 0 + 11 + 22 + , where:
H0: 1 = 2 = 0
Ha: 1 and/or 2 0
Compute the F test statistic (to 2 decimals).
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).
Weekly Gross Revenue (1000s) | Television Advertising ($1000s) | Newspaper Advertising ($1000s) |
96 | 5 | 1.5 |
91 | 2 | 2 |
96 | 5 | 1.5 |
93 | 2.5 | 2.5 |
96 | 4 | 3.3 |
94 | 3.5 | 2.3 |
95 | 2.5 | 4.2 |
95 | 4 | 2.5 |
Predicted Revenue | ||
4.8 | 3.6 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started