Google Closing Prices Name: ( a` Expo . Smoothing Data Table CHE - A For date of weekly returns lin {{] of Google stock given here . forecast the return EXPO . for the WEEK Of March 5. 2017 2= follows .` 2- WEEK Squared \\Smoothing* Squared \\Alpha\\ Forecast MISE \\WEEK OF \\Return MOV AVE .` Error 0. 3 Error [NOTE : Express your forecast = in {{ rounded to to 2 decimal Place = 1 2. 3. 3. 2390). I OVIQUIZDIE I DVITIZZIE 0.45}6\\ and EXPRESS the MEE' = rounded to 5 decimal Place = ( =.=_\\.0007.31 . !) 10 I DZAIZZIE - 0. 5096 \\}| WISE a 3 - WEEK moving Everzzz End find the MEE form this . - 4 . 153/4 ( b) LEE Exponential smoothing with alpha valu= = 0.3 .` ILITIZZIE - 1.0596\\ |C| Now using the Data Table . Perform Exponential Smoothing with alpha value - 1 1/1 4/2015 0. 1 . 0. 2. 0. 3. 0. 4. 0.5. 0.0. 0.7. O.B. O.P. Choose the ElFINE with the Smallest MEE. 11/21/2010 0. 1596) What is the best forecast here and the corresponding alpha ?\\ 15 1 1/ZEIZZIE - 1. 4796 (It ) Which method is better between (=) ?_ WEEK; mov. ave . End Ic) Expo smoothing 10 12/5/2010 5.1796 with the best alpha ? Show MEE's to Support Your answer .* 18 12/12/2010 12/1 9/2016 0. 19 96) - 0. 1 1 96| 19 12/27/2016 2. 29 96) 1 13/2017 4.45 96\\ 21 0. 21 9` LIDZICTIT 22 - 0. 3596 23 1 123/2017 2.2796 1/20/2017 2.6596 1.5296 2 /13/2017 1 . 7 796 2/21/2017 VIZTIZZIT 3/5,2017 ?) \\MEE \\