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 u 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 n 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 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. Consecutive Net Sales Period qt (in millions) 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 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 3.43 1.9 5.33 5.12 2.9 1.66 16.46 19.73 3.14 3.49 27.24 28.39 13.74 5.15 29.19 31.26 27.24 12.97 70.1 73.96 37.61 31.58 120.3 56.19 130.13 92.3 134.35 142.42 72.38 50.33 133.99 54.98 80.17 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 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 77.43 76.14 171.98 159.55 153.4 76.66 173.34 178.38 101.74 152.23 151.582 150.874 88.364 230.502 192.044 153.49 85.125 152.234 206.22 248.082 207.329 276.505 276.28 g tool you should use. by your charts, why you will use those methods. a forecast model. V variables hold up or do you need to eliminate some, if so, eliminate them and run the regression again. ou held out of your model. Use CFE, MSE, MAD, and MAPE to test the model. als of those forecasts