1. Refer to the Baseball 2012 data, which report information on the 30 Major Lea
ID: 3290216 • Letter: 1
Question
1. Refer to the Baseball 2012 data, which report information on the 30 Major League Baseball teams for the 2012 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?
A.2 Data Set 2-Baseball Statistics, 2012 Season Variables x, Teanm x2 -League (American = 1, National = 0) = Built (year stadium was built) x Size (stadium capacity) xs-salary (total 2012 team salary, $ millions) wins x, = Attendance (total for team in millions) = BA (team batting average) x ERA (team eaned run average) X10 = HR (team home runs) X11 Errors (team errors) x12SB (team stolen bases) x13Year x4 Average player salary (S)Explanation / Answer
Excel formula:
Team Salary wins win (if >=81) salary (if >=median) 1 74.3 81 1 0 median salary= 85.75 2 83.3 94 1 0 3 81.4 93 1 0 Obsereved 4 173.2 69 0 1 win 5 88.2 61 0 1 more than 81 less than 81 6 96.9 85 1 1 salary more than median 10 5 15 7 82.2 97 1 0 less than median 7 8 15 8 78.4 68 0 0 17 13 30 9 78.1 64 0 0 10 132.3 88 1 1 Expected win 11 60.7 55 0 0 more than 81 less than 81 12 60.9 72 0 0 salary more than median 8.5 6.5 15 13 154.5 89 1 1 less than median 8.5 6.5 15 14 95.1 86 1 1 17 13 30 15 118.1 69 0 1 16 97.7 83 1 1 CHI-SQ win 17 94.1 66 0 1 more than 81 less than 81 18 93.4 95 1 1 salary more than median 0.265 0.346 19 198 74 0 1 less than median 0.265 0.346 20 55.4 94 1 0 21 174.5 81 1 1 CHI-SQ= 1.222 22 63.4 79 0 0 P-value= 0.2690 >.05 23 55.2 76 0 0 we cant reject H0; thus conclude that there is no significant relationship between salary and winning 24 117.6 94 1 1 25 82 75 0 0 26 110.3 88 1 1 27 64.2 90 1 0 28 120.5 93 1 1 29 75.5 73 0 0 30 81.3 98 1 0Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.