Refer to the Baseball 2010 data Which report information on

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.4

Solution

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 dependen
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 dependen

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site