MINDTAP ignment Exercise 17.15 (Moving Averages and Exponential Smoothing) Ten weeks of data on the Commodity Futures Index are 7.35, 7.40, 7.65, 7.567.00, 7.52, 7.52,7.70, 7.62 and 755, a. Construct a time series plot. A Index 7.9 17.8 17.7 7.6 7.5 7.4 7.3 7.2 7.1 10 Week B. Index 7.8 7.7 7.6 7.5 7.4 7.3 17.2 2.1 5 0 2 10 Week SAGE MINDTAP 7 Assignment 7.54 1.96 U.UULU 8 7.7 7.48 0.0465 9 7.62 7. 0.0085 g 10 7.55 7.55 0.0000 Total 0.1532 * c. Compute the exponential smoothing forecasts for a -0.5. Round your Time-uures values and Forecast valves to two decimal places ane (tror values ta tour decimal places. (Errorya Week Time-Series Value -0.3 Forecast 1 7.35 2 7.4 7.35 0.0025 3 7.55 7.37 0.0324 4 7.56 7.42 0.0195 7.6 7.46 0.0196 7.52 7.50 0.0003 7.52 7.51 0.0001 8 7.7 0.0361 7.51 7.62 7.57 0.0027 7.55 7.58 10 0.0011 0.11473 Total d. Which exponential smoothing content provide more accurate forecasts based on MSE (to 4 decimals? MSE (0.25 0.0171 HSE (03) 0.0137 Forecast week 11 e 2 decimals) 7.57 de Veedback Partially Correct SAGE MINDTAP 7 Assignment 7.54 1.96 U.UULU 8 7.7 7.48 0.0465 9 7.62 7. 0.0085 g 10 7.55 7.55 0.0000 Total 0.1532 * c. Compute the exponential smoothing forecasts for a -0.5. Round your Time-uures values and Forecast valves to two decimal places ane (tror values ta tour decimal places. (Errorya Week Time-Series Value -0.3 Forecast 1 7.35 2 7.4 7.35 0.0025 3 7.55 7.37 0.0324 4 7.56 7.42 0.0195 7.6 7.46 0.0196 7.52 7.50 0.0003 7.52 7.51 0.0001 8 7.7 0.0361 7.51 7.62 7.57 0.0027 7.55 7.58 10 0.0011 0.11473 Total d. Which exponential smoothing content provide more accurate forecasts based on MSE (to 4 decimals? MSE (0.25 0.0171 HSE (03) 0.0137 Forecast week 11 e 2 decimals) 7.57 de Veedback Partially Correct Chapter 17 Assignment IT C Index FO 2.0 17. 7.6 75 24 17.3 5.2 7.1 4 5 92 2 10 Week > time series plet A # What type of pattern exists in the data? horizontal b. Compute the exponential mething forecasts for = 0.2. Round your Time-series values and Forecast values to two decimal places and (Error values to four decimal places Week Time-Series Value a=0.2 Forecast (Error 1 7.35 7.4 7.35 0.0025 2 UL 7.55 7.36 0.0361 3 7.56 7.4 0.0256 4 7.6 7.43 0.0288 5 7.52 7.46 0.0031 7.52 7.48 0.0020 7.7 7.40 0.0465 7.50 26 g 0.0006 9 7.55 7.55 0.0000 10 Total Compute the exponential smoothing forecast for 0.3. Round your the series values and Forecast values to two decimal places and Error us to four deomapaces 0.15323 MINDTAP ignment Exercise 17.15 (Moving Averages and Exponential Smoothing) Ten weeks of data on the Commodity Futures Index are 7.35, 7.40, 7.65, 7.567.00, 7.52, 7.52,7.70, 7.62 and 755, a. Construct a time series plot. A Index 7.9 17.8 17.7 7.6 7.5 7.4 7.3 7.2 7.1 10 Week B. Index 7.8 7.7 7.6 7.5 7.4 7.3 17.2 2.1 5 0 2 10 Week SAGE MINDTAP 7 Assignment 7.54 1.96 U.UULU 8 7.7 7.48 0.0465 9 7.62 7. 0.0085 g 10 7.55 7.55 0.0000 Total 0.1532 * c. Compute the exponential smoothing forecasts for a -0.5. Round your Time-uures values and Forecast valves to two decimal places ane (tror values ta tour decimal places. (Errorya Week Time-Series Value -0.3 Forecast 1 7.35 2 7.4 7.35 0.0025 3 7.55 7.37 0.0324 4 7.56 7.42 0.0195 7.6 7.46 0.0196 7.52 7.50 0.0003 7.52 7.51 0.0001 8 7.7 0.0361 7.51 7.62 7.57 0.0027 7.55 7.58 10 0.0011 0.11473 Total d. Which exponential smoothing content provide more accurate forecasts based on MSE (to 4 decimals? MSE (0.25 0.0171 HSE (03) 0.0137 Forecast week 11 e 2 decimals) 7.57 de Veedback Partially Correct SAGE MINDTAP 7 Assignment 7.54 1.96 U.UULU 8 7.7 7.48 0.0465 9 7.62 7. 0.0085 g 10 7.55 7.55 0.0000 Total 0.1532 * c. Compute the exponential smoothing forecasts for a -0.5. Round your Time-uures values and Forecast valves to two decimal places ane (tror values ta tour decimal places. (Errorya Week Time-Series Value -0.3 Forecast 1 7.35 2 7.4 7.35 0.0025 3 7.55 7.37 0.0324 4 7.56 7.42 0.0195 7.6 7.46 0.0196 7.52 7.50 0.0003 7.52 7.51 0.0001 8 7.7 0.0361 7.51 7.62 7.57 0.0027 7.55 7.58 10 0.0011 0.11473 Total d. Which exponential smoothing content provide more accurate forecasts based on MSE (to 4 decimals? MSE (0.25 0.0171 HSE (03) 0.0137 Forecast week 11 e 2 decimals) 7.57 de Veedback Partially Correct Chapter 17 Assignment IT C Index FO 2.0 17. 7.6 75 24 17.3 5.2 7.1 4 5 92 2 10 Week > time series plet A # What type of pattern exists in the data? horizontal b. Compute the exponential mething forecasts for = 0.2. Round your Time-series values and Forecast values to two decimal places and (Error values to four decimal places Week Time-Series Value a=0.2 Forecast (Error 1 7.35 7.4 7.35 0.0025 2 UL 7.55 7.36 0.0361 3 7.56 7.4 0.0256 4 7.6 7.43 0.0288 5 7.52 7.46 0.0031 7.52 7.48 0.0020 7.7 7.40 0.0465 7.50 26 g 0.0006 9 7.55 7.55 0.0000 10 Total Compute the exponential smoothing forecast for 0.3. Round your the series values and Forecast values to two decimal places and Error us to four deomapaces 0.15323