Black Shoe Diaries: An SB Nation Community

Navigation: Jump to content areas:


Pro Quality. Fan Perspective.
Login-facebook
New Blog: The Nova Blog for Villanova Fans!

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

Thanks for the fanpost! Please do not post any content from a premium site that requires a subscription. Also, if you just want to share a link consider using fanshots instead. Thanks.

0 recs  |  Comment 0 comments

Story-email Email Printer Print

Comments

Display:

Comments For This Post Are Closed


User Tools

Welcome to the SB Nation blog about the Penn State Nittany Lions.
Start posting about the Nittany Lions »

Join SB Nation and dive into communities focused on all your favorite teams.

Connect_with_facebook

FanPosts

Community blog posts and discussion.

Recent FanPosts

1018081638_small
We Need One
Dollar_small
Selection anger
Licking_lips_small
BSD Tournament Challenge
Small
2010 Roster up on gopsusports.com
Arts_fest_2009_023_small
Vote for Cappelletti in the B10's Icon poll, earn 10K for Alumni Association
Img110_small
SPRING BREAK!
Iowa_girls_06_small
The return of the AFL (and a Penn State legend)
Fa_small
Baseball Loses 17-3 to A&M
Small
Notre Dame AD Says Football Conference on the Table
Dollar_small
Maybe we will be awesome soon?

+ New FanPost All FanPosts >

SPONSORS

SBNation.com Recent Stories

geeeeeno +1 updates

The 2010 NCAA Women's Basketball Bracket Is Set

Duke students cheer prior to Duke's matchup with North Carolina in an NCAA college basketball game in Durham, N.C., Saturday, March 6, 2010. (AP Photo/Gerry Broome)

Bracketology FAIL: How The NCAA Tournament Selection Committee Botched The Field

Iowa coach Todd Lickliter calls to his team from the sidelines in the first half against Illinois in an NCAA college basketball game Tuesday, Jan. 5, 2010, in Champaign, Ill. (AP Photo/Heather Coit) +1 updates

Iowa Makes It Official: Fires Todd Lickliter As Basketball Coach

More from SBNation.com >


Managers

Lioneye_edited_small BSD

Editors

Image_small Run Up The Score

Reporter_small Kevin HD

Official Partner of CBS Sports