Lec 6 Sample Final Part I(2).xlsx - Practice problems for...

07/23/2017 dcfdc47ebfce80b05e2a0a610ef5c9aa09fcd9de.xlsx
Practice problems for Final - Part 1
1
compute the mean and variance of salaries in the sample.
2
Using the results for problem 1, test the hypothesis that the mean salary for
a
b
c
3
compute the mean and varaince of salaries for the sample.
4
Using the results for problem 1, test the hypothesis that the standard deviation of salaries
5
a
the population variances of salaries in the two leagues are equal.
6
ratio of the two population variances.
7
Using the results of problems 1 and 2, test the hypothesis that the average salaries
a Assume the the population variances are equal.
b Assume the the population variances are not equal.
c
8
Using the results of problems 1 and 2, test the hypothesis that the variance
a
b
Draw a sample of 36 NBA players from the population of all NBA players, and
NBA players is greater than $5,000,000. Find a p-value. (Use σ )
Repeat part a using s.
use Z.TEST to find a p-value. Compare to part a
Draw a random sample of 40 MLB players from the population of all MLB players, and
for MLB players is less than $5,000,000
Using the results of problems 1 and 2 , construct a 95% confidence interval for the
difference in average salaries between the NBA and MLB . Assume that
Using the results of problems 1 and 2 , construct a 94% confidence interval for the
in the NBA and in MLB are equal.
Use T.TEST for parts a and b compare your answers.
of salaries in the NBA and in MLB are equal.
use F.TEST to test the hyppothesis and compare you answer to part a

INDEX # NBA TEAM NAME POS AGE HT WT COLLEGE
1 Boston Celtics Avery Bradley PG 25 74 180 Texas
2 Boston Celtics Jae Crowder SF 25 78 235 Marquette
3 Boston Celtics R.J. Hunter SG 22 77 185 Georgia Sta
4 Boston Celtics Jonas Jerebko PF 28 82 231
5 Boston Celtics Amir Johnson PF 28 81 240
6 Boston Celtics David Lee PF 32 81 245 Florida
7 Boston Celtics Jordan Mickey PF 21 80 235 LSU
8 Boston Celtics Kelly Olynyk C 24 84 238 Gonzaga
9 Boston Celtics Terry Rozier PG 21 74 190 Louisville
10 Boston Celtics Marcus Smart PG 21 76 220 Oklahoma
11 Boston Celtics Jared Sullinger C 23 81 260 Ohio State
12 Boston Celtics Isaiah Thomas PG 26 69 185 Washingto
13 Boston Celtics Evan Turner SG 27 79 220 Ohio State
14 Boston Celtics James Young SG 20 78 215 Kentucky
15 Boston Celtics Tyler Zeller C 26 84 253 North Caro
16 Brooklyn Nets Andrea Bargnani C 30 84 245
17 Brooklyn Nets Bojan Bogdanovic SG 26 80 216
18 Brooklyn Nets Markel Brown SG 23 75 190 Oklahoma
19 Brooklyn Nets Wayne Ellington SG 28 76 200 North Caro
20 Brooklyn Nets Rondae Hollis-Jeffer SG 21 69 220 Arizona
21 Brooklyn Nets Jarrett Jack PG 32 75 200 Georgia Te
22 Brooklyn Nets Joe Johnson SF 34 79 240 Arkansas
23 Brooklyn Nets Sergey Karasev SG 22 79 208
24 Brooklyn Nets Shane Larkin PG 23 71 175 Miami (FL)
25 Brooklyn Nets Brook Lopez C 27 84 275 Stanford
26 Brooklyn Nets Chris McCullough PF 20 83 200 Syracuse
27 Brooklyn Nets Willie Reed PF 25 82 220 Saint Louis
28 Brooklyn Nets Thomas Robinson PF 24 82 237 Kansas
29 Brooklyn Nets Donald Sloan PG 28 75 205 Texas A&M
30 Brooklyn Nets Thaddeus Young PF 27 80 221 Georgia Te
31 New York Knicks Arron Afflalo SG 30 77 210 UCLA
32