uhm, there must be something wrong in that chart.
I read on chessbase that being USCF 2000 means being in the 99 percentile. It's not possible that for FIDE the mean is around 2000 like showed in the chart.
Think about it, it's not possible there there's the same number of 1600s and 2400s...just walk into any chess club.
Guys,
I would like to create an excel sheet in order to find out the FIDE rating distribution. Something similar to the below picture
Data that should be used can be found here: Download full list of players (not rated included) STD, RPD, BLZ combined(XML) (Updated: 30 Nov 2012, Size: 8 536 363 bytes)
Here is a topic with something similar but the data is from 2009: rating distribution topic. He was kind enough to provide a link to the excel file that he used.
The problem is that excel allows only 65k fields and since there are more chess players than this number I don't know how to put all the data from the .txt file mentioned above in an excel file.
I'm not that good at excel so I would appreciate your help.
Thanks