Question: The file S02 55 xlsx contains monthly retail sales of beer wine

The file S02_55.xlsx contains monthly retail sales of beer, wine, and liquor at U.S. liquor stores.
a. Is seasonality present in these data? If so, characterize the seasonality pattern and then de-seasonalize this time series using the ratio-to-moving-average method.
b. If you decided to de-seasonalize this time series in part a, forecast the de-seasonalized data for each month of the next year using the moving average method with an appropriate span.
c. Does Holt’s exponential smoothing method, with optimal smoothing constants, outperform the moving average method employed in part b? Demonstrate why or why not.

View Solution:

Sale on SolutionInn
  • CreatedApril 01, 2015
  • Files Included
Post your question