Competitive Analytics | Interactive London Olympic Medal Rankings - Competitive Analytics

Interactive London Olympic Medal Rankings

August 10, 2012

UPDATED 08.12.12 (FINAL STANDINGS) – 85 countries won a medal out of the 962 awarded during the 2012 London Olympic Games. Which country performed best? If you just look at total medals won, the U.S.A. ranks first with 104 medals. If you only look at gold medals, the U.S.A also ranks first with 46 total gold medals. However, a more precise method of ranking Olympic performance is to normalize results by accounting for each country’s size, economic production, and resources per person. When we do this, Russia is the winner of the  2012 London Olympic Games – while host nation Great Britain ranks second and U.S.A ranks third.

Below is an interactive spreadsheet that allows you to choose which ranking criteria you feel is the best judge of overall Olympic medal performance. Here are six ways to rank all 85 countries that have won at least one medal:

1) Total Medals: 1st: U.S.A (104), 2nd: China (88), 3rd: Russia (82) [sort by column “T”]

2) Total Gold Medals: 1st: U.S.A (46), 2nd: China (38), 3rd: Great Britain (29) [sort by column “G”]

3) Weighted Average Surplus/Deficit of Expected Medals: 1st: Russia (+63.4), 2nd: Great Britain (+45.0), 3rd: U.S.A. (+22.0). This ranking is arguably the most equitable method for Olympic performance based on medals won normalized/adjusted for population, economic production, and resources per capita. [sort by orange column]

4) Medals Per Population: 1st: Russia (+56), 2nd: Great Britain (+54), 3rd: U.S.A. (+47). Does Russia, Great Britain, and U.S.A. have the most athletic talent per capita of any nation in the world? [sort by light purple column]

5) GDP Per Medal:1st: Russia (+58), 2nd: Great Britain (+29), 3rd: Ukraine (+18). Does Russia, Great Britain, and Ukraine make the most of it’s overall industrial production? [sort by light green column]

6) GDP per Capita Per Medal: 1st: China (+85), T-2nd: U.S.A. (+76), T-2nd: Russia (+76), 3rd: Great Britain: (+43). Is China the most efficient in winning medals based on resources available per person? [sort by light red column]

Methodology and Index by Column

Country: To make the list, a country must win at least one medal

G: Gold Medal (First place winner of an event)

S: Silver Medal (Second place winner of an event)

B: Bronze Medal (Third place winner of an event)

T: Total Medals Won

Weighted Average Surplus/ Deficit of Expected Medals: Wighted Average of three Surplus/Deficit Calculations (see below)

Pop: Total Population as of 2010 and 2011 data sources

% of World Pop: Percentage of each countries total population versus the world population

GDP $trillions: Nominal Gross Domestic Product in millions of U.S. dollars

GDP Per Capita: Nominal Gross Domestic Product divided by total population

Target Medals Per X Million Pop: [Total country population divided by (Total population of all countries that have won at least one medal divided by total number of medals awarded to date)]

Surplus/Deficit: Medals Per X Million Pop: Number of actual medals won to date LESS Target Medals Per X Million Pop

Target Medals Per $X Billion GDP: [Total country GDP divided by (Total GDP of all countries that have won at least one medal divided by total number of medals awarded to date)]

Surplus/Deficit: Medals Per $X GDP: Number of actual medals won to date LESS Target Medals Per $X Billion GDP

Target Medals Per $X GDP Per Capita: [Total country GDP Per Capita divided by (Total GDP Per Capita of all countries that have won at least one medal divided by total number of medals awarded to date)]

Surplus/Deficit: Medals Per $X GDP Per Capita: Number of actual medals won to date LESS Target Medals Per $X GDP Per Capita