FanPost

Take 2: Comparing how teams did against their opponents' averages

I changed the spreadsheet.  There isn't any new data, but I added a function to calculate the values.  This makes the formulas on the spreadsheet simpler, but adds more processing behind the scenes.  What does this mean to you?  If you just want to see the deltas for the teams that were listed before, you don't need to get the new copy.  There isn't any new data.  If you want to be able to add more teams or other stats, it is much easier to do now.  There are notes at the bottom of the spreadsheet describing how to add things.

 

Thanks for all the comments on the original fanpost (http://www.blackshoediaries.com/2008/12/17/695763/comparing-how-teams-did-ag).  I realize this doesn't give you an exact comparison of different teams.  I'm hoping it could be a starting point for getting others to consider how distorting some straight stats are without a reference point.  If somebody wanted to play with the function to use standard deviations, etc. that would be great, but I'm not planning to do that.  By adding the function and simplifying the data on the spreadsheet, I hoped to make that easier for someone else to do.

 

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.

X
Log In Sign Up

forgot?
Log In Sign Up

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior users will need to choose a permanent username, along with a new password.

Your username will be used to login to SB Nation going forward.

I already have a Vox Media account!

Verify Vox Media account

Please login to your Vox Media account. This account will be linked to your previously existing Eater account.

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior MT authors will need to choose a new username and password.

Your username will be used to login to SB Nation going forward.

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