07/23/2017dcfdc47ebfce80b05e2a0a610ef5c9aa09fcd9de.xlsxPractice problems for Final - Part 11compute the mean and variance of salaries in the sample.2Using the results for problem 1, test the hypothesis that the mean salary forabc3compute the mean and varaince of salaries for the sample.4Using the results for problem 1, test the hypothesis that the standard deviation of salaries5athe population variances of salaries in the two leagues are equal.6ratio of the two population variances. 7Using the results of problems 1 and 2, test the hypothesis that the average salariesaAssume the the population variances are equal.bAssume the the population variances are not equal.c8Using the results of problems 1 and 2, test the hypothesis that the variance abDraw a sample of 36 NBAplayers from the population of all NBAplayers, andNBAplayers is greater than $5,000,000. Find a p-value. (Use σ)Repeat partausing s.use Z.TESTto find a p-value. Compare to partaDraw a random sample of 40 MLBplayers from the population of all MLBplayers, andfor MLBplayers is less than $5,000,000Using the results of problems 1and 2, construct a 95% confidence interval for thedifference in average salaries between the NBAand MLB. Assume thatUsing the results of problems 1and 2, construct a 94% confidence interval for thein the NBA and in MLB are equal.Use T.TESTfor parts a and b compare your answers.of salaries in the NBAand in MLBare equal.use F.TESTto test the hyppothesis and compare you answer to part a
INDEX #NBA TEAMNAMEPOSAGEHTWTCOLLEGE1Boston Celtics Avery BradleyPG2574180Texas2Boston Celtics Jae CrowderSF2578235Marquette3Boston Celtics R.J. HunterSG2277185Georgia Sta4Boston Celtics Jonas JerebkoPF28822315Boston Celtics Amir JohnsonPF28812406Boston Celtics David LeePF3281245Florida7Boston Celtics Jordan MickeyPF2180235LSU8Boston Celtics Kelly OlynykC2484238Gonzaga9Boston Celtics Terry RozierPG2174190Louisville10Boston Celtics Marcus SmartPG2176220Oklahoma 11Boston Celtics Jared SullingerC2381260Ohio State12Boston Celtics Isaiah ThomasPG2669185Washingto13Boston Celtics Evan TurnerSG2779220Ohio State14Boston Celtics James YoungSG2078215Kentucky15Boston Celtics Tyler ZellerC2684253North Caro16Brooklyn NetsAndrea BargnaniC308424517Brooklyn NetsBojan BogdanovicSG268021618Brooklyn NetsMarkel BrownSG2375190Oklahoma 19Brooklyn NetsWayne EllingtonSG2876200North Caro20Brooklyn NetsRondae Hollis-JefferSG2169220Arizona21Brooklyn NetsJarrett JackPG3275200Georgia Te22Brooklyn NetsJoe JohnsonSF3479240Arkansas23Brooklyn NetsSergey KarasevSG227920824Brooklyn NetsShane LarkinPG2371175Miami (FL)25Brooklyn NetsBrook LopezC2784275Stanford26Brooklyn NetsChris McCulloughPF2083200Syracuse27Brooklyn NetsWillie ReedPF2582220Saint Louis28Brooklyn NetsThomas RobinsonPF2482237Kansas29Brooklyn NetsDonald SloanPG2875205Texas A&M30Brooklyn NetsThaddeus YoungPF2780221Georgia Te31New York Knicks Arron AfflaloSG3077210UCLA32