I NEED HELP ON PART B,C,D only, part A am fine

5. (20 points) The following table provides the Dow Jones Industrial Average (DJIA) opening index value on the first working day of 19942013. YEAR DJIA YEAR DJIA YEAR DJIA YEAR DJIA YEAR DJIA 2013 13,104 2009 8,772 2005 10,784 2001 10,791 1997 6,448 2012 12,392 2008 13,262 2004 10,453 2000 11,502 1996 5,117 2011 11,577 2007 12,460 2003 8,342 1999 9,213 1995 3,834 2010 10,431 2006 10,718 2002 10,022 1998 7,908 1994 3,754 a. Develop a trend line and use it to predict the opening DJIA index value for years 2014, 2015, and 2016. Find the MSE for this model. b. Using the above data and exponential smoothing with trend adjustment, forecast the opening DJIA value for 2014. Use a = 0.8 and B = 0.2. Compare the MSE for this technique with the MSE for the trend line method in (a). C. Using the above data and exponential smoothing with trend adjustment, forecast the opening DJIA value for 2014. Use a = 0.4 and B = 0.2. Compare the MSE for this technique with the MSE for the trend line method in (a). d. Is higher or lower alpha value better to keep the MSE? Explain in 1-2 sentences