The 2014-2015 Pairwise Predictor is LIVE
NEW! Click the link below to access the Pairwise Predictor online:
http://www.bcinterruption.com/2014/1...rwisePredictor
-------------------
I'm basically going to use this thread as my own personal excel spreadsheet playground. The posters poll will go here each week along with other fun things I'm doing using the spreadsheet I built last year to calculate the Pairwise.
Some things you'll see in here include:
--The weekly USCHO Posters Poll
--A few 'what-ifs' from the week that was (Would Lindenwood be a TUC had they not lost 14-0 to Minnesota? Will a win against Clarkson this weekend be enough to put Cornell at the top of the Pairwise? etc.)
--A conference tournament predictor, similar to what USCHO does on the men's side at the end of the regular season, that will calculate the season-ending Pairwise *exactly* given whatever results you plug in
--Any other fun things you or I can think of that I can run on an Excel spreadsheet
To kick things off, wwhyte asked me last night if it was possible for me to approximate a strength of schedule for each team based on their 2014-2015 schedule and last year's RPI numbers. It was, and I did, and here are the results.
A couple caveats:
--This is a VERY rough approximation, as it's running off last year's rankings, but that's obviously all we have. I could run this off any other ranking people want other than RPI (i.e. Rutter) but that's what I had readily available.
--For games where we don't know the final round matchup (Nutmeg Classic and Beanpot) I assumed that the higher-ranked teams win the first round games.
--Yale has a regular season game against Sacred Heart? I didn't have Sacred Heart's RPI so I just assigned them the same RPI as the last place team, Penn State. It doesn't make much of a difference anyway.
Also St. Lawrence being #1 makes you scratch your head until you realize they play Harvard, Cornell, Clarkson, and Quinnipiac in conference, and play BC, Mercyhurst, Robert Morris, Minnesota, twice *each* out of conference, plus another two with Clarkson.
---------
NEW! Click the link below to access the Pairwise Predictor online:
http://www.bcinterruption.com/2014/1...rwisePredictor
-------------------
I'm basically going to use this thread as my own personal excel spreadsheet playground. The posters poll will go here each week along with other fun things I'm doing using the spreadsheet I built last year to calculate the Pairwise.
Some things you'll see in here include:
--The weekly USCHO Posters Poll
--A few 'what-ifs' from the week that was (Would Lindenwood be a TUC had they not lost 14-0 to Minnesota? Will a win against Clarkson this weekend be enough to put Cornell at the top of the Pairwise? etc.)
--A conference tournament predictor, similar to what USCHO does on the men's side at the end of the regular season, that will calculate the season-ending Pairwise *exactly* given whatever results you plug in
--Any other fun things you or I can think of that I can run on an Excel spreadsheet
To kick things off, wwhyte asked me last night if it was possible for me to approximate a strength of schedule for each team based on their 2014-2015 schedule and last year's RPI numbers. It was, and I did, and here are the results.
Code:
Conf Rank SOS (Includes both conf. and non-conf. games) WCHA 1 0.5168 ECAC 2 0.4998 HEA 3 0.4904 CHA 4 0.4869 Team Rank SOS St. Lawrence 1 0.5268 St. Cloud State 2 0.5260 Minnesota State 3 0.5254 Bemidji State 4 0.5237 Minnesota-Duluth 5 0.5174 North Dakota 6 0.5174 Ohio State 7 0.5160 Wisconsin 8 0.5092 Princeton 9 0.5057 Dartmouth 10 0.5051 Cornell 11 0.5040 Harvard 12 0.5012 Lindenwood 13 0.5006 Minnesota 14 0.4994 Boston University 15 0.4994 Colgate 16 0.4993 Penn State 17 0.4991 Clarkson 18 0.4988 Northeastern 19 0.4949 Syracuse 20 0.4938 Brown 21 0.4936 Yale 22 0.4934 Quinnipiac 23 0.4932 Maine 24 0.4924 New Hampshire 25 0.4921 Boston College 26 0.4911 Rensselaer 27 0.4904 Providence 28 0.4898 Connecticut 29 0.4886 Union 30 0.4866 RIT 31 0.4785 Robert Morris 32 0.4768 Vermont 33 0.4752 Mercyhurst 34 0.4725
--This is a VERY rough approximation, as it's running off last year's rankings, but that's obviously all we have. I could run this off any other ranking people want other than RPI (i.e. Rutter) but that's what I had readily available.
--For games where we don't know the final round matchup (Nutmeg Classic and Beanpot) I assumed that the higher-ranked teams win the first round games.
--Yale has a regular season game against Sacred Heart? I didn't have Sacred Heart's RPI so I just assigned them the same RPI as the last place team, Penn State. It doesn't make much of a difference anyway.
Also St. Lawrence being #1 makes you scratch your head until you realize they play Harvard, Cornell, Clarkson, and Quinnipiac in conference, and play BC, Mercyhurst, Robert Morris, Minnesota, twice *each* out of conference, plus another two with Clarkson.
---------
Comment