Questions

1. Select Stat/ Summary Stats / Correlation.

Select all variables .Click 'Compute'.You should see what is called a "Correlation Matrix" (You don't need to provide the matrix ).

a. Look at the R( Runs Scored) column ( and/or row) .Which variable is most strongly positively correlated with Runs Scored and what is the value of the correlation coefficient?

b.Which variable has the strongest negative association with Runs Scored and what is the value of the correlation coefficient?

c. Produce scatterplots of Runs Scored ( R) (y axis response) vs. each of the variables from parts a and b (x axis explanatory).

Select Graph / Scatter Plot. Select the 2 variables for x and y and click compute.Provide the plots.

d. What is the variable with the weakest correlation (closest to 0 + or - ) with Runs Scored and what is the value of the correlation coefficient?

(Remember , weakest correlation does not meanmost negative).

Numbers File Edit Insert Table Organize Format Arrange View Share Window Help R G X T ) 79% Jul 25 11:23 TX Q E baseball (2) 110% Ev [+ v T D V E View Zoom Add Category Insert Chart Text Shape Media Comment Collaborate Format Organize Sheet 1 Sheet baseball (2) Sheet Name Tm W #Bat BatAge G PA AB R H 3 3B HR SB CS BB SO BA SLG GDP HBP SH SF IBB LOB OPS OBP ARI 50 26.7 162 6260 5665 752 1479 285 56 190 137 31 463 1427 0.261 0.432 93 2446 117 50 43 38 43 1113 75.2 Sheet 1 ATL 68 60 28.9 161 6192 5514 649 1404 295 27 122 75 34 502 1240 0.255 0.384 89 2119 145 59 64 52 60 1160 70.5 32.1 BAL 89 47 28.4 162 6089 5524 744 1413 265 6 253 13 468 1324 0.256 0.443 101 2449 119 76 31.7 93 112 2615 Background BOS 50 28.5 162 6320 5670 878 1598 343 25 208 83 24 558 1160 0.282 0.461 137 81 34.8 CHC 103 45 27.4 162 6335 5503 808 1409 293 30 199 66 34 656 1339 0.256 0.429 107 96 42 37 45 1217 77.2 34.300000000000000 CHW 78 50 28.3 162 6131 5550 686 1428 277 33 168 77 36 455 1285 0.257 100 2275 122 53 29 44 16 1105 72.7 31.7 Duplicate Sheet CIN 68 52 27.8 162 6094 5487 716 1403 277 33 164 139 51 452 1284 0.256 0.408 129 52 58 44 37 1014 72.4 31.6 CLE 94 48 28.9 161 6155 5484 777 1435 308 29 185 134 31 531 1246 0.262 0.43 96 2356 137 49 31 60 16 1084 75.9 32.9 Delete Sheet COL 75 47 27.8 162 6236 5614 845 1544 318 47 204 66 39 494 1330 0.275 0.457 97 2568 113 40 54 34 35 1089 79.4 33.6 DET 86 44 29.8 161 6127 5526 750 1476 252 30 211 58 29 493 1303 0.267 0.438 135 32 1105 76.9 33.1 HOU 84 43 26.6 162 6204 5545 724 1367 291 29 198 102 44 554 1452 0.247 0.417 103 2310 134 47 27 31 31 1086 73.5 31.900000000000000 KCR 81 42 28.6 162 6052 5552 675 1450 264 33 147 121 35 382 1224 0.261 0.4 90 2221 134 45 38 34 23 1049 71.2 31.2 LAA 74 53 28.5 162 6041 5431 717 1410 279 20 156 73 34 471 991 0.26 0.405 100 2197 147 51 36 49 21 1037 72.6 32.2 LAD 91 55 28.9 162 6164 5518 725 1376 272 21 189 5 26 525 1321 0.249 0.409 120 3 30 32 31 1106 72.8 31.900000000000000 MIA 79 53 28 447 1213 0.263 0.394 95 140 54 46 38 32.2 MIL 73 50 27.5 162 6061 5330 671 1299 249 19 194 181 56 599 1543 0.244 0.407 92 2168 131 37 53 39 34 1071 72.9 32.2 MIN 59 27 162 6245 5618 722 1409 288 35 200 91 32 513 1426 0.251 0.421 98 2367 96 44 27 43 24 1124 73.8 31.6 NYM 87 46 29.5 162 6115 5459 671 1342 240 19 218 42 18 517 1302 0.246 0.417 123 62 35 41 31.6 NYY 84 53 29.9 162 6059 5458 680 1378 245 20 183 72 22 475 1188 0.252 0.405 121 42 21 49 19 1098 72 31.5 OAK 69 51 28.7 162 6022 5500 653 1352 270 21 169 50 23 442 1145 0.246 0.395 91 2171 142 33 13 34 19 1036 69.9 30.4 PHI 71 49 26.9 162 5992 5434 610 1305 231 35 161 96 45 424 1376 0.24 0.384 83 2089 112 33 1043 68.5 30.100000000000000 PIT 78 55 28.9 162 6261 5542 729 1426 277 32 153 110 45 561 1334 0.257 0.402 133 33.2 SDP 68 58 28.1 162 6001 5419 686 1275 257 26 177 125 45 449 1500 0.235 87 2115 93 58 36 36 30 965 68.9 29.9 SEA 86 54 30.4 162 6227 5583 768 1446 251 17 223 56 28 506 1288 0.259 0.43 106 2400 138 29 1099 75.6 32.6 SFG 87 45 29.2 162 6271 5565 715 1437 280 54 130 79 36 572 1107 0.258 0.398 97 2215 120 42 42 46 43 1188 72.8 32.9 STL 86 41 28.5 162 6223 5548 779 1415 299 32 225 35 26 526 1318 0.255 0.442 104 2453 117 70 37 41 28 1113 76.7 32.5 TBR 68 48 27.7 162 6046 5481 672 1333 288 32 216 60 37 449 1482 0.243 0.426 100 2333 88 20 1060 73.3 30.7 TEX 95 52 28.4 162 6089 5525 765 1446 257 23 215 99 36 436 1220 0.262 0.433 96 2394 114 23 1038 75.5 32.2 TOR 89 30 162 6233 5479 759 1358 276 18 221 54 24 632 1362 0.248 0.426 153 55 26 40 16 1120 75.5 WSN 95 43 28.8 162 6201 5490 763 1403 268 29 203 121 39 536 1252 0.256 0.426 96 2338 102 49 1105 75.1 32.6 25 X P ZaloInsert Format Tools Table Window Help ()) 79% N DA 7 20 Base sign Layout References Mailings Review View Table Design Layout . Tell me Share co 11 " A A Aa Ap ab A A EVENEEVEEALT v X2 X|A VL A A EEEE V Styles Styles Dictate Sensitivity Pane X For thisyou will need to download the file 'baseball' This file contains MLB team offense stats for the 2016 season. Here is a data dictionary for the variables Tm Team #Bat # of players with at bats BatAge Mean age of batters G Team Games Played PA Plate Appearances AB Official at bats R Runs Scored H Hits 2B doubles 3B triples RBI Runs batted in SB Stolen Bases BB Walks SO Strike outs BA Team Batting average OBP On base percentage SLG Slugging OPS On base % + slugging OPS+ Adjusted OPS TB Total Bases earned GDP Double plays grounded into HBP Batters hit by pitch SH Sacrifice bunts SF Sacrifice flies IBB Intentional Walks LOB Runners left on base Ston 1 is to inland the file to Ctataminah Than a inlate the muactions halo