How GDP per capita has evolved for Dominican Republic, Haiti, El Salvador, Thailand, and The Philippines
Go to: http://databank.worldbank.org/data/source/world-development-indicators
Under “COUNTRY,” and select the following countries: Dominican Republic, Haiti, El Salvador,
Thailand, and The Philippines. You have the option of selecting 2 additional developing countries of
your choice, for a total of 7 countries.
In the upper left, click “Layout”.
Change “Time” dropdown listing to “Row”.
Change “Series” dropdown listing to “Column”
Change “Country” dropdown listing to “Row”
Select “Apply Changes”
Click the “Variables” tab
Under “SERIES,” select the following:
GDP per capita (constant 2010 US$)
Under “TIME,” choose 1980, 1985, 1990, 1995, 2000, 2005, 2010, and 2017.
Select “Apply Changes”
In the upper right, click “DOWNLOAD OPTIONS” and then “ADVANCED OPTIONS”. Choose
“Excel” and set the Excel format to “.xlsx” and then make sure that “Data format” is set to “Table.” Set
“Variable format” to “Names only.” Set “NA preference” to “Blank” and “Metadata” to “No.” Then
download and save your data.
Next, click “Download Options” and select “Excel.” Observe your results.
Section 1
Describe how GDP per capita has evolved for Dominican Republic, Haiti, El Salvador, Thailand, and The
Philippines (and your 2 additional countries).
Specifically, for each of the countries, explain (in 3-5 paragraphs per country) what trend(s) you observe
in income per capita over the 8 years for which we’ve loaded the data (i.e., 1980, 1985, 1990, 1995, 2000,
2005, 2010, and 2017).
What specific theory (or theories) of economic growth and economic development helps explains the
performance of income per capita over these years?
What evidence/theory can you add given your literature review and research on the selected countries?
2
Instructions 2
Go to http://databank.worldbank.org/data/source/world-development-indicators
In the upper left, click “Layout”.
Change “Time” dropdown listing to “Row”.
Change “Series” dropdown listing to “Column”
Change “Country” dropdown listing to “Row”
Select “Apply Changes”
Click the “Variables” tab
Click the “Countries” tab and then select the following countries: Angola, Argentina, Bangladesh, Belize,
Benin, Bolivia, Botswana, Brazil, Burkina Faso, Burundi, Cambodia, Cameroon, Central African
Republic, Chad, Chile, Colombia, Congo, Dem. Rep., Congo, Rep., Costa Rica, Cote d'Ivoire, Djibouti,
Ecuador, El Salvador, Equatorial Guinea, Ethiopia, Gabon, Gambia, Ghana, Guatemala, Guinea, GuineaBissau,
Guyana, Haiti, Honduras, India, Indonesia, Jamaica, Kenya, Korea Rep., Kuwait, Lebanon,
Lesotho, Liberia, Malawi, Malaysia, Mali, Mauritania, Mexico, Mozambique, Namibia, Nicaragua, Niger,
Nigeria, Pakistan, Panama, Paraguay, Philippines, Saudi Arabia, Senegal, Seychelles, Sierra Leone, South
Africa, Sri Lanka, Swaziland, Tanzania, Thailand, Turkey, Uganda, Vietnam, Zambia, Zimbabwe
Under “SERIES,” choose:
Secondary education, general pupils (% female)
Primary education, pupils (% female)
Population growth (annual %)
Under “View Recent Years”, select “25”
Select “Apply Changes”
In the upper right, click “Download Options” and select “Advanced Options”. Make sure that “Data
format” is set to “Table.” Set “Variable format” to “Names only.” Set “NA preference” to “Blank” and
“Metadata” to “No.” Then download and save your data.
Now make scatter plots showing the relationships between: (1) Secondary education (x-axis) and the
Population growth rate (y-axis) and (2) Primary education (x-axis) and Population growth rate (y-axis).
Next (for each scatterplot), place your cursor over any value (i.e., number) on the x-axis. Right-click to
select “Format axis”. Change the Minimum” to 10.
Next (for each scatterplot), place your cursor over any scatter point (i.e., dot) within the plot. Right-click
to select “Add Trendline”. Select “Linear”. A trendline should now be included in your graph. Now
change the color of the trendline to black.
Label each scatterplot appropriately. Paste the image (of the scatter plots) into your paper.
Section 3
Is there an association between the percentage of girls receiving secondary and primary education and
population growth rate? Explain. Be sure your response references academic journal articles (citing
our course textbook is permitted) and other credible sources.