Using Sports Data

This activity is best used after teaching students how to complete math operations in a spread sheet. I find sports data to be a great way to demonstrate some of the power of a spreadsheet. The data in these tables is current as of June 8, 2009. You can update the data by using the stats menu at Major League Baseball's web site.

Earned Run Average

Pitcher-----------Runs-------Earned Runs-------Innings Pitched --------e.r.a.
Dempster-----------38-----------------34--------------------74.3-------------
Zambrano----------25------------------23-------------------55.6-------------
Lily------------------28-----------------26--------------------71.3------------
Floyd---------------46-----------------44---------------------76--------------
Danks--------------36------------------34--------------------60--------------
Buehrle-------------25-----------------24--------------------74.3-------------
Weaver-------------20-----------------19---------------------79.6------------
Greinke-------------19-----------------15---------------------87--------------
Halladay-----------30-----------------28--------------------100--------------

e.r.a. = (# of earned runs/innings pitched)*9

On-base percentage

Player----------At Bats-------BB-------(SF)-------Hits-----hp-------On-base %
Pujols------------192---------44---------5-----------64---------3----------
Molina-----------170---------28---------2-----------44---------1----------
Schumaker----187----------14---------1-----------55---------0---------
Fukudome-----155---------47---------1-----------45----------2----------
Soriano----------224---------19---------1-----------54---------2----------
Theriot----------206---------17----------1-----------60--------4----------
Konerko---------202---------18---------6-----------60--------2---------
Thome----------152----------34---------1------------37--------0---------
Dye--------------187----------19---------2-----------52--------1---------

BB = base on balls, SF = sacrifice fly, hp = hit by pitch

OBP = (Hits + BB + HBP)/(AB + BB + HBP + SF)