Hi, I need to make sure I have drafted a thorough analysis, so please answer the following questions. Based on the data in the image, develop a regression model to forecast the average sales of football magazines for each of the 7 home games in the upcoming season (Year 10). You should construct a single regression model and use it to estimate the average demand for the 7 home games in Year 10. You may create new variables based on these variables or based on observations of your analysis. Be sure to provide a thorough analysis of your final model (residual diagnostics) and provide assessments of its accuracy. What insights are available based on your regression model? Then, use the forecasting model you developed for Item 2 above to create a simulation model that can be used to estimate the total football magazine sales amounts in Year 10. Your simulation model should have 7 uncertain inputs: 1 input for football magazine sales at each CSU game in Year 10. Then sum these sales amounts for each individual game to create a total football magazine sales amount for Year 10.
Leave a Reply