The file P16_37.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters’ method to forecast...

The file P16_37.xlsx contains monthly retail sales of U.S. liquor stores.


a. Is seasonality present in these data? If so, characterize the seasonality pattern.


b. Use Winters’ method to forecast this series with smoothing constants

=
= 0.1 and

= 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?