Provide a paragraph of 100+ words for your answer; print out and submit at our next class

Learning Goal: I’m working on a marketing question and need a sample draft to help me learn.1. Run a linear regression analysis with the data set on a separate tab; remember columns must be next to each other to use the Toolpak wizard 2. Examine all the variable outputs and eliminate any variables which are not significant at 95% 3. In the space provided, on the tab labeled HW template tab, please detail which variables have the strongest prediction of Price (your Y)? 4. Using the sample data n the Prediction Model section, predict which of the two data sets will have a higher On Time % 5. Also, in the space provided, what’s your overall interpretation of this dataset including which variables would you consider to eliminate or combine? 5. Provide a paragraph of 100+ words for your answer; print out and submit at our next class
Requirements: 200