Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started