Computer Tech Post #6 – Final Spreadsheet Lesson

Yesterday we were assigned our third and last spreadsheet lesson. What we have to do is add data to one of the google sheets that has a chosen topic. The topic that I chose out of the others was the NY Yankees’ and Mets’ home runs. I added a formula, function, and chart to it. The formula I made was to find the total home runs hit every year, and the function I made was to find the average home runs hit between the two teams every year. This was interesting because it seemed to me that the closer it is to modern day, the greater the total and average home runs got. The Mets were founded much later than the Yankees, so starting in 1962, there were two teams that made the total and average, not one. Although, also, as years passed by, the Yankees and Mets started hitting more home runs. in 1913, the Yankees only hit 8 home runs, but later in 2009 they hit 244! I think this is because one, today there are more games played, and two, the game was invented long ago, so it evolved and the way it’s played changed.

This is the chart made using Google Sheets based on the data collected:

(It might be hard to see)