he 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. a. Use ? = .01 to test the hypotheses for the model y = ?0 + ?1?1 + ?2?2 + ?, where: H0 : ?1 = ?2 = 0 Ha : ?1 and/or ?2 ≠0 Compute the F test statistic (to 2 decimals). b. Use ? = .05 to test the significance of ?1. Compute the t test statistic (to 2 decimals). c. Use ? = .05 to test the significance of ?2. Compute the t test statistic (to 2 decimals). d. The owner plans to spend (in $1000s) $4.5 on television advertising and $3.6 on newspaper advertising. What is the expected revenue (in $1000s) for this advertising combination (to the nearest whole number)?
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a
a. Use ? = .01 to test the hypotheses for the model y = ?0 + ?1?1 + ?2?2 + ?, where:
H0 : ?1 = ?2 = 0
Ha : ?1 and/or ?2 ≠0
Compute the F test statistic (to 2 decimals).
b. Use ? = .05 to test the significance of ?1. Compute the t test statistic (to 2 decimals).
c. Use ? = .05 to test the significance of ?2. Compute the t test statistic (to 2 decimals).
d. The owner plans to spend (in $1000s) $4.5 on television advertising and $3.6 on newspaper advertising. What is the expected revenue (in $1000s) for this advertising combination (to the nearest whole number)?
Step by step
Solved in 6 steps with 43 images