Data Analysis

Use the concepts you have learned from BA Chapters $2,3,4,$ and $8$ and DV $5-8$ to develop a presentation of the data story that will help Kris to inform his boss,the final decision$-$maker, of how many football magazines should be purchased for Year $10.$ Consider the following when preparing for data analysis and what you want to focus on in your data story.

Step $1$: There is a considerable amount of data available in the file magazines$\_$csu, but not all of it may be useful for your purposes here. Are there variables contained in the file magazines$\_$csu that you would exclude from a forecast model to determine football magazine sales in Year $10?$ If so$,$ why? Are there particular observations of football magazine sales from previous years that you would exclude from your forecasting model? If so$,$ why?

Step $2$: Based on the data in the file magazines$\_$csu, develop a regression model to forecast the average sales of football magazines for each of the seven home games in the upcoming season $($Year $10).$ That is$,$ you should construct a single regression model and use it to estimate the average demand for the seven home games in Year $10.$ In