Use the COUNT function to calculate the number of MLB teams in 1990 (range G4:G33)

2.2

Use the COUNTA function to calculate the number of MLB teams (use range G4:G33).

2.3

Use the SUM function to calculate the total amount of salaries paid in 1990.

2.4

Use the SUM function to calculate the total amount of salaries paid in 2019.

2.5

Use the AVERAGE function to calculate the average salary for the teams in 1990.

2.6

Use the AVERAGE function to calculate the average salary for the teams in 2019.

2.7

Use the MAX function to determine the maximum team salary amount in 1990.

2.8

Use the MIN function to determine the minimum team salary amount in 2019.

AutoSave O OFF A A . G ... Book3 Q Home Insert Draw Page Layout Formulas Data Review View Acrobat ? Tell me Share Comments Insert v Calibri (Body) v 12 AA ab v General EV AY- O. me x Delete v Conditional Format Cell Sort & Find & Analyze Tasks Create and Share Paste B I UV V MAv $~ % " Formatting as Table Styles Format Filter Select Data Adobe PDF K29 4 X V fx $ A B D E F G H J K M MyEducator Tasks 12 5 Major League Baseball Salaries by Team Statistical Functions DIVISION TEAM 2019 PAYROLL 1990 PAYROLL 2019 WINS 1990 Wins Response Task 2.5 Use the AVERAGE function to AL East Baltimore Orioles $73,370,109 $10,037,08 54 76 Number of MLB Teams in 1990 calculate the average salary for the AL East Boston Red Sox $229,196,106 $20,983,333 84 AL East New York Yankees $223,019,037 $20,991,318 103 67 Number of MLB teams teams in 1990. AL East Tampa Bay Rays $64,178,722 NA 96 NA AL East Toronto Blue Jays $111,371,067 $18,486,834 57 86 Total salaries paid in 1990. AL Central Chicago White Sox $91,371,201 $9,496,238 72 94 AL Central Cleveland Indians $107,693,747 $15,152,000 77 Total salaries paid in 2019. 2.6 Use the AVERAGE function to 2 w AL Central Detroit Tigers $114,631,137 $18,092,238 79 calculate the average salary for the AL Central Los Angeles Angels $161,270,385 $21,870,000 72 80 Average salary paid by the teams in 1990. teams in 2019. AL Central Minnesota Twins $125,256,003 $15,106,000 101 74 AL West Kansas City Royals $104,773,003 $23,873,745 59 75 Average salary paid by the teams in 2019. 15 AL West Los Angeles Dodgers $207,000,814 $21,618,704 106 86 16 AL West Oakland Athletics $93,394,531 $19,987,501 17 103 Maximum team salary amount in 1990. 2.7 Use the MAX function to AL West Seattle Mariners $144,391,293 $12,841,667 68 77 18 AL West Texas Rangers $148,538,766 $15,104,372 78 83 Minimum team salary amount in 2019. determine the maximum team salary 19 NL East Atlanta Braves $143,947,963 $13,328,334 $65 amount in 1990. 20 NL East Houston Astro $168,804,925 $18,830,000 107 75 NL East New York Mets $146,335,812 $22,418,834 86 91 NL East Philadelphia Phillies $160,192,244 $13,953,667 77 23 NL East Washington Nationals* $172,307,808 $16,656,388 85 2.8 Use the MIN function to 24 NL Central Chicago Cubs $221,590,085 $14,496,000 77 determine the minimum team salary 25 NL Central Cincinnati Reds $128,391,569 $14,769,500 91 26 NL Central Milwaukee Brewers $135,889,019 $20,019,167 74 amount in 2019. 27 NL Central Pittsburgh Pirate $72,731,474 $15,656,000 95 28 NL Central St. Louis Cardinals $174,317,164 $20,923,334 70 5 29 NL West Arizona Diamondbacks $118,927,905 NA 85 NA S 30 NL West Colorado Rockies $157,162,629 NA 71 NA 31 NL West Florida Marlins $75,596,271 NA 57 NA 32 NL West San Diego Padres $104,254,790 $18,588,334 70 75 33 NL West San Francisco Giants $178,582,126 $20,942,333 77 85 3 Finance 34 * The Washington Nationals were the Montreal Expos in 1990 35 NA = The team did not exist in 1990 36 Complete each task by inserting the 37 appropriate function, referencing the 38 39 appropriate cells in the task data, in the 40 specified cells. Statistical Functions Financial Functions Formulas + 100% Enter