Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The attached Excel file 2013 NCAA BB Tournament shows the salaries paid to the coaches of 62 of the 68 teams in a recent NCAA
The attached Excel file 2013 NCAA BB Tournament shows the salaries paid to the coaches of 62 of the 68 teams in a recent NCAA men's Division 1 basketball ournament (not all private schools report their coach's salaries). Consider these 62 salaries to be a sample from the population of salaries of all 346 NCAA Division I basketball coaches in the year the tournament was held. Question 1. Use the 62 salaries from the TOTAL PAY column to construct a 90% confidence interval for the mean year 2013 salary of all basketball coaches in NCAA Division I. lower bound of confidence interval upper bound of confidence interval Question 2. Coach Mike Krzyzewski's high salary is an outlier and could be significantly affecting the confidence interval results. Remove Coach Krzyzewski's salary from the data and recalculate the 0% confidence interval using the remaining 61 salaries. lower bound of confidence interval upper bound of confidence interval.\f36 Marquette Big East Buzz Williams $1,105,203 37 San Diego State Mt. West Steve Fisher $840,000 38 Nevada-Las Vegas Mt. West Dave Rice $765,000 39 Belmont Ohio Valley Rick Byrd $728,667 40 Temple A-10 Fran Dunphy $724,557 41 Notre Dame Big East Mike Brey $616,843 42 Colorado PAC-12 Tad Boyle $591,310 43 Saint Mary's West Coast Randy Bennett $517,381 44 Colorado State Mt. West Larry Eustachy $500,000 45 Boise State Mt. West Leon Rice $430,020 46 New Mexico State WAC Marvin Menzies $423,868 47 La Salle A-10 John Giannini $426,230 48 Akron MAC Keith Dambrot $425,000 49 Davidson Southern Bob Mckillop $379,618 50 Western Kentucky Sun Belt Ray Harper $375,000 51 Pacific Big West Bob Thomason $322,651 52 Liberty Big South Dale Layer $308,682 53 Middle Tennessee: Sun Belt Kermit Davis $290,000 54 James Madison CAA Matt Brady $290,000 55 Albany Am East Will Brown $276,298 56 Bucknell Patriot Dave Paulsen $222,389 57 Montana Big Sky Wayne Tinkle $135,000 58 Florida Gulf Coast Atl Sun Andrew Enfield $157,500 59 South Dakota Stat Summit Scott Nagy $152,000 60 North Carolina A& MEAC Cy Alexander $150,000 61 Northwestern Stat Southland Mike McConathy $127,000 62 Southern SWAC Roman Banks $115,000OTHER PAY TOTAL PAY MAX BONUS $0 $7,233,976 $0 $895,016 $4,973,343 $725,000 $210,000 $4,960,763 $525,000 $525,000 $3,745,769 $350,000 $0 $3,689,200 $471,500 $107,000 $3,194,000 $410,000 $0 $2,886,250 $740,000 $418,506 $2,518,506 $985,000 $257,000 $2,357,000 $400,000 $0 $2,290,346 $0 $0 $2,275,000 $50,000 $2,250,000 $235,000 $0 $2,215,769 $2,600,000 $0 $2,211,250 $0 $0 $2,100,000 $270,000 $0 $1,950,000 $1,312,500 $0 $1,905,576 $65,975 $1,865,975 $200,000 $0 $1,830,176 $0 $1,800,000 $520,000 $0 $1,773,938 $111,312 $6,500 $1,756,500 $350,000 $0 $1,650,000 $825,000 $0 $1,571,847 $0 $0 $1,500,000 $655,000 $0 $1,400,000 $775,000 $10,000 $1,380,000 $649,250 $0 $1,369,949 SO $8,500 $1,358,500 $555,000 $6,000 $1,306,000 $1,002,500 $38,500 $1,247,700 $655,000 $0 $1,220,000 $545,000 $11,600 $1,211,600 $675,000 $32,000 $1,187,000 $803,000 $0 $1,165,940 $0 $0 $1,105,203 $0 $17,500 $857,500 $185,000 $954 $765,954 $345,000 $0 $728,667 $0SO $728,667 SO $724,557 SO SO $616,843 $6,000 $597,310 $1,675,000 SO $517,381 SO $500,000 $600,000 $10,500 $440,520 $75,500 $10,000 $433,868 $225,000 $0 $426,230 $0 $1,000 $426,000 $723,167 SO $379,618 $0 $2,000 $377,000 $628,125 $322,651 So $o $308,682 $14,000 $304,000 $80,000 $4,000 $294,000 $200,000 $17,000 $293,298 $202,700 $222,389 $43,500 $178,500 $146,000 $2,050 $159,550 $95,000 $1,025 $153,025 $17,000 SO $150,000 $33,500 SO $127,000 $16,000 SO $115,000 $181,247
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started