I'm learning to use Google Charts API in order to play around with data from UNODOC statistics. I found this excel file providing information about homicide count and rates from countries in the world in the years 2000-2013. It shows a count of homicide and rate for every country, and I'd like to produce a clear and meaningful visualization comparing the count and the rate of one random country (USA for example), in an insightful way (may be it won't be possible to provide insight, but at least I'd like to compare the percentage with the count without generating confusion).
And one more thing...
One doubt that struck me when looking at the excel table is: how is the percentage calculated? In the U.S.A., the count homicide in 2000 was 15586 per 100000 population, that would make a ~15% percentage, but instead I find a 5.5%. How was that calculated?
I hope that this is the right place to ask such questions!