[Solved]1 Cell I18 Use Correl Function Determine Relationship Number Wins Team Earned 2010 Amount Q37229920
1. In cell i18, use the CORREL function to determine if there isa relationship between the number of wins a team earned in 2010 andthe amount teams’ salary amount.
2. In cell I21, use the CORREL function to determine if there isa relationship between the number of wins a team earned in 1990 andthe amount teams’ salary amount.
3. In cell I27, use the FORECAST.LINEAR function (or theFORECAST function if you are not using Excel 2016) to determine howmany games a team could expect to win in 2010 if they paid$150,000,000 in salary. Reference the appropriate ranges in thetable and the salary amount as the arguments for your function.
4. In cell I31, use the CONFIDENCE.NORM function to determinethe 95% confidence interval for wins in 2010. Reference theappropriate calculations for size and standard deviation asarguments for your function.
5. In cell I33, calculate the upper limit for the 95% confidenceinterval for your win prediction for a team paying $150,000,000 insalaries. Reference your prediction and the confidence intervalcalculation for your formula.
6. In cell I35, calculate the lower limit for the 95% confidenceinterval for your win prediction for a team paying $150,000,000 insalaries. Reference your prediction and the confidence intervalcalculation for your formula.
Major League Baseball Salaries by Team 2010 PAYROLL 1990 PAYROLL 2010 WINS 1990 Wins 76 DIVISION Baltimore Orioles 81,612 500S10037084 66 162AA333O83, 33382 206333389 S201318.9S 26 Number of MLB Teams in 1990 Eas Boston Red Sox AL East New York Yankees 30 Number of MLB teams in 2010 AL EastT LE Toronto Blue Jays L Cetral.IChicago White So AL Central Cleveland Indians AL Central Detroit Tigers ALCentra..Kansas City Royals AL Central Minnesota Twins Tampa Bay Rays 7123 471 62,234,00o$18486 83485 105 53000oS9496 238..88 61,203 966S1515200069 12286498S18,092 238..81 $71 405.210$23 873 745 67 9166S15,106,00094 $104 963 866$21 870 00080 5165,00$19.987,50181 86.510000128416661 5S250 544$15,1043290 $17A70,113Average slary for the teams in 1990 S90591996 Averagesalary for the teams in 2010. Population standard deviation for wins 1990. Population standard deviation for wins in 2010. Were teams more similar regarding wins in 1990 or 2010? Correlation between the number of wins a team eaned in 2010 and -8.894599784 13 LWest . Los Angeles Anges AL West Oakland Athletics AL West Seattle Mariners ALWes.TexasRangers 10.81973506 16 4 423 666$13328 334 $57,029,719 Atlanta Braves Florida Marlins New York Mets NL East the amount teams’ salary amount NL as.Philadelphia Phillies NL Eas.Washington Nationas NL Central Chicago Cubs NL Centra Cincinnati Reds NL Central Houston Astros 141.928379S13953,6697 $61400,000 $16,656,3886 Correlation between the number of wins a team eaned in 1990 and the amount teams’ salary amount 23 146.6000S14496,000..75 $71,761,542 $14,769,5009 $92,355,500 $18830,00076 2010 Is the relationship between wins and salary stronger in 1990 or 2010? 25 26 Miwaukee Brewer.S811082S20019,16777 NL Central. Pittsburgh Pirates NL Centra St. Louis Cardinals NL West Arizona Diamondbacks NL West Colorado Rockies $34943,000 $15,656,000 57 How many wins could a team expect to earn in 2010 if they paid $150,000,000 in salary2 540..S209233386 Salary Amount 84 227000 NL West . Los Angeles Do NL West..San Diego Padres $95,358,016 $21,618,704 80 7799300 $18588334 go $98,641,333 $20,942,333 92 what is the 95% confidence interval for wins in 2010? 32 75 NL West Sn Francisco Giants The Washington Nationals were the Montreal Expos in 1990 NA The team did not exist in 1990 Upper 95% confidence interval level. 34 Lower 95% confidence interval level Show transcribed image text Major League Baseball Salaries by Team 2010 PAYROLL 1990 PAYROLL 2010 WINS 1990 Wins 76 DIVISION Baltimore Orioles 81,612 500S10037084 66 162AA333O83, 33382 206333389 S201318.9S 26 Number of MLB Teams in 1990 Eas Boston Red Sox AL East New York Yankees 30 Number of MLB teams in 2010 AL EastT LE Toronto Blue Jays L Cetral.IChicago White So AL Central Cleveland Indians AL Central Detroit Tigers ALCentra..Kansas City Royals AL Central Minnesota Twins Tampa Bay Rays 7123 471 62,234,00o$18486 83485 105 53000oS9496 238..88 61,203 966S1515200069 12286498S18,092 238..81 $71 405.210$23 873 745 67 9166S15,106,00094 $104 963 866$21 870 00080 5165,00$19.987,50181 86.510000128416661 5S250 544$15,1043290 $17A70,113Average slary for the teams in 1990 S90591996 Averagesalary for the teams in 2010. Population standard deviation for wins 1990. Population standard deviation for wins in 2010. Were teams more similar regarding wins in 1990 or 2010? Correlation between the number of wins a team eaned in 2010 and -8.894599784 13 LWest . Los Angeles Anges AL West Oakland Athletics AL West Seattle Mariners ALWes.TexasRangers 10.81973506 16 4 423 666$13328 334 $57,029,719 Atlanta Braves Florida Marlins New York Mets NL East the amount teams’ salary amount NL as.Philadelphia Phillies NL Eas.Washington Nationas NL Central Chicago Cubs NL Centra Cincinnati Reds NL Central Houston Astros 141.928379S13953,6697 $61400,000 $16,656,3886 Correlation between the number of wins a team eaned in 1990 and the amount teams’ salary amount 23 146.6000S14496,000..75 $71,761,542 $14,769,5009 $92,355,500 $18830,00076 2010 Is the relationship between wins and salary stronger in 1990 or 2010? 25 26 Miwaukee Brewer.S811082S20019,16777 NL Central. Pittsburgh Pirates NL Centra St. Louis Cardinals NL West Arizona Diamondbacks NL West Colorado Rockies $34943,000 $15,656,000 57 How many wins could a team expect to earn in 2010 if they paid $150,000,000 in salary2 540..S209233386 Salary Amount 84 227000 NL West . Los Angeles Do NL West..San Diego Padres $95,358,016 $21,618,704 80 7799300 $18588334 go $98,641,333 $20,942,333 92 what is the 95% confidence interval for wins in 2010? 32 75 NL West Sn Francisco Giants The Washington Nationals were the Montreal Expos in 1990 NA The team did not exist in 1990 Upper 95% confidence interval level. 34 Lower 95% confidence interval level
Expert Answer
Answer to 1. In cell i18, use the CORREL function to determine if there is a relationship between the number of wins a team earned… . . .
OR
