The attached spreadsheet contains media revenue(local and national), payroll and winning percentagedata from Major League Baseball. What kinds of relationships can you find? In particular, do teams with more media revenue have higher payrolls? What's the ratio between the highest media revenue teams and the lowest media revenue teams? What percentage of media revenue is local vs national? What percent of payroll do media revenues cover for most (or average) teams?

Based on this data - draw some conclusions about competitive balance, TV money, player salaries and prospects for teams in the upper and lower ranges.

(Note: the data is from 2015 but still pretty relevant to the situation today.)

MLB TEAMS Attendance Regional TV Money National TV Money Total TV Money Player salaries A'S 1,768,175 $ 41,000,000.00 $ 88,666,666.67 $ 129,666,666.67 $ 86,086,667 Angels 3,012,765 $ 118,000,000.00 $ 88,666,666.67 206,666,666.67 $ 150,933,083 Astros 2,153,585 $ 60,000,000.00 $ 88,666,666.67 148,666,666.67 $ 70,910,100 Blue Jays 2,794,824 $ 36,000,000.00 88,666,666.67 124,666,666.67 $ 122,506,600 Braves 2,001,392 $ 35,000,000.00 88,666,666.67 123,666,666.67 $ 97,578,565 Brewers 2,700,157 $ 24,000,000.00 88,666,666.67 112,666,666.67 $ 105,002,536 Cardinals 3,520,889 33,000,000.00 88,666,666.67 121,666,666.67 $ 120,896,458 Cubs 2,959,812 65,000,000.00 88,666,666.67 153,666,666.67 119,006,885 Diamondbacks 2,080,145 $ 50,000,000.00 88,666,666.67 138,666,666.67 $ 91,518,833 Dodgers 3,764,815 $ 204,000,000.00 88,666,666.67 292,666,666.67 $ 272,789,040 Giants 3,375,882 54,000,000.00 $ 88,666,666.67 142,666,666.67 172,672,111 Indians 1,288,905 40,000,000.00 88,666,666.67 128,666,666.67 $ 86,091,175 Mariners 2,193,581 $ 76,000,000.00 88,666,666.67 164,666,666.67 $ 119,798,060 Marlins 1,752,235 $ 20,000,000.00 $ 88,666,666.67 108,666,666.67 $ 68,479,000 Mets 2,569,753 $ 46,000,000.00 88,666,666.67 134,666,666.67 $ 101,409,244 un ur Nationals 2,619,843 46,000,000.00 88,666,666.67 134,666,666.67 $ 164,920,505 Orioles 2,379,294 $ 46,000,000.00 $ 88,666,666.67 134,666,666.67 $ 110,146,097 Padres 2,459,752 $ 39,000,000.00 88,666,666.67 127,666,666.67 $ 100,675,896 Phillies 1,831,080 $ 60,000,000.00 88,666,666.67 148,666,666.67 $ 135,827,500 Pirates 2,498,596 $ 25,000,000.00 $ 88,666,666.67 113,666,666.67 $ 88,278,500 Rangers 2,491,875 $ 56,000,000.00 $ 88,666,666.67 144,666,666.67 $ 142,140,873 Rays 1,247,643 $ 20,000,000.00 88,666,666.67 108,666,666.67 $ 76,071,707 Red Sox 2,880,684 $ 80,000,000.00 $ 88,666,666.67 168,666,666.67 $ 187,407,202 Reds 2,611,205 $ 30,000,000.00 88,666,666.67 118,666,666.67 $ 117,197,072 Rockies 2,506,789 20,000,000.00 88,666,666.67 108,666,666.67 $ 102,006,130 Royals 2,708,549 $ 22,000,000.00 88,666,666.67 110,666,666.67 $ 113,618,650 Tigers 2,726,048 55,000,000.00 88,666,666.67 143,666,666.67 $ 173,813,750 Twins 2,220,054 37,000,000.00 88,666,666.67 125,666,666.67 $ 108,945,000 White Sox 1,755,810 $ 51,000,000.00 88,666,666.67 139,666,666.67 $ 115,238,678 Yankees 3,233,682 $ 98,000,000.00 S 88,666,666.67 186,666,666.67 $ 219,282,196