Will you show the formulas and how you do it? There are 30 Major League Baselbal
ID: 3885371 • Letter: W
Question
Will you show the formulas and how you do it?
There are 30 Major League Baselball (MLB) teams. The table below lists the 2010 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. Are small market teams at a disadvantage?Explanation / Answer
Number of MLB teams in 1990
Answer: =COUNTIF(C2:C5,"<>$*)
C2:C5 => range of values, "<>$*" => select the values with $symbol and excludes others. countif => count the number of values.
Number of MLB teams in 2010
Answer: =countif(select range of values)
Total salaries paid in 1990
Answer: =sum($A$1:$A$7) Explanation: =sum(range of values from to to bottom), A1 to $A$1 - press F4
Total salaries paid in 2010
Answer: =sum(A1:A7) Explanation: =sum(range of values from to to bottom)
Average salaries paid by the team 1990
Answer: =average(select range)
Average salaries paid by the team 2010
Answer: =average(select range)
Maximum team salaries in 1990
Answer: =max(select range)
Maximum team salaries in 2010
Answer: =max(select range)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.