Analytics: General_Compare
To accomplish step B), I created a drop-down list of all the countries in my data-set. Then I used the MATCH function and OFFSET function to construct an interactive table that allows an user to compare all countries’ economic growth rates to the growth of the specific country he/she choose. The method to calculate the differences in growth rates is similar to that used in step 1), in which I calculated the differences in growth rates between the U.S. and all countries.
I used the interactive table to compare economic growths in all countries to four selected countries: China: Hong Kong SAR, India, United States, and United Kingdom. Then I found out the top ten fastest growing countries in each case and compiled the following table:
I used the interactive table to compare economic growths in all countries to four selected countries: China: Hong Kong SAR, India, United States, and United Kingdom. Then I found out the top ten fastest growing countries in each case and compiled the following table:
Contrary to my hypothesis, countries in BRIC do not enter the top ten fastest-growing countries in any of the above cases. Those countries with the highest GDP per-capita today also do not enter the top ten; the only exception is Singapore, which ranks 8th when comparing to the economic growth in India.
Equatorial Guinea, the country that ranks first in all of the four cases, is a small country in Middle Africa; it is one of the richest countries in that region in terms of GDP per-capita, but wealth is quite unevenly distributed in Equatorial Guinea. According to the U.S. Department of State website, per capita income in Equatorial Guinea rose from about $590 in 1998 to approximately $18,209 in 2010. This enormous increase is partially driven by its oil/gas production and tax/royalties on foreign companies.[1]
Azerbaijan, on the other hand, is located at the border of western Asia and eastern Europe. This country was incorporated into the Soviet Union for more than half a century but regained independence in 1991. Azerbaijan has a rich reserve of oil and gas; this country is also known as the "Land of Fire". According to a documentary produced by the CNN, Azerbaijan is producing about 1.3 percent of the world's oil supply today.
http://www.state.gov/r/pa/ei/bgn/7221.htm
Equatorial Guinea, the country that ranks first in all of the four cases, is a small country in Middle Africa; it is one of the richest countries in that region in terms of GDP per-capita, but wealth is quite unevenly distributed in Equatorial Guinea. According to the U.S. Department of State website, per capita income in Equatorial Guinea rose from about $590 in 1998 to approximately $18,209 in 2010. This enormous increase is partially driven by its oil/gas production and tax/royalties on foreign companies.[1]
Azerbaijan, on the other hand, is located at the border of western Asia and eastern Europe. This country was incorporated into the Soviet Union for more than half a century but regained independence in 1991. Azerbaijan has a rich reserve of oil and gas; this country is also known as the "Land of Fire". According to a documentary produced by the CNN, Azerbaijan is producing about 1.3 percent of the world's oil supply today.
http://www.state.gov/r/pa/ei/bgn/7221.htm