False Parity as a Graph

Because I like to mess around with Excel, I found myself making graphs of teams' win-percentages in relation to their place in the standings. But a funny thing happened. 

Let me back up for a moment. I have a little spreadsheet that tracks the W% of each team using three different point systems. (1) the current system; (2) a system in which there is no OT and every game ends in regulation, as a W, L or T; (3) a system in which there is OT and SO, but losers get zero points (i.e. no ties, no loser points, just wins and losses). That chart looks like this:

  W-L-OTL pts W% W-L-T pts W% diff W-L pts W% diff OTR
VAN 35-10-9 79 0.731 31-10-13 75 0.694 -4 35-19 70 0.648 -9 4-9
DET 32-15-6 70 0.660 23-15-15 61 0.575 -9 32-21 64 0.604 -6 9-6
DAL 30-18-5 65 0.613 22-18-13 57 0.538 -8 30-23 60 0.566 -5 8-5
SJS 28-19-6 62 0.585 23-19-11 57 0.538 -5 28-25 56 0.528 -6 5-6
NAS 28-19-7 63 0.583 22-19-13 57 0.528 -6 28-26 56 0.519 -7 6-7
ANA 29-21-4 62 0.574 23-21-10 56 0.519 -6 29-25 58 0.537 -4 6-4
PHX 27-19-9 63 0.573 25-19-11 61 0.555 -2 27-28 54 0.491 -9 2-9
MIN 27-20-5 59 0.567 22-20-10 54 0.519 -5 27-25 54 0.519 -5 5-5
LAK 29-22-2 60 0.566 22-22-9 53 0.500 -7 29-24 58 0.547 -2 7-2
CGY 27-21-7 61 0.555 19-21-15 53 0.482 -8 27-28 54 0.491 -7 8-7
CHI 27-22-4 58 0.547 22-22-9 53 0.500 -5 27-26 54 0.509 -4 5-4
STL 23-20-8 54 0.529 18-20-13 49 0.480 -5 23-28 46 0.451 -8 5-8
CBJ 25-22-5 55 0.529 17-22-13 47 0.452 -8 25-27 50 0.481 -5 8-5
COL 25-22-6 56 0.528 17-22-14 48 0.453 -8 25-28 50 0.472 -6 8-6
EDM 16-29-8 40 0.377 13-29-11 37 0.349 -3 16-37 32 0.302 -8 3-8


OTR is OT/SO combined record. DIFF is the difference between that system and the current one. The colors reflect whether that system helps or hurts that team, compared to the current system. 

Every time I look at this chart, I see something new and interesting. For example, look how many teams are in the red (under W%) in the non-Bettman point systems. In the second system (WLT), everyone is significantly worse off, except the basement dweller EDM, who is only a little worse off. In the third system, all but three teams in the current playoff race take huge hits (the Kings are the lone benefactors; they leap from 9th to 4th). In the other systems, the teams sitting in 9th-14th go from all of them being in playoff contention, to only 2 (in the second) or 4 (in the third). 

But, like I said, the graphs are what surprised me. 


[click on the image for a higher-res version]

These three graphs each show the three systems; the difference is how the x-axis is sorted. In the first graph, it's sorted by W% in the current system. 


What leaps out at me is this: look how flat the blue line is, especially in the middle. That is the graph of the W%s in the current system. The middle is the contested 5-12 seeds. It's close to a plateau (it wouldn't be a perfectly horizontal line unless every team was tied in points -- a.k.a. Bettman's wet dream). Now let's look at a second graph, in which the x-axis is sorted by the W% of the second system (WLT, no Bettman point).


We've sorted by the red line this time (the WLT system). The slope is more precipitous and bumpy. That's because there is less of a cluster of points and more of a drop-off between seeds. In other words, less parity. Now, a third graph. This one sorts by the third system (keeps the OT and SO, but records wins and losses only, no Bettman point).


We've sorted by the green line this time. It's smoother than the red line in graph #2, but more precipitous than the blue line of graph #1. In other words, there is an increased point difference from seed to seed, but the rate of change is more constant. I would have to think about this a little more, but my first stab at an interpretation is that, by adding in the OT and SO, it smoothes out the bumps (why I don't know) but doesn't artificially create "parity."  Parity would be the flat-ish horizontal line, which is seen only in the first graph. 

Bonus chart: this one shows the variance for each team under the three different point systems. The x axis represents the systems, the y axis represents place in the standings. The fifteen lines are the fifteen teams. The color key on the right is a little hard to read (click on the image for a better version), but the lines are sorted by rank in the current system, VAN on top, EDM on the bottom.


The top and the bottom are flat lines. That's because, in every system, the top two seeds and the bottom seed stay the same. The middle 12 teams, however, are all over the place. Two teams cross over the 8th/9th barrier (going from playoff team to non-playoff team, or the other way around), the Kings line shoots up; the Coyotes line shoots down. And the biggest snarl occurs around the 7th seed. Which (I think) means that -- at the very place in the standings where the haves are divided from the have-nots -- whether you "have" or "not" is capriciously system-dependent. 

Log In Sign Up

Log In Sign Up

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 Jewels From The Crown

You must be a member of Jewels From The Crown to participate.

We have our own Community Guidelines at Jewels From The Crown. You should read them.

Join Jewels From The Crown

You must be a member of Jewels From The Crown to participate.

We have our own Community Guidelines at Jewels From The Crown. You should read them.




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.