Chart the data below in several ways, enough so you can talk about which modeling tool you should use. Then propose which modeling tools you are going to use and, based on/supported by your charts, why you will use those m Using split data modeling conduct a regression with categorical variables to create a forecast model. Discuss the information in the regression output, is it a good model, do all of the IV variables hold up or do you need to elim Once you have the correct IV's, test the model on the last two years of data that you held out of your model. Use CFE, MSE Discuss your CFE, MSE, MAD, and MAPE. What information do they provide? Then create four quarters of forecasts with the upper and lower confidence intervals of those forecasts. Consecut Net Sales ive Period qt 1995 1995 1995 1995 1996 1996 1996 1996 1997 1997 1997 1997 1998 1998 1998 1998 1999 1999 1999 1999 2000 2000 2000 2000 2001 2001 2001 2001 2002 2002 2002 2002 2003 (in millions) 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 2.89 2.03 4.41 5.57 2.78 1.92 13.75 13.06 3.64 1.89 16.9 27.66 12.02 6.83 20.23 50.91 13.8 9.16 64.13 63.03 41.21 43.79 91.95 137.01 130.47 52.45 141.66 46.18 74.64 35.29 111.26 64.67 130.05 2003 2003 2003 2004 2004 2004 2004 2005 2005 2005 2005 2006 2006 2006 2006 2007 2007 2007 2007 2008 2008 2008 2008 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 34 74.78 35 202.91 36 101.26 37 92.93 38 104.75 39 88.08 40 149.38 41 156.61 42 95.83 43 230.32 44 180.962 45 177.344 46 163.884 47 73.282 48 246.154 49 129.02 50 130.555 51 131.524 52 224.49 53 210.982 54 93.609 55 236.845 56 103.6 , why you will use those methods. d up or do you need to eliminate some, if so, eliminate them and run the regression again. your model. Use CFE, MSE, MAD, and MAPE to test the model