The file P12_62.xlsx contains data on a motel chain’s revenue and advertising.

Question:

The file P12_62.xlsx contains data on a motel chain’s revenue and advertising.

a. Use these data and multiple regression to make predictions of the motel chain’s revenues during the next four quarters. Assume that advertising during each of the next four quarters is $50,000. (Hint: Try using advertising, lagged by one quarter, as an explanatory variable.)

b. Use simple exponential smoothing to make predictions for the motel chain’s revenues during the next four quarters.

c. Use Holt’s method to make forecasts for the motel chain’s revenues during the next four quarters.

d. Use Winters’ method to determine predictions for the motel chain’s revenues during the next four quarters.

e. Which of these forecasting methods would you expect to be the most accurate for these data?

Answer:

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.