AutoSave OFF 02-2 25 Page Layout Formulas Home Insert Draw Data Review View Developer Tell me Calibri (Body 11 - A A % Paste === B 10 A Conditional Form Formatas Table Cell Styles Number X11 1 1 5 417 3 10 SAT ET 10 11 50 SETT 18 ATT SOT 12 18 19 20 21 34 15 16 17 TS 10 20 21 22 23 34 25 20 27 21 23 SANT 5472 HET 5477 SET SATU 477 5077 SAJT LETT 17 30 31 4077 SETT SATT 54 547) 547 SET 30 14 35 5 Samy 1477 57 41 4 SETY SET ET SOC 5477 10 MERT 10 95 02 + Ready 30 ZOOM Given the attached data. Answer the following questions for a 7 period moving average. MAD = Average|A-FD) TS =SUMIA-F)/MAD MSE - Average(A-F) 1. Compute your forecast for period 51. The potential answers are: A: 11221.6 B: 12461 C: 8020.83 D: 4414 E: 6589 2. Compute the MAD value for period 50, The potential answers are: A: 3760.99 B: 3999.02 C: 2847.49 D: 2655.35 E: 3753.86 E: 3753.86 3. Compute the TS value for period 50. The potential answers are: A: 0.6. B: -1.7. C: -0.7. D: -5.8. E: 2.5. 4. Compute the MSE value for period 50. The potential answers are: A: 18146974 B: 12998888 C: 20380735 D: 9474272 E: 18872575