Refer to the Baseball 2010 data. Which report information on the 30 Major League
ID: 3440636 • Letter: R
Question
Refer to the Baseball 2010 data. Which report information on the 30 Major League Baseball teams for the 2010 season. Let the number of games won be the dependent variable and the following variables be independent variables: team batting average, number of stolen bases, number errors committed, team ERA, number of home runs, and whether the team plays in the American or the National League. Add a league code variable using 0 for the National League and 1 for the American League.
a. using a statistical software package to determine the multiple regression equation. Discuss each of the variables. For example are you surprised that the regression coefficient for ERA is a negative? Is the number of wins affected by whether the team plays in the National or the American League?
b. find the coefficient of determination for this set of independent varaibles.
c. Develop a correlation matrix. Which independent variables have strong or weak correlations with the dependent variable? Do you see any problems with mutlicollinearity?
d. Conduct a global test on the set of independent variables. Interpret.
e. Conduct a test of hypothesis on each of the independent variables. Would you consider deleting any of the variables? If so which ones?
F. Rerun the analysis until only sinificant net regression coefficients remain in the analysis. Identify these variables.
g. Develop a histogram of teh residuals from the final regression equation developed in part (f). Is it reasonable to conclude that the normality assumption has been met?
h. Plot the residuals against the fitted values from the final regression equation developed in part (f). Plot the residuals on the vertical axis and the fitted values on the horizontal axis.
Team League Wins ERA BA HR SB Errors Built Size Attendance Payroll Arizona Diamondbacks NL 65 4.81 0.250 180 86 102 1998 49033 2.06 60.7 Atlanta Braves NL 91 3.56 0.258 139 63 126 1996 50091 2.51 84.4 Year Average Baltimore Orioles AL 66 4.59 0.259 133 76 105 1992 48876 1.73 81.6 X13 X14 Boston Red Sox AL 89 4.20 0.268 211 68 111 1912 39928 3.05 162.7 1989 $512,930 Chicago Cubs NL 75 4.18 0.257 149 55 126 1914 41118 3.06 146.9 1990 $578,930 Chicago White Sox AL 88 4.09 0.268 177 160 103 1991 40615 2.19 108.3 1991 $891,188 Cincinnati Reds NL 91 4.01 0.272 188 93 72 2003 42059 2.06 72.4 1992 $1,084,408 Cleveland Indians AL 69 4.30 0.248 128 91 110 1994 43345 1.39 61.2 1993 $1,120,254 Colorado Rockies NL 83 4.14 0.263 173 99 101 1995 50445 2.88 84.2 1994 $1,188,679 Detroit Tigers AL 81 4.30 0.268 152 69 109 2000 41782 2.46 122.9 1995 $1,071,029 Florida Marlins NL 80 4.08 0.254 152 92 123 1987 36331 1.54 55.6 1996 $1,176,967 Houston Astros NL 76 4.09 0.247 108 100 103 2000 40950 2.33 92.4 1997 $1,383,578 Kansas City Royals AL 67 4.97 0.274 121 115 121 1973 40793 1.62 72.3 1998 $1,441,406 Los Angeles Angels AL 80 4.04 0.248 155 104 113 1966 45050 3.25 105 1999 $1,720,050 Los Angeles Dodgers NL 80 4.01 0.252 120 92 98 1962 56000 3.56 94.9 2000 $1,988,034 Milwaukee Brewers NL 77 4.58 0.262 182 81 101 2001 42200 2.78 81.1 2001 $2,264,403 Minnesota Twins AL 94 3.95 0.273 142 68 78 2010 40000 3.22 97.6 2002 $2,383,235 New York Mets NL 79 3.70 0.249 128 130 87 2009 45000 2.56 132.7 2003 $2,555,476 New York Yankees AL 95 4.06 0.267 201 103 69 2009 52325 3.77 206.3 2004 $2,486,609 Oakland Athletics AL 81 3.56 0.256 109 156 99 1966 34077 1.42 51.7 2005 $2,632,655 Philadelphia Phillies NL 97 3.67 0.260 166 108 83 2004 43647 3.65 141.9 2006 $2,866,544 Pittsburgh Pirates NL 57 5.00 0.242 126 87 127 2001 38496 1.61 34.9 2007 $2,944,556 San Diego Padres NL 90 3.39 0.246 132 124 72 2004 42445 2.13 37.8 2008 $3,154,845 San Francisco Giants NL 92 3.36 0.257 162 55 73 2000 41503 3.04 97.8 2009 $3,240,206 Seattle Mariners AL 61 3.93 0.236 101 142 110 1999 47116 2.09 98.4 2010 $3,297,828 St. Louis Cardinals NL 86 3.57 0.263 150 79 99 2006 49660 3.3 93.5 Tampa Bay Rays AL 96 3.78 0.247 160 172 85 1990 36048 1.84 71.9 Texas Rangers AL 90 3.93 0.276 162 123 105 1994 49115 2.51 55.3 Toronto Blue Jays AL 85 4.22 0.248 257 58 92 1989 50516 1.63 62.7 Washington Nationals NL 69 4.13 0.250 149 110 127 2008 41888 1.83 61.4Explanation / Answer
Refer to the Baseball 2010 data. Which report information on the 30 Major League