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
Connect with Black Shoe Diaries