Dennisnet.org

Olympic medals by population

by on Aug.09, 2012, under . Qlikview


China is doing great at the Olympic games.  36 gold medals and 77 in total. Also the United States of America has an impressive score with 82 medals sofar.

Does these numbers make these countries the best sports countries in the world? If you only look at the Olympic medals standing you would say yes. But what if you consider that China has 13 billion inhabitants and New Zealand only has 4 million to select there athletes from.

In my opnium you should also consider the amount of inhabitants if you want know how a country is performing comparing to other countries.

I was curious what would happen if you would make an Olympic medals standing based on the population size.
To achive this  I used Qlikview to combine data from countrycode.org and the Olympic medal standings from Wikipedia to be able to follow this during the tournement. This results in a totally different Medal Standing.

The charts below shows how the Medal Standing will look if you divide the medals (gold,silver,bronze) by the population (showing countries with more then 10 medals)

Then it is Hungary with 8 gold medals and  not even 10 million inhabitants the best. Also New Zealand with 3 gold medals with only 4 million peolpe is much more impressive then 36 gold medals with 13 Billion Chinese.

From the same website I combined the square kilometers with the medals per country. This way it is easy to show the medals compaired to the size of the country. This results in the following charts.

 

“Waar een klein land groot in kan zijn” :-)

:, , ,

2 Comments for this entry

Leave a Reply

Laatste reacties

Dennis Hoogenboom on Kabalebo Deel 1: Nature resort
26th Mar 13
Hi Dulcy, geen probleem, mits in overleg en met vermelding van mijn naam/website. :)
mathematische Suchmaschinenoptimierung on Olympic medals by population
24th Mar 13
You're in point of fact a excellent webmaster. The site loading velocity is amazing. It kind of feels that you're …
Aquarium Glaser:Поставки аквариумных рыб из Германии! on Olympic medals by population
18th Mar 13
I am no longer positive where you are getting your information, however great topic. I must spend a while finding …
Dulcy on Kabalebo Deel 1: Nature resort
28th Feb 13
Beste Dennis, ik heb vol bewondering naar jullie vakantiefoto's gekeken. wat een prachtige foto's. Echter mijn vraag aan jullie is, …
Berend on Fantasy Premier League
15th Feb 13
Leuke pagina
michel hadik on Qlikview gekoppeld aan Google Maps
4th Jun 12
Hai Dennis, Begrepen dat jij expert bent in qlikview. Kan je eens contact met mij opnemen ? gr michel




Vriendjes

Bezoek ook eens...

  • Tancha
  • Wilco

Qlik

Qlikview / Qlik Sense

Tips

Kijk ook eens hier...

  • GeekFM