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