2. Using the TGT Quarterly Sales (Target Corp.) data: a) Fit the sales data using the Holt-Winters Additive Seasonal model, and opti- mize the smoothing constants with the Solver. b) Use the Forecast Sheet button to create a forecast worksheet. (Or you can also do as we did in class using the Forecast.ETS. Eorecast.ETS.stat and Fore. cast.ETS.confint functions.) LD Tell me A = % Clipboard Font Duty Conditional Formatting Format as Table Cell Styles Alignment Number C8 1 G H 00V x ABC Date Sales 39933 14833 40025 15067 40117 15276 4020920181 40298 15593 40390 15532 40482 15605 40574 20661 40663 15935 40755 16240 40847 16402 40939 21288 41029 16867 41121 16779 41213 16929 41305 22726 41394 16706 41486 17117 41578 17258 41670 21515 41759 17050 41851 17406 41943 17732 42035 21751 42124 17119 42216 17427 42308 17613 42400 21626 42490 16196 42582 16169 42674 16441 2. Using the TGT Quarterly Sales (Target Corp.) data: a) Fit the sales data using the Holt-Winters Additive Seasonal model, and opti- mize the smoothing constants with the Solver. b) Use the Forecast Sheet button to create a forecast worksheet. (Or you can also do as we did in class using the Forecast.ETS. Eorecast.ETS.stat and Fore. cast.ETS.confint functions.) LD Tell me A = % Clipboard Font Duty Conditional Formatting Format as Table Cell Styles Alignment Number C8 1 G H 00V x ABC Date Sales 39933 14833 40025 15067 40117 15276 4020920181 40298 15593 40390 15532 40482 15605 40574 20661 40663 15935 40755 16240 40847 16402 40939 21288 41029 16867 41121 16779 41213 16929 41305 22726 41394 16706 41486 17117 41578 17258 41670 21515 41759 17050 41851 17406 41943 17732 42035 21751 42124 17119 42216 17427 42308 17613 42400 21626 42490 16196 42582 16169 42674 16441