2) Consider the following time series data. (2 marks) Month Value 1 24 2 13 3 20 4 12 5 19 6 23 7 15 a. Using excel, construct a time series plot. What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a Forecast for week B. C. Use a =0.2 to compute the exponential amoothing values for the time series. Compute MSE and a forecast for week 8. d. Compare the three-week moving average forecast with the exponential smoothing forecast using a 0.2. Which appears to provide the better forecast based on MSE