Question

In: Statistics and Probability

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 your numerical values to two decimal places. Let x1 represent the amount of television advertising in $1,000s and y represent the weekly gross revenue in $1,000s.)

ŷ =

(b)

Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables. (Round your numerical values to two decimal places. Let x1 represent the amount of television advertising in $1,000s, x2 represent the amount of newspaper advertising in $1,000s, and y represent the weekly gross revenue in $1,000s.)

ŷ =

(c)

Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)?

---Select--- Yes No , it is  in part (a) and  in part (b).

Interpret the coefficient in each case.

In part (a) it represents the change in revenue due to a one-unit increase in television advertising expenditure. In part (b) it represents the change in revenue due to a one-unit increase in television advertising with newspaper advertising held constant.In part (a) it represents the change in revenue due to a one-unit increase in television advertising expenditure with newspaper advertising held constant. In part (b) it represents the change in revenue due to a one-unit increase in newspaper advertising with television advertising held constant.    In part (a) it represents the change in revenue due to a one-unit increase in newspaper advertising expenditure with television advertising held constant. In part (b) it represents the change in revenue due to a one-unit increase in television advertising with newspaper advertising held constant.In part (a) it represents the change in revenue due to a one-unit increase in television advertising expenditure. In part (b) it represents the change in revenue due to a one-unit increase in newspaper advertising with television advertising held constant.In part (a) it represents the change in revenue due to a one-unit increase in television advertising with newspaper advertising held constant. In part (b) it represents the change in revenue due to a one-unit increase in television advertising expenditure.

(d)

Predict weekly gross revenue (in dollars) for a week when $3,500 is spent on television advertising and $1,800 is spent on newspaper advertising. (Round your answer to the nearest cent.)

$

Solutions

Expert Solution

a) The estimated regression equation between the gross revenue with the amount of television advertising as the independent variable is given by ŷ = 88.64 + 1.61 x1 (where x1 represents the amount of television advertising in $1,000s and ŷ represents the predicted weekly gross revenue at $1,000s.)

b) The estimated regression equation with both television advertising and newspaper advertising as the independent variables is given by ŷ = 83.23 + 2.29x1 + 1.30x2 (Where x1 represents the amount of television advertising in $1,000s, x2 represents the amount of newspaper advertising in $1,000s, and  ŷ represents the predicted weekly gross revenue in $1,000s.)

c) No, the estimated regression equation coefficient for television advertising expenditures is not the same in part (a) and in part (b).

Option (i) is correct, which says -- In part (a) it represents the change in revenue due to a one-unit increase in television advertising expenditure. In part (b) it represents the change in revenue due to a one-unit increase in television advertising with newspaper advertising held constant.

d) Weekly gross revenue for a week when $3,500 is spent on television advertising and $1,800 is spent on newspaper advertising is obtained by putting x1=3500 and x2=1800 in part (b). It comes out to be $94 (rounded to the nearest thousand dollars).

(The calculations are obtained using R-software. Codes and Outputs are attached below).


Related Solutions

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...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Television Newspaper Radio Revenue Advertising Advertising Advertising ($1000s) ($1000s) ($1000s) ($1000s) 96 5 1.5 0.3 90 2 2 0.2 95 4 1.5 0.3 92 2.5 2.5 0.1 95 3 3.3 0.4 94 3.5 2.3 0.4 94 2.5 4.2 0.3 94 3 2.5 0.3 Is the estimated regression equation...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Television Newspaper Radio Revenue Advertising Advertising Advertising ($1000s) ($1000s) ($1000s) ($1000s) 96 5 1.5 0.3 90 2 2 0.2 95 4 1.5 0.3 92 2.5 2.5 0.1 95 3 3.3 0.4 94 3.5 2.3 0.4 94 2.5 4.2 0.3 94 3 2.5 0.3 Use the F test to...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Television Newspaper Radio Revenue Advertising Advertising Advertising ($1000s) ($1000s) ($1000s) ($1000s) 96 5 1.5 0.3 90 2 2 0.2 95 4 1.5 0.3 92 2.5 2.5 0.1 95 3 3.3 0.4 94 3.5 2.3 0.4 94 2.5 4.2 0.3 94 3 2.5 0.3 Develop an estimated regression equation...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as...
1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Television Newspaper Radio Revenue Advertising Advertising Advertising ($1000s) ($1000s) ($1000s) ($1000s) 96 5 1.5 0.3 90 2 2 0.2 95 4 1.5 0.3 92 2.5 2.5 0.1 95 3 3.3 0.4 94 3.5 2.3 0.4 94 2.5 4.2 0.3 94 3 2.5 0.3 Develop an estimated regression equation...
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...
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.
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 Television Newspaper Gross Revenue Advertising Advertising ($1,000s) ($1,000s) ($1,000s) 100 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 103 3.0 3.3 94 3.5 2.3 94 2.5 4.2 94 3.0 2.5 Develop an estimated regression equation with the amount of television advertising as the independent variable (to 1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT