Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 ~ A" A " ab Wrap Text v General Insert v Ex AP - O. Ex Delete v Paste BIUV E Merge & Center v $ ~ % 9 08 28 Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format Filter Select Data H29 * X V fx B C D E F G H 1 K L M N 0 P Q R S T U V W X Home Average Home Games attendance Win % 1 LA Dodgers 81 49,065 0.654 2 St. Louis 81 42,967 .56 3 NY Yankees 79 41,827 0.636 4 Chicago Cubs 81 38,208 0.519 5 LA Angels 81 37,321 0.444 6 Colorado 81 36,953 0.43 7Boston 81 36,106 J.51 1. The MLB page has 2019 average attendance and team win percentage for all 30 Major League Baseball teams. 10 8 Milwaukee 81 36,090 0.549 What is the correlation between home attendance and win %? 9 Houston 81 35,276 .66 10 Philadelphia 33,671 0.500 2. Using the MLB data, create an XY scatterplot for Average Home attendance and win %. Insert a trend line. 11 San Francisco 81 33,429 0.475 Which team's observation seems to be the biggest outlier (i.e. farthest away from the trend line)? 12 Atlanta 81 32,776 0.599 [Hint, if you hover over the point, excel will tell you the values and you can check that against the data to see which team it corresponds to.] 15 13 NY Mets 80 30,531 0.531 16 14 San Diego 81 29,585 0.43 17 15 Minnesota 81 28,322 0.62 18 16 Washington 81 27,898 0.574 19 17 Arizona 81 26,364 0.525 20 18 Texas 81 26,333 0.481 21 19 Cincinnati 81 22,329 0.463 22 20 Seattle 81 22,122 0.420 21 Cleveland 79 22,00 0.574 24 22 Toronto 81 21,606 0.414 25 23 Chicago White Sox 76 21,442 0.44 26 24 Oakland 81 20,521 0.599 27 25 Detroit 80 18,767 0.292 28 26 Kansas City 18,495 .36 29 27 Pittsburgh 81 18,412 0.426 30 28 Baltimore 80 16,347 0.333 31 29 Tampa Bay 80 14,734 0.593 32 30 Miami 10,016 0.352 33 34 35 Uber MLB Quiz Question Data Server Dentist Carnival Mack Anderson Corp +