FanPost

Comparing how teams did against their opponents' averages

I wondered how to make more sense of some of the statistics we see when people try to compare teams that don't play each other.  I thought it would be interesting to see how a team did compared to what that team's opponents averaged.  What I mean is that if a team averages 150 rushing yards a game against teams that average giving up 100 rushing yards a game, that is more impressive than averaging 175 yards rushing a game against teams that average giving up 200 yards rushing a game.  So, anyway, I did a first cut at a spreadsheet that compares yards passing, yards rushing and points for both offense and defense for some of the top teams.  I found the results interesting.  USC's defense is more impressive than I thought it would be.  I plan to make some changes to how I calculate the values to make it easier to work with, but I posted what I have so far.  Please reply if you have any questions or comments.

As an Excel spreadsheet: http://home.comcast.net/~elihurozen/delta.xls

As a web page: http://home.comcast.net/~elihurozen/Delta.htm

You created a Fanpost! Good for you! Any content from a premium site will be deleted once we catch wind of it--as will any inappropriate content. If you simply want to share a link, quote, or video, please consider using Fanshots instead.