# Question: The file P11 46 xlsx contains data on a motel chain s revenue

The file P11_46.xlsx contains data on a motel chain’s revenue and advertising. Note that column C is simply column B “pushed down” a row.

a. If the goal is to get the best-fitting regression equation for Revenue, which of the Advertising variables should be used? Or is it better to use both?

b. Using the best-fitting equation from part a, make predictions for the motel chain’s revenues during the next four quarters. Assume that advertising during each of the next four quarters is $50,000.

c. Does autocorrelation of the residuals from the best-fitting equation appear to be a problem?

a. If the goal is to get the best-fitting regression equation for Revenue, which of the Advertising variables should be used? Or is it better to use both?

b. Using the best-fitting equation from part a, make predictions for the motel chain’s revenues during the next four quarters. Assume that advertising during each of the next four quarters is $50,000.

c. Does autocorrelation of the residuals from the best-fitting equation appear to be a problem?

**View Solution:**## Answer to relevant Questions

The file P11_47.xlsx contains the quarterly revenues (in millions of dollars) of a utility company for a seven-year period. The goal is to use these data to build a multiple regression model that can be used to forecast ...A company gives prospective managers four separate tests for judging their potential. For a sample of 30 managers, the test scores and the subsequent job effectiveness ratings (Rating) given one year later are listed in the ...The Keynesian school of macroeconomics believes that increased government spending leads to increased growth. The file P11_59.xlsx contains the following annual data:• Government spending as percentage of GDP (gross ...The Pierce Company manufactures drill bits. The production of the drill bits occurs in lots of 1000 units. Due to the intense competition in the industry and the correspondingly low prices, Pierce has undertaken a study of ...Do the preceding problem, but now use the football data in the file P03_66.xlsx. a. Given the explanation of SRS, it makes sense to use multiple regression, with PTS and O_PTS as the explanatory variables, to predict SRS. Do ...Post your question