Answer Happy

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 are
entered into the Microsoft Excel Online file below. Use the XLMiner
Analysis ToolPak to perform your regression analysis in the
designated areas of the spreadsheet.
Develop an estimated regression equation with the amount of
television advertising as the independent variable (to 2
decimals).
Revenue = _______ + _______ TVAdv
Develop an estimated regression equation with both television
advertising and newspaper advertising as the independent variables
(to 2 decimals).
Revenue = ________ + ________ TVAdv + _______
NewsAdv
Is the estimated regression equation coefficient for television
advertising expenditures the same in part (a) and in part (b)?
Yes, the coefficients are the same
No, the coefficients are not the same
Predict weekly gross revenue for a week when $5.4 thousand is
spent on television advertising and $3.5 thousand is spent on
newspaper advertising (to 2 decimals)?
$____________ in thousands