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! Any content from a premium site that requires a subscription will be deleted once we catch wind of it. If you simply want to share a link, quote, or video, please consider using Fanshots instead. Thanks.

SB Nation Featured Video
X
Log In Sign Up

forgot?
Log In Sign Up

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

By becoming a registered user, you are also agreeing to our Terms and confirming that you have read our Privacy Policy.

Join Black Shoe Diaries

You must be a member of Black Shoe Diaries to participate.

We have our own Community Guidelines at Black Shoe Diaries. You should read them.

Join Black Shoe Diaries

You must be a member of Black Shoe Diaries to participate.

We have our own Community Guidelines at Black Shoe Diaries. You should read them.

Spinner.vc97ec6e

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9347_tracker