The attached contains stats for all MLB teams from two years. How do I use Excel to generate the correlations among these variables, create scatterplots representing the relationships between each variable (x-axis) and runs (y-axis) (Include the line of best fit in the scatterplots), and conduct a regression analysis in which runs scored is the dependent variable and the other six stats are the independent variables?

walks hr runs Team 28 steals slug % BAB-189 801 Minn 490 275 143 101 425 287 NYY 649 327 210 139 461 285 930 348 199 65 463 284 809 Toronto 514 558 351 55 457 280 870 Cleveland 198 502 291 236 93 464 280 868 Chiws 53 448 278 835 Texas 505 357 183 288 164 121 424 277 768 Baltimore 474 432 820 801 128 LA Dodgers 307 153 276 486 309 159 148 425 274 768 LA Angels Detroit 430 294 203 60 449 274 822 172 756 404 272 Dseattle 266 106 424 KC 474 336 124 65 411 271 757 561 157 85 433 270 846 Colorado 326 455 270 849 Atlanta 526 312 222 52 Boston 872 327 192 51 435 269 720 292 431 781 St. Louis 531 184 59 269 395 271 168 121 422 268 716 Chic Arizona 504 331 160 76 424 267 773 294 216 447 267 865 Philly 826 834 323 200 146 445 264 NYM 547 Florida 497 309 182 110 435 264 759 459 286 141 68 397 263 891 Pittsburgh 123 416 263 731 SO 564 208 161 Washington 504 322 164 123 418 262 746 175 60 260 Oakland 850 268 415 771 SF 494 297 163 58 422 259 746 BEXEM!W 502 301 180 71 420 258 730 124 432 257 749 Cincy 814 291 217 585 275 174 79 409 255 735 Houston 441 267 134 420 255 689 Tampa 190