Refer to the Baseball 2005 data, which report information on the 30 Major League Baseball teams for the 2005 season. Let the number of games won be the dependent variable (Wins) and the following variables be independent variables: team batting average (Batting), number of stolen bases (SB), number of errors committed (Error), team ERA, number of home runs (HR), and whether the team's home field is natural grass or artificial turf (Surface =1 if artificial, =0 if natural). a. Run regression including all the independent variables. Do you see any problems with multicollinearity? b. Rerun the analysis using the all possible regression model in the analysis. Which model is the best model? Would you consider deleting any of the variables? If so, which ones? Identify these variables. c. Rerun the regression equation, using the best model. Is number of home runs (HR) a significant factor to affect number of games won? If yes, interpret the estimated coefficient. d. Rerun the regression equation, using the best model. Is number of errors committed (Error) a significant factor to affect number of games won? If yes, interpret the estimated coefficient. e. Using residual plot, are there any violations in the the assumption of linear regression f. Returnn Stepwise regression to determine which variable is the most important variable to affect monthly salary? By how much?

Wins 95 95 88 74 95 93 99 80 83 67 79 71 69 56 90 77 89 73 83 67 71 82 81 75 100 83 88 81 79 67

Batting 0.281 0.276 0.262 0.269 0.27 0.271 0.262 0.265 0.259 0.274 0.267 0.272 0.256 0.263 0.265 0.256 0.256 0.261 0.258 0.259 0.253 0.257 0.252 0.261 0.27 0.272 0.27 0.259 0.27 0.267

ERA 4.74 4.52 3.69 4.56 3.68 3.61 3.61 4.06 3.71 5.39 4.96 4.51 4.49 5.49 3.98 4.84 3.51 5.15 3.76 4.42 4.38 4.13 3.87 4.33 3.49 4.16 4.21 3.97 4.19 5.13

HR 199 229 155 189 147 207 200 136 134 157 260 168 130 126 184 191 161 222 175 139 149 130 117 128 170 128 167 175 194 150

Error 109 95 88 107 87 106 94 95 102 124 108 110 86 125 86 94 89 104 106 117 106 109 92 90 100 103 90 119 101 118

SB 45 84 31 83 161 62 137 72 102 151 67 66 102 53 92 67 115 72 153 73 58 99 45 71 83 96 116 79 65 65

Surface 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Please put answers in excel