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