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.WeeklyGrossTelevisionAdvertising($1,000s)NewspaperAdvertising($1,000s)Revenue($1,000s)965.01.5902.02.0954.01.5922.52.5953.03.3943.52.3942.54.2943.02.5 (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. Letx, represent the amount of television advertising in $1,000s, x, 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--- vit isin part (a) andin 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 increasein television advertising with newspaper advertising held constant.O 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 thechange 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 expenditure. In part (b) it represents the change in revenue due to a one-unit increasein 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 inrevenue due to a one-unit increase in television advertising expenditure.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 thechange in revenue due to a one-unit increase in television advertising with newspaper advertising held constant.

Question

Accepted Answer

Solution
To find the equation of Regression line we will use regression analysis in excel.