Instructions
Go to: https://databank.worldbank.org/source/world-development-indicatorsIn the upper left, click “Layout”. Make sure that “Custom” is highlighted.Change “Time” dropdown listing to “Row”. Change “Series” dropdown listing to “Column”Change “Country” dropdown listing to “Row”Select “Apply Changes”Click the “Variables” tabClick“Country”. Next, select “Countries”. Now, click on the blackdown arrowto the rightof “Enter Keywords for”. Select Sub-Saharan Africa, Latin America and Caribbean, and South AsiaNext, select the check box to the leftto select all countriesin Sub-Saharan Africa, Latin America and Caribbean, and South Asia. Scroll down a bit and click “Series”and select the following series: GDP per capita (constant 2010 US$)Exports of goods and services (constant 2010 US$)Imports of goods and services (constant 2010 US$)Scroll down a bit and click “Time”. Notice “VIEW RECENT YEARS”. Click on the number 25to select the last 25 years. 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. In MS Excel, calculate the natural log of exports, the natural log of imports,and the natural log of GDP per capita. Then create a new column called “natural log of net exports”. Natural log of net exports is the natural log of exports minus natural log of imports. Next, copy and paste as “values” these 2variables(natural log of net exports and natural log of GDP per capita) within the MS Excel sheet. Next, use MS Excel to replace the “#NUM!” with blanksin the new columns you just created. Now make a scatter plot showing the relationship between natural log of net exportsand natural log of GDP per capita. Label scatterplot appropriately. Paste the image (of the scatter plot) into your paper. QuestionsIs the association between net exportsand GDP per capitapositive or negativefor these developing countries? What international tradetheories, arguments, &evidence supports (or not) this association? Explain. Be sure your response references academic journal articles and other credible sources. Remember to craft your response in the form of a research paper. What else do you notice about the relationship between these two variables? Write a 5-page paper on your project. When completed, upload your paper to Titanium and give me a copy on Friday, December 13, 2019 in class.