There are $30$ Major League Baseball $($MLB$)$ teams. The table on the statistical functions worksheet lists the $2019$ and $1990$ payroll and win totals for each team $($notice that four teams were added after the $1990$ season$).$ Some MLB fans complain because the league does little to regulate the amount of money teams can pay for salaries. They argue that the teams that spend the most money will win the most games. This would put teams from small markets $($that earn less revenue$)$ at a disadvantage. Complete the tasks by inserting your formulas $($or responses$)$ in column I for each task to see if small market teams are at a disadvantage.

$1\mathrm{.}1$ Use the COUNT function to

$1\mathrm{.}2$ Use the COUNTA function to

$1\mathrm{.}3$ Use the SUM function to calculate the total amount of salaries paid in $1990.$

$5$

$1\mathrm{.}4.$ Use the SUM function to calculate the total amount of salaries paid in $2019.$