(c): What is the 2017 predicted value for Unit 4 using the 6-month weighted averagewith weights of .1, .1, .1, .2, .2, and .3 (with .3 being the most recent year)?

(d): What is the 2017 predicted value for Unit 5 using Exponential smoothing with an = .3? Assume the exponential smoothing starts in year 2012 with the value 3259 (based on the average of the actual 2009-2011 values), and all the exponential smoothing values for the years that follow are calculated using the exponential smoothing equation explained in the Unit 5 time series forecasting models video starting at time 12:17. ((NOTE: You don't need any exponential smoothing values for years 2009-2011 as they are before the anchor in year 2012.))

(e): What is the 2017 predicted value for Unit 6 using the trend progression prediction? (Use the trend line formula to predict the next value in the series)

(PLEASE SHOW WORK IN EXCEL)

YEAR 2009 2010 2011 2012 Unit 1 4182 4049 4235 4083 3683 3230 3240 Unit 2 2353 2199 2203 2248 2263 2218 2244 Unit 3 3470 3653 3594 3324 2905 2552 2425 2236 Unit 4 4218 4586 4573 4859 5162 5059 4892 Unit 5 3200 3274 3303 3243 3495 3761 3773 3767 Unit 6 2347 2380 2307 2475 1598 1344 2013 2014 2015 2016 1363 3180 2292 4779 1370 2017