A B C D E F G H K 1 Team League Team Salary ($ mil) HR BA Wins ERA Year Stadium Opened Attendance (mil) Net Worth ($ bil) Arizona Diamondbacks National 143.32 176 0.235 82 W N 3.72 1998 2.242695 1.21 Atlanta Braves National 130.6 175 0.257 90 3.75 2017 2.555781 1.625 Baltimore Orioles American 127.63 188 0.239 47 5.18 1992 1.564192 1.2 Boston Red Sox American 227.4 208 0.268 BOT 3.75 1912 2.895575 2.8 Chicago Cubs National 194.26 167 0.258 95 3.65 1914 3.181089 2.9 Chicago White Sox American 71.84 182 0.241 62 4.84 1991 1.608817 1.5 8 Cincinnati Reds National 100.31 172 0.254 67 4.63 2003 1.629356 1.01 9 Cleveland Indians American 142.8 216 0.259 91 3.77 1994 1.926701 1.045 10 Colorado Rockies National 143.97 210 0.256 91 4.33 1995 3.01588 1.1 11 Detroit Tigers American 130.96 135 0.241 64 4.58 2000 1.85697 1.225 12 Houston Astros American 163.52 205 0.255 103 3.11 2000 2.980549 1.65 13 Kansas City Royals American 129.94 155 0.245 58 4.94 1973 1.665107 1.015 14 Los Angeles Angels American 173.78 214 0.242 80 4.15 1966 3.020216 1.8 15 Los Angeles Dodgers National 199.58 235 0.25 92 3.38 1962 3.8575 3 16 Miami Marlins National 91.82 128 0.237 63 4.76 2012 0.811104 1 17 Milwaukee Brewers National 108.98 218 0.252 96 3.73 2001 2.850875 1.03 18 Minnesota Twins American 115.51 166 0.25 78 4.5 2010 1.959197 1.15 19 New York Mets National 150.19 170 0.234 77 4.07 2009 2.224995 2.1 20 New York Yankees American 179.6 267 0.249 100 3.78 2009 3.482855 4 21 Oakland Athletics American 80.32 227 0.252 97 3.81 1966 1.573616 1.02 22 Philadelphia Phillies National 104.3 186 0.234 80 4.14 2004 2.158124 1.7 23 Pittsburgh Pirates National 91.03 157 0.254 82 2001 1.465316 1.26 24 San Diego Padres National 101.34 162 0.235 66 4.4 2004 2.168536 1.27 25 San Francisco Giants American 205.67 176 0.254 89 4.13 2000 2.299489 2.85 26 Seattle Mariners National 160.99 133 0.239 73 3.95 1999 3.156185 1.45 27 St. Louis Cardinals National 163.78 205 0.249 88 3.85 2006 3.403587 1.9 28 Tampa Bay Rays American 68.81 150 0.258 90 3.74 1990 1.154973 0.9 29 Texas Rangers American 140.63 194 0.24 67 4.92 1994 2.107107 1.6 30 Toronto Blue Jays American 150.95 217 0.244 73 4.85 1989 2.325281 1.35 31 Washington Nationals National 181.38 191 0.254 82 4.04 2008 2.529604 1.675 32A team's win-loss record is a function of scoring more runs than the opponent in a majority of games played during a season. . Variables in our data set that reflect a team's ability to score runs are home runs and batting average; a higher number of home runs and a higher batting average is assumed to be positively correlated to scoring more runs and thus earning more wins as a team. . Furthermore, if a team can prevent the opponent from scoring runs, then it is more likely to win the game. Earned run average (ERA) reflects the number of earned runs given up by a team's pitchers over the course of a 9-inning game. The lower the ERA, the lower the runs the team's pitchers give up during the course of a game, and thus a higher chance for the team to win (assumed to reflect a negative correlation or inverse relationship between ERA and wins). . Finally, a team with more talented players will presumably have a higher payroll due to the larger contracts the more talented players will demand and earn. Thus, it is assumed that a team's payroll is positively correlated to wins. We will analyze these assumed relationships and determine how much of a factor these variables play in predicting a team's number of wins in a given season. E. Determine the correlation coefficient for the following variables in relation to wins as well as the actual relationship between the independent variable listed and wins. Round your answers to 2 decimal places. . Use a zero in front of the decimal. . Use a negative in front of the zero if the correlation coefficient is negative. . Enter the actual relationship as Positive, Negative, or None. Correlation Coefficients with Wins Expected Actual Relationship Relationship ? HR Positive BA Positive ERA Negative Team Positive Salary F. Does the correlation coefficient analysis reflect any differences between the expected and actual relationships? Enter Yes or No