1. Refer to the Baseball 2015 data, which report information on the 30 Major League Baseball teams for the 2015 season. Set up a variable that divides the teams into two groups, those that had a winning season and those that did not. There are 162 games in the season, so define a winning season as having won 81 or more games. Next, find the median team salary and divide the teams into two salary groups. Let the 15 teams with the largest salaries be in one group and the 15 teams with the smallest salaries be in the other. At the .05 significance level, is there a relationship between salaries and winning? Using Excel

Team Salary	Wins
74.8	79
87.7	67
84.6	81
110.7	78
80.8	97
133	76
89.6	64
65.8	81
69.1	68
123.2	74
108.3	86
118.9	95
117.7	85
126.6	92
144.8	71
85.9	68
98.3	83
98.7	90
100.1	87
174.5	68
112.9	63
172.8	98
116.4	74
168.7	84
117.2	76
146.4	100
213.5	80
166.5	88
120.3	93
230.4	83