1. Using the data in the Excel file Freshman College Data, identify the best regression model for predicting the first year retention rate. For the model you select, conduct further analysis to check for significance of the independent variables and for multicollinearity. 2. The Excel file Major League Baseball provides data on the 2010 season. a. Construct and examine the correlation matrix. Is multicollinearity a potential problem? Find the variance inflation factors to check your intuition. b. Suggest an appropriate set of independent variables that predict the number of wins by examining the correlation matrix and variance inflation factors. c. Find the best multiple regression model for predicting the number of wins. How good is your model? Does it use the same variables you thought were appropriate in part (b)?