Discovering Data
  • Home
  • Blog

The Olympic medal table - alternative version

8/26/2016

0 Comments

 
The Olympic medal table was not that surprising, bigger richer countries get more medals than smaller countries. The top ten from a few days before the closing ceremony was:

   United States 
   Great Britain  
   China 
   Russia 
   France 
   Germany  
   Japan  
   Italy 
   Australia  
   Netherlands 

I wanted to calculate medal results per capita so I converted the medals won into medal points,  gold = 3 points, silver = 2 and bronze = 1 and calculated the total for each country. I then divided that total by the population of each country to obtain a list of medal points per head of population. This produces a list in which it is almost impossible for large countries to get into the top ten. I think it is a less predictable and so a more interesting list:

   Bahamas  
   New Zealand  
   Jamaica 
   Bahrain  
   Fiji 
   Croatia 
   Armenia 
   Hungary  
   Denmark 
   Georgia

Producing this list required some web scraping to get the medal table and UN estimates of populations see here for an example from my code blog showing how to scrape a table from a web page. The actual calculations were done in Excel - it is easy to look down on Excel but it is quick and easy to use in some limited situations.
0 Comments



Leave a Reply.

    Archives

    June 2018
    December 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016

    RSS Feed

Proudly powered by Weebly
  • Home
  • Blog