• Google+

FanPost

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

Stay connected for news and updates

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.

There are 0 Comments. Add Yours. Loading

Shortcuts to mastering the comment thread. Use wisely.

C - Next Comment
X - Mark as Read

R - Reply
Z - Mark Read & Next

Shift + C - Previous
Shift + A - Mark All Read

Comment Settings

Live comment alert: Hide it!

Comments for this post are closed.