GF582: Statistical Methods for Decision Making Question p. 812 #17 Consider the following time series data a. Construct a tine series plot. What type of pattern exists in the data? b. Develop the linear trend equation for this time series. c. What is the forecast for t =6? Question p. 822 #29 Consider the following time series data. a) Construct a time series plot. What type of pattern exist in the data? b) Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. c) Compute the quarterly forecasts for next year. Question p. 834 #35 Consider the following time series data. a) Construct a time series plot. What type of pattern exist in the data? b) Show the four-quarter and centered moving average values for this time series. c) Compute seasonal indexes and adjust seasonal indexes for the four quarters. Reference Anderson, D.R., Sweeney, D.J., Williams, T.A., (2012). Modern Business Statistics with Microsoft Office Excel. (4th Ed.). South-Western Cengage Learning, Mason, OH