Navigation: Jump to content areas:


Pro Quality. Fan Perspective.
Login-facebook
Around SBN: Explaining Jeremy Lin's Early, Surprising Success

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, quote, or video, please consider using fanshots instead. Thanks.

Comment 0 comments  |  0 recs  | 

Do you like this story?

Comments

Display:

Comments For This Post Are Closed


User Tools

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

FanPosts

Community blog posts and discussion.

Recommended FanPosts

Niceshoes_small
I know I said I only wanted to say this once...
Crystal_ball_small
Untarnished
Small
Ignorance Still Reigns...And I'm Not Letting It Pass
Joe_small
Sanctimonious Hypocrites Can't Diminish the Warmth for Joe Paterno
Psukoolaid_small
BSD Donations to THON in Joe’s Memory.

Recent FanPosts

333548_10150603261640663_143212655662_11113964_892862173_o_small
Junior DAY
Small
Moving On – This will be just the third Offensive System I’ve Seen at Penn State
Tipoffbasketball_t_small
2013 SF Brandon Austin commits to Penn State
Jessedotsmom_small
Food for Thursday: The Valentine's Day Edition.
Lion2_small
Penn State – the 2nd private school in the B1G?
Hugh_griffith_small
My Theory on Space, Time, Imaginary Numbers and Super Bowl Rings.
Kool-aid-man__small
Where's the love for Sukay?
Tom_mairs_photo_small
BoT Nominee: Ron Nervitt '62 Eng
Img110_small
BSD Want Ads - Prominent Penn State Blog Seeks Additional Recruiting Analyst

+ New FanPost All FanPosts >

SHOP THE BLACK SHOE DIARIES STORE

Gameday Depot University Apparel


Managers

Blog_gang_sign_small Chris Grovich

Powers1_small Kevin Powers

Editors

Zn_avatar_small Mike Pettigano

Img110_small Jeff Junstrom

Authors

Iron_armor_small Galen

New4_good_small Nick Blonde

Turd_ferguson_psu_small Tim Aydin

6a00d8341c630a53ef0105369fb7ee970b-800wi_small whiteout1

On_the_way_to_grad_small Kyle_Martin

N53100510_31463067_5584_small Adam Collyer

Aquateen_vol1_mastershake_1__small Ben Jones

Penn_state_mascot_small Peter Gray

Baller_small Eric Gibson

Small kmplatt