Question

In: Statistics and Probability

The owner of a movie theater company would like to predict weekly gross revenue as a...

The owner of a movie theater company 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 1.5
90 2 2
95 4 1.5
93 2.5 2.5
95 3 3.3
94 3.5 2.2
94 2.5 4.1
94 3 2.5

(a)

Use α = 0.01 to test the hypotheses

H0: β1 = β2 = 0
Ha: β1 and/or β2 is not equal to zero

for the model

y = β0 + β1x1 + β2x2 + ε,

where

x1 = television advertising ($1,000s)
x2 = newspaper advertising ($1,000s).

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Reject H0. There is insufficient evidence to conclude that there is a significant relationship among the variables

Do not reject H0. There is sufficient evidence to conclude that there is a significant relationship among the variables.    

Do not reject H0. There is insufficient evidence to conclude that there is a significant relationship among the variables.

Reject H0. There is sufficient evidence to conclude that there is a significant relationship among the variables.

(b)

Use α = 0.05 to test the significance of

β1.

State the null and alternative hypotheses.

H0: β1 = 0
Ha: β1 > 0
H0: β1 = 0
Ha: β1 < 0

    

H0: β1 = 0
Ha: β1 ≠ 0
H0: β1 < 0
Ha: β1 = 0
H0: β1 ≠ 0
Ha: β1 = 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Reject H0. There is insufficient evidence to conclude that β1 is significant.

Reject H0. There is sufficient evidence to conclude that β1 is significant.  

Do not reject H0. There is insufficient evidence to conclude that β1 is significant.

Do not reject H0. There is sufficient evidence to conclude that β1 is significant.

Should x1 be dropped from the model? Yes or No?

(c)

Use α = 0.05 to test the significance of

β2.

State the null and alternative hypotheses.

H0: β2 < 0
Ha: β2 = 0
H0: β2 = 0
Ha: β2 < 0

    

H0: β2 = 0
Ha: β2 ≠ 0
H0: β2 ≠ 0
Ha: β2 = 0
H0: β2 = 0
Ha: β2 > 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Do not reject H0. There is insufficient evidence to conclude that β2 is significant.

Reject H0. There is sufficient evidence to conclude that β2 is significant.    

Reject H0. There is insufficient evidence to conclude that β2 is significant.

Do not reject H0. There is sufficient evidence to conclude that β2 is significant.

Should x2 be dropped from the model?Yes or No ?  

Solutions

Expert Solution

from excel: data-data analysis: regression:

df SS MS F Significance F
Regression 2 20.64804 10.32402 23.17958 0.002957
Residual 5 2.226964 0.445393
Total 7 22.875
Coefficients Standard Error t Stat P-value
Intercept 83.84478 1.661211 50.47208 0.0000
x1 2.164392 0.317971 6.806889 0.001042
x2 1.278048 0.344214 3.71295 0.013813

a)

value of the test statistic=23.18

p-value =0.003

Reject H0. There is sufficient evidence to conclude that there is a significant relationship among the variables.

b)

H0: β1 = 0Ha: β1 ≠ 0

value of the test statistic =6.81

p-value =0.001

Reject H0. There is sufficient evidence to conclude that β1 is significant

no ,x1 should not be dropped

c)

H0: β2 = 0
Ha: β2 ≠ 0

value of the test statistic. =3.71

p value =0.014

Reject H0. There is sufficient evidence to conclude that β2 is significant.   

no ,x 2 should not be dropped


Related Solutions

The owner of a movie theater company would like to predict weekly gross revenue as a...
The owner of a movie theater company 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 1.5 91 2 2 95 4 1.5 93 2.5 2.5 95 3 3.3 94 3.5 2.3 94 2.5 4.1 94 3 2.5 (a) Use α = 0.01 to test the hypotheses H0: β1 = β2 = 0 Ha: β1...
The owner of a movie theater company would like to predict weekly gross revenue as a...
The owner of a movie theater company 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 1.5 90 2 2 95 4 1.5 93 2.5 2.5 95 3 3.3 94 3.5 2.3 94 2.5 4.1 94 3 2.5 1. Use α = 0.01 to test the hypotheses H0: β1 = β2 = 0 Ha: β1...
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 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...
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...
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...
A statistical program is recommended. The owner of a movie theater company would like to predict...
A statistical program is recommended. The owner of a movie theater company 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 1.5 91 2 2 95 4 1.5 93 2.5 2.5 95 3 3.2 94 3.5 2.2 94 2.5 4.1 94 3 2.5 (a) Use α = 0.01 to test the hypotheses H0: β1 =...
A statistical program is recommended. The owner of a movie theater company would like to predict...
A statistical program is recommended. The owner of a movie theater company 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 1.5 91 2 2 95 4 1.5 93 2.5 2.5 95 3 3.2 94 3.5 2.3 94 2.5 4.2 94 3 2.5 (a) Use α = 0.01 to test the hypotheses H0: β1 =...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT