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)?
![Excel template - Saved
5
E1
1234SGEN
5
6
7
8
9
File
10
11
13
14
Home
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
A
X ✓ fx
B
Television
Weekly Gross
Advertising
Revenue (1000s)
($1000s)
97
6
91
2
96
5
711
92
2.5
95
4
94
3.5
95
2.5
95
4
Insert
Predicted Revenue
Arial
Draw Page Layout
✓10
4.5
C
Newspaper
Advertising
B
($1000s)
1.5
2
1.5
2.5
3.3
2.3
4.2
2.5
3.6
Formulas
D
E
Search (Option + Q)
Data
A
F
Review
G
View
V
ab
H
Help
|
General
J
K
←.0
.00
L
.00
→.0
M
B](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbc3ad949-79b2-4a66-83f9-922936cf2321%2F1d328680-505a-445f-a255-1c875d89dea6%2Fa9f86jc_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 6 steps with 43 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)