Need to do in excel #4 In the past, Judy Holmes's tire dealership sold an average of 1,200 radials each year. In the past three years, 268, 275 and 271, respectively, were sold in fall, 345, 347 and 353 in winter, 231, 217 and 228 in spring, and 356, 361 and 348 in summer. With a major expansion planned, Judy projects sales next year to increase to 1,800 radials. What will the demand be each season? #5 The following table provides the Dow Jones Industrial Average (DJIA) opening index value on the first working day of 1991-2012: YEA R 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 DJIA 2936 3517 3619 4072 4152 5435 6766 8226 9565 11854 11143 1037 4 8694 1080 5 11236 11036 1247 8 1378 0 1009 0 11749 1205 3 13115 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 1 Develop a regression model and use it to predict the opening DJIA index value for years 2013, 2014, and 2015. Find the R2 for this model. #6 Using the DJIA data in Problem #5, use exponential smooth with trend adjustment to forecast the opening DJIA value for 2013. Use = 0.8 and = 0.2. Compare the MSE for this technique with the MSE for the regression model in Problem #5. 2