Senior Project Day 8

Finished creating an excel spreadsheet for each player today. The task was long and monotonous, but well worth the time. Currently trying to experiment with Excel's functions. So far, I've noticed similar numbers amongst the players' decline. Two players had nearly the same % decline in Runs, Hits, Home Runs, Runs Batted In, Batting Average, Slugging Percentage, and On Base Percentage. Got super excited to see that as I did them back-to-back, but was a bit disappointed when the third player didn't follow that same trend, although Home Runs, Batting Average, and Slugging Percentage were still close to the first two. I'm learning a bit about regression analysis from the online statbook, trying to make sense of the numbers Excel spewed out for me. So far, I've been calculating averages of "declining years" comparing them to "peak/prime years" and measuring the percent decline between the two, in addition to calculating the Standard Deviation of the declining years averages and finding out how far percentage wise, the sum or difference of the average and the standard deviation is. My hope was that the standard deviation of the statistics would be similar across the board for all the players, but no such luck. Since the steroid users' stats increased rather than decreased during their so called "declining years" I'm hoping that using the decline of clean players can serve as a good model for declination.

Hank Aaron's Stats Over the Years

The folder containing all of the Excel Spreadsheets of every player.

Regression analysis on Excel...still trying to understand everything.

Mickey Mantle's Stat Analysis Page 1

Mantle's Stat Analysis Page 2

Mantle's Stat Analysis Page 3

Mantle's Stat Analysis Page 4

Mantle's Stat Analysis Page 5

Stan Musial's Stat Analysis Page 1

Musial's Stat Analysis Page 2

Musial's Stat Analysis Page 4

Musial Stat Analysis Page 5

Musial's Stat Analysis Page 6