Mayo/Law/BA Top 100 Prospects Composite Averages (Spreadsheet)

Say thanks to J.P.!

Cheers.

https://docs.google.com/spreadsheet/ccc?key=0AljWfphmotrRdGhzNDBmV3JPWFNmSjdsVUllZnhZQ1E&usp=sharing

Should be a viewable public document. If anyone knows how to embed a spreadsheet or Google Docs Spreadsheet in a thread, let me know.

Awesome list, thanks! Just as a matter of curiosity, if a player isn't in someone's top 100, shouldn't you mark them as ranked 101? That way the averages aren't skewed. So, for example, Corey Seager is ranked #46 by one, but unranked by the other two. Thus, his composite ranking isn't 46. It is at best 83.3 (assuming he is #101 for the other two guys). On the other hand, it isn't like anyone is likely to get confused by the average ranking, since we all seem to be smart dudes who can read a chart.

I dunno, I just took a statistical analysis of the law class, so my sensitivity to minute chart accuracy is like whoa.

It is odd to me the divergence where you'll have Seager effectively top 50 for one, and not evern topp 100 for the others. Odd.

VandyDan said:

Awesome list, thanks! Just as a matter of curiosity, if a player isn't in someone's top 100, shouldn't you mark them as ranked 101? That way the averages aren't skewed. So, for example, Corey Seager is ranked #46 by one, but unranked by the other two. Thus, his composite ranking isn't 46. It is at best 83.3 (assuming he is #101 for the other two guys). On the other hand, it isn't like anyone is likely to get confused by the average ranking, since we all seem to be smart dudes who can read a chart.

I dunno, I just took a statistical analysis of the law class, so my sensitivity to minute chart accuracy is like whoa.

It is odd to me the divergence where you'll have Seager effectively top 50 for one, and not evern topp 100 for the others. Odd.

Click to expand...

I had the exact same idea about adding the "101 assumed ranking". It tidys up the list a bit.

Also, I personally would like to have it sorted by those averaged scores; but that's just me.

It's an awesome tool.

So whom with a Gmail account wants GoogleDocs editing access so they can add to it?

Jonathan Mayo just posted his version of this same premise (looks better than mine) --


B3: Big, Bald and Beautiful

A conglomorate Top 100
By now many top prospect lists are out there. And while I’m confident in my abilities as a prospect reporter and feel that MLB.com’s Top 100 is pretty darn good, I also don’t pretend to think that it’s the only list worth looking at.

I like to comparison shop, too, and see what other people are doing. Such an exercise could go on endlessly as it seems more and more Top 100 type lists are popping up all over the interwebs. For the purposes of this post, I’m taking MLB.com’s, Keith Law’s at ESPN and, of course, Baseball America’s. (Warning: You’ll need subscriptions to access some of that stuff). Now, before you get all miffed that I didn’t include one list or another — this isn’t meant as a slight towards anyone’s list. These are simply the other two lists that I, personally, look forward to seeing the most each year and I like to see how we compare. I’ve dumped the rankings into a spreadsheet and came up with an average rank for each player that we’ve listed. For any player that wasn’t listed in one of the top 100 lists, I gave him a 101 ranking for that list. Make sense?

Before I get to the averages, a couple of notes:

A total of 78 players appeared on all three Top 100s. Shows you we’re all dealing with the same names, more or less.
Including the threepeats mentioned above, 95 total players were mentioned on two of the three lists.
A grand total of 121 players appeared on at least one list.
The highest ranking player on the MLB.com list not to appear on all three is Rymer Liriano of the Padres. The highest player on Keith Law’s list not to appear on all three is Corey Seager of the Dodgers. Andrew Heaney of the Marlins is the first player on the BA list not to appear on all three.
The first player to appear only on MLB.com’s list and not the other two is Ethan Martin of the Phillies. On Keith’s list, it’s Seager. And on the BA list, it’s Lance McCullers.
OK, with that context, here’s how the prospects would rank by their averages (Jurickson Profar is the consensus No. 1):

1 Jurickson Profar SS TEX
2.33 Dylan Bundy RHP BAL
2.67 Oscar Taveras OF STL
4 Wil Myers OF TB
8 Gerrit Cole RHP PIT
9.33 Jose Fernandez RHP MIA
10.67 Miguel Sano 3B MIN
10.67 Zack Wheeler RHP NYM
10.67 Taijuan Walker RHP SEA
11 Xander Bogaerts SS BOS
11.33 Tyler Skaggs LHP ARI
11.33 Christian Yelich OF MIA
14.33 Travis d’Arnaud C NYM
16.33 Francisco Lindor SS CLE
17 Byron Buxton OF MIN
17.33 Shelby Miller RHP STL
18 Jameson Taillon RHP PIT
18.33 Mike Zunino C SEA
18.67 Trevor Bauer RHP CLE
20.33 Billy Hamilton OF CIN
21 Javier Baez SS CHI
22.33 Carlos Correa SS HOU
25 Anthony Rendon 3B WAS
26 Archie Bradley RHP ARI
26.67 Nick Castellanos OF DET
28.33 Kyle Zimmer RHP KC
28.67 Jonathan Singleton 1B HOU
29.67 Kevin Gausman RHP BAL
34.33 Jackie Bradley OF BOS
34.33 Julio Teheran RHP ATL
35 Albert Almora OF CHI
35.33 Bubba Starling OF KC
35.33 Addison Russell SS OAK
36 Mason Williams OF NYY
36.67 Carlos Martinez RHP STL
37 Gary Sanchez C NYY
37.67 Danny Hultzen LHP SEA
38.33 Mike Olt 3B TEX
39.33 Jorge Soler OF CHI
39.67 Aaron Sanchez RHP TOR
45 Chris Archer RHP TB
46 George Springer OF HOU
46.67 Trevor Rosenthal RHP STL
49.67 David Dahl OF COL
49.67 Alen Hanson SS PIT
50 Max Fried LHP SD
50 Kaleb Cowart 3B LAA
51 Taylor Guerrieri RHP TB
51.67 Robert Stephenson RHP CIN
52.33 Matt Barnes RHP BOS
52.67 Kyle Gibson RHP MIN
53.33 Alex Meyer RHP MIN
55.33 Brian Goodwin OF WAS
55.67 Austin Hedges C SD
57 Gregory Polanco OF PIT
58 Casey Kelly RHP SD
60 Noah Syndergaard RHP NYM
61 Allen Webster RHP BOS
63.67 Jedd Gyorko 2B SD
64.33 Oswaldo Arcia OF MIN
65 Nick Franklin SS SEA
65.67 Courtney Hawkins OF CWS
68 Tyler Austin OF NYY
68.33 Jake Odorizzi RHP TB
68.67 Wily Peralta RHP MIL
70 Rymer Liriano OF SD
71.67 Nolan Arenado 3B COL
72 Jake Marisnick OF MIA
72.67 Lucas Giolito RHP WAS
73 Aaron Hicks OF MIN
73.33 Justin Nicolino LHP MIA
73.67 Slade Heathcott OF NYY
74.67 Yasiel Puig OF LAD
74.67 Hak-Ju Lee SS TB
75 Andrew Heaney LHP MIA
76 Kyle Crick RHP SF
80 Matt Davidson 3B ARI
81.33 DiDi Gregorius SS ARI
81.67 James Paxton LHP SEA
81.67 Jesse Biddle LHP PHI
82 Tony Cingrani LHP CIN
82 Yordano Ventura RHP KC
82 Zach Lee RHP LAD
82.67 Arodys Vizcaino RHP CHI
82.67 Corey Seager 3B LAD
84 Lance McCullers RHP HOU
84 Jonathan Schoop 2B BAL
86 Dorssys Paulino SS CLE
86.33 Kolten Wong 2B STL
86.67 Michael Wacha RHP STL
87 Adam Eaton OF ARI
87.67 Luis Heredia RHP PIT
89 Daniel Corcino RHP CIN
89 Eddie Rosario 2B MIN
89.67 Martin Perez LHP TEX
92 Avisail Garcia OF DET
92 Jarred Cosart RHP HOU
92.33 Marcell Ozuna OF MIA
92.67 Roberto Osuna RHP TOR
92.67 Cody Buckel RHP TEX
93.33 Trevor Story SS COL
93.67 A.J. Cole RHP WAS
94 Clayton Blackburn RHP SF
94 Ethan Martin RHP PHI
94.33 Delino DeShields 2B HOU
94.33 Alex Colome RHP TB
94.67 Adeiny Hechavarria SS MIA
95.33 Henry Owens LHP BOS
95.33 Luis Sardinas SS TEX
95.67 Joc Pederson OF LAD
96 J.R. Graham RHP ATL
96 Bruce Rondon RHP DET
96.67 Joe Ross RHP SD
96.67 Jorge Alfaro C TEX
98 Adam Morgan RHP PHI
99.33 Jose Iglesias SS BOS
100 Marcus Stroman RHP TOR
100.33 Nathan Karns RHP WAS
100.67 Roman Quinn SS PHI
100.67 Eduardo Rodriguez LHP BAL
100.67 Gary Brown OF SF