Normalized & Scaled RAPM Chronology Spreadsheet
Posted: Wed Apr 2, 2014 3:26 am
Upon request I've put the normalized RAPM data I made using Engelmann's and acrossthecourt's data (thanks also colts18 and whoever else I'm forgetting). It is here:
https://docs.google.com/spreadsheet/ccc ... qaFE#gid=0
Things to note:
-"Normalized" means applied standard deviation to it to adjust for yearly difference for every time the algorithm was ran.
-I was motivated to put it all in a more readable format so I made sheets where each column represents data from a different year. So you can now see the overall RAPM data for a player for every year we have all on one row of one sheet. Same for offense, same for defense.
-Now that I've done this I'll probably add to it with some other things. One of which will be a scaled version where I de-normalize the data using the standard deviation from an APM study (Ilardi's 6 probably). Open to suggestions about better ways to do it that are still simple.
-Data is sorted by the last column "dumb sum" which simply adds up all the players numbers for all the years. I did this primarily so I could see all the heavy hitter at the top and note any data errors (I'm sure I didn't catch them all). It's a flawed way of ranking the players certainly, though I do think it's interesting to look at.
-I think the most useful way to look at data like this is to look for the general standard a player could regularly reach, rather than trying to go by peaks, or by tallying totals.
-Finally, some of this data no longer manages the number Engelmann has up, and I've held off on any '13 or '14 data simply because I haven't paid close enough attention to have confidence in them yet. I'm open to your feedback on updating the data. Obviously I got paranoid when Engelmann started on his xRAPM bender.
Let me know your thoughts.
Cheers,
Doc
https://docs.google.com/spreadsheet/ccc ... qaFE#gid=0
Things to note:
-"Normalized" means applied standard deviation to it to adjust for yearly difference for every time the algorithm was ran.
-I was motivated to put it all in a more readable format so I made sheets where each column represents data from a different year. So you can now see the overall RAPM data for a player for every year we have all on one row of one sheet. Same for offense, same for defense.
-Now that I've done this I'll probably add to it with some other things. One of which will be a scaled version where I de-normalize the data using the standard deviation from an APM study (Ilardi's 6 probably). Open to suggestions about better ways to do it that are still simple.
-Data is sorted by the last column "dumb sum" which simply adds up all the players numbers for all the years. I did this primarily so I could see all the heavy hitter at the top and note any data errors (I'm sure I didn't catch them all). It's a flawed way of ranking the players certainly, though I do think it's interesting to look at.
-I think the most useful way to look at data like this is to look for the general standard a player could regularly reach, rather than trying to go by peaks, or by tallying totals.
-Finally, some of this data no longer manages the number Engelmann has up, and I've held off on any '13 or '14 data simply because I haven't paid close enough attention to have confidence in them yet. I'm open to your feedback on updating the data. Obviously I got paranoid when Engelmann started on his xRAPM bender.
Let me know your thoughts.
Cheers,
Doc