Question

In: Math

Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in...

Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow.

Market Weekly Gross Revenue
($100s)
Television Advertising
($100s)
Newspaper Advertising
($100s)
  Mobile 101.3 5 1.5
  Shreveport 51.9 3 3
  Jackson 74.8 4 1.5
  Birmingham 126.2 4.3 4.3
  Little Rock 137.8 3.6 4
  Biloxi 101.4 3.5 2.3
  New Orleans 237.8 5 8.4
  Baton Rouge 219.6 6.9 5.8

(a) Use the data to develop an estimated regression with the amount of television advertising as the independent variable. Let x represent the amount of television advertising. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)

(b) How much of the variation in the sample values of weekly gross revenue does the model in part (a) explain? If required, round your answer to two decimal places.

(c) Use the data to develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables. Let x1 represent the amount of television advertising. Let x2 represent the amount of newspaper advertising. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)

(d) How much of the variation in the sample values of weekly gross revenue does the model in part (c) explain? If required, round your answer to two decimal places. %

Solutions

Expert Solution

Using Minitab software, (Stat -> Regression -> Regression -> Fit Regression Model), we get the following output :

a) Using the amount of television advertising as the independent variable, we get the regression equation as -

Weekly Gross Revenue = -45.4 + 40.1 Television Advertising

Since coefficient of determination R2 = 55.52%, so we can say

55.62% variation in the sample values of weekly gross revenue can be explained by the regression equation.

b) Using both television advertising and newspaper advertising as the independent variables. we get the regression equation as -

Weekly Gross Revenue = -42.6 + 22.40 Television Advertising + 19.50 Newspaper Advertising

Since coefficient of determination R2 = 93.22%, so we can say

93.22% variation in the sample values of weekly gross revenue can be explained by the regression equation.


Related Solutions

Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in...
Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow. Market Weekly Gross Revenue ($100s) Television Advertising ($100s) Newspaper Advertising ($100s) Mobile 103.5 4.9 1.7 Shreveport 51.6 3.3 3 Jackson 75.8 4 1.5 Birmingham 127.8 4.2 4 Little Rock 134.8 3.2 4.3 Biloxi 101.4...
Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in...
Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow.   Market Weekly Gross Revenue ($100s) Television Advertising ($100s) Newspaper Advertising ($100s)   Mobile 101.3 4.9 1.4   Shreveport 52.9 3.1 3.2   Jackson 75.8 4.2 1.5   Birmingham 127.2 4.5 4.3   Little Rock 137.8 3.6 4.0   Biloxi 102.4...
Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in...
Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow.   Market Weekly Gross Revenue ($100s) Television Advertising ($100s) Newspaper Advertising ($100s)   Mobile 102.3 5.0 1.6   Shreveport 51.9 3.0 3.2   Jackson 75.5 4.0 1.5   Birmingham 127.2 4.4 4.0   Little Rock 137.8 3.6 4.3   Biloxi 101.4...
Problem 7-9 Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several...
Problem 7-9 Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow.   Market Weekly Gross Revenue ($100s) Television Advertising ($100s) Newspaper Advertising ($100s)   Mobile 101.3 4.9 1.4   Shreveport 52.9 3.1 3.2   Jackson 75.8 4.2 1.5   Birmingham 127.2 4.5 4.3   Little Rock 137.8 3.6 4...
Problem 7-9 Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several...
Problem 7-9 Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow. Market Weekly Gross Revenue ($100s) Television Advertising ($100s) Newspaper Advertising ($100s) Mobile 102.5 5.1 1.6 Shreveport 52.7 3.2 3 Jackson 75.8 4 1.5 Birmingham 127.8 4.3 4 Little Rock 137.8 3.5 4.3...
As a manager of a chain of movie theaters that are monopolies in their respective markets,...
As a manager of a chain of movie theaters that are monopolies in their respective markets, you have noticed much higher demand on weekends than during the week. You therefore conducted a study that has revealed two different demand curves at your movie theaters. On weekends, the inverse demand function is P = 20 – 0.001Q; on weekdays, it is P = 15 – 0.002Q. You acquire legal rights from movie producers to show their films at a cost of...
As a manager of a chain of movie theaters that are monopolies in their respective markets,...
As a manager of a chain of movie theaters that are monopolies in their respective markets, you have noticed much higher demand on weekends than during the week. You therefore conducted a study that has revealed two different demand curves at your movie theaters. On weekends, the inverse demand function is P = 20 – 0.001Q; on weekdays, it is P = 15 – 0.002Q. You acquire legal rights from movie producers to show their films at a cost of...
As a manager of a chain of movie theaters that are monopolies in their respective markets,...
As a manager of a chain of movie theaters that are monopolies in their respective markets, you have noticed much higher demand on weekends than during the week. You therefore conducted a study that has revealed two different demand curves at your movie theaters. On weekends, the inverse demand function is ? = 20 − 0.001? ; On weekdays, it is ? = 15 − 0.002? . You acquire legal rights from movie producers to show their films at a...
As a manager of a chain of movie theaters that are monopolies in their respective markets,...
As a manager of a chain of movie theaters that are monopolies in their respective markets, you have noticed much higher demand on weekends than during the week. You therefore conducted a study that has revealed two different demand curves at your movie theaters. On weekends, the inverse demand function is P = 20 - 0.001Q ; On weekdays, it is P = 15 - 0.002Q . You acquire legal rights from movie producers to show their films at a...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT