Question: Please include how to do multiple regression in excel with the data analysis tool pack and which variables to use. Dixie Showtime Movie Theaters, Inc.,

Please include how to do multiple regression in

Please include how to do multiple regression in excel with the data analysis tool pack and which variables to use.

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. Weekly Gross Revenue Television Advertising Newspaper Advertising Market ($100s) ($100s) ($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 3.5 2.3 New Orleans 237.8 5.0 8.4 Baton Rouge 219.6 6.9 5.8 (a) Use the data to develop an estimated regression equation 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) +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!