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)?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
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 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)?

 

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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 6 steps with 43 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman