Construct another scatter plot, using attendance as the dependent variable and final cap hit as the independent variable. Label the chart and axes, plot a linear trend line, and list the linear equation of the trend line on the chart.
i. Run a regression with attendance as the dependent variable and final cap hit as the independent variable. Explain the relationship between the variables and what the R2 means in this context.
ii. Run another regression that includes both final cap hit and points as independent variables. How would you interpret the results? Explain.
. . . X F30 X V fx 498957 S T F G H J V N O P R A B C D FinalCapHit- Pts LTIR USED FINAL CAP SPACE OTL Pts GF GA PIM Att. Coach Playoff Results TEAM FINAL CAP HIT Millions Team GP 103 18 192 16337 Bruce Boudreau Lost in round 1 Anaheim Ducks $63,966,477 $3.966477 103 $0 $7,433,523 Anaheim Ducks 82 209 245 13350 Dave Tippett Out of Playoffs Arizona Coyotes $60,694,296 60.694296 78 $0 $10,705,704 Arizona Coyotes 82 18777 Claude Julien Out of Playoffs 93 SO $691,555 Boston Bruins 82 WVNHA 240 230 OUDUN - Boston Bruins $70,708,445 70.708445 82 81 201 222 18541 Dan Bylsma Out of Playoffs Buffalo Sabres $61,725,492 $1.725492 81 SO $9,674,508 Buffalo Sabres 77 231 260 19146 Bob Hartley Out of Playoffs $69,033,457 69.033457 77 SO $2,366,543 Calgary Flames 82 Calgary Flames Carolina $61, 189,650 61.18965 86 $10,210,350 31 86 198 226 O 12204 Bill Peters Out of Playoffs Hurricanes Carolina Hurricanes Chicago 209 21860 Joel Quenneville Lost in round 1 $71,391,620 71.39162 03 $96,089 $104,469 235 Chicago Blackhawks 32 26 N 103 00 Blackhawks Colorado $64, 114,754 64. 114754 32 $0 $7,285,246 17032 Patrick Roy Out of Playoffs Colorado Avalanche 32 39 39 O 82 216 240 Avalanche Columbus Blue $67,954,553 67.954553 76 $C $3,445,447 32 34 10 76 219 252 14666 ichards, Tortorella {- Out of Playoffs 10 Columbus Blue Jackets Jackets 50 23 109 267 230 18377 Lindy Ruff Lost in round 2 IT Dallas Stars $69,830,919 69.830919 109 $1,569,081 Dallas Stars 32 Detroit Red 93 211 Lost in round 1 $1,766,539 30 93 224 Jeff Blashill O 20027 $73, 166,539 73.166539 82 41 12 Detroit Red Wings Wings Edmonton 68. 161741 $3,238,259 203 245 16841 Todd Mclellan Out of Playoffs $68, 161,741 70 $ Edmonton Oilers 32 31 43 DW Oilers $3,920,202 Florida Panthers 82 47 26 w w 103 239 203 15384 Gerard Gallant Lost in round 1 $0 Florida Panthers $67,479,798 67.479798 103 Los Angeles Lost in round 1 $71,942,857 71.942857 102 $542,857 $0 18274 Darryl Sutter 32 195 Los Angeles Kings 48 102 225 NW Kings 38 87 206 19827 Yeo, Torchetti {+} Lost in round 1 OUT Minnesota Wild $70,797,820 70.79782 87 $11,744 $613,924 Minnesota Wild Montreal 70.630776 32 $769,224 O 21288 Michel Therrien Out of Playoffs $70,630,776 Montreal Canadiens 82 38 38 w 82 221 236 17 Canadiens k w Nashville $9,396,695 96 O Peter Laviolette 62.003305 96 N 228 215 16971 Lost in round 2 18 $62,003,305 Predators Nashville Predators 82 41 27 New Jersey Out of Playoffs O $62,663,638 62.663638 84 $0 $8,736,362 15074 John Hynes New Jersey Devils 32 38 36 84 184 208 19 Devils U N New York $66,255,628 66.255628 100 $0 $5, 144,372 216 O 13627 Lost in round 2 32 232 Jack Capuano 20 Islanders New York Islanders New York 71.302341 101 $97,659 82 46 27 101 236 217 O 18006 Alain Vigneault Lost in round 1 21 $71,302,341 Rangers New York Rangers A N W V $6,347,482 O $65,052,518 65.052518 35 SO Ottawa Senators 82 38 35 85 236 247 18085 Dave Cameron Out of Playoffs 22 Ottawa Senators Philadelphia $70,605,293 70.605293 96 $166,697 $961,404 Philadelphia Flyers 82 41 27 19227 Dave Hakstol Lost in round 1 CO 96 214 218 0 23 Flyers Pittsburgh $73,751, 100 73.7511 104 $2,351, 100 $0 104 245 203 18551 ohnston, Sullivan {+Won Championship 24 Pittsburgh Penguins 82 48 Penguins 46 98 241 210 16747 Peter DeBoer Lost in Finals UT W D 25 San Jose Sharks $71, 151,220 71.15122 98 $46,824 $295,604 San Jose Sharks 82 Lost in round 3 07 $1,727,062 $0 St. Louis Blues 82 107 224 201 18451 Ken Hitchcock 26 St. Louis Blues $73, 127,062 73.127062 97 $1,952,428 97 227 201 O Lost in round 3 Tampa Bay 73.352428 Tampa Bay Lightning 32 31 19092 Jon Cooper w 27 $73,352,42 46 Lightning U N Toronto Maple $71,280,568 $36,644 $156,076 O Out of Playoffs 71.280568 Toronto Maple Leafs 82 29 42 198 246 19158 Mike Babcock 28 Leafs ancouver $73,012,410 73.01241 75 $1,612,410 0 18431 Willie Desjardins Out of Playoffs 20 Vancouver Canucks 82 31 38 75 191 243 Canucks Washington 18511 Barry Trotz Lost in round 2 $70,935,215 70.935215 120 $34, 172 $498,957 56 18 120 252 193 30 Washington Capitals 82 OC W N Capitals 32 35 20 78 215 239 15294 Paul Maurice Out of Playoffs 31 Winnipeg Jets $59,793,795 59.793795 78 $0 $11,606,205 Winnipeg Jets Sheet1 (+ 10:18 PM me W X Type here to search O 1/26/2021
