answered: Create trend line graphs for two countries of your choosing

  

Create trend line graphs for two countries of your choosing over the period from 1980 to present, for one of the measures of poverty or inequality provided in the data sources linked below. See the tutorial I’ve copy and pasted at the bottom of this assignment document regarding accessing these data sources and making a trend line graph in Excel.
•GDP per capita from the Maddison Historical Statistics
https://www.rug.nl/ggdc/historicaldevelopment/maddison/releases/maddison-project-database-2020
•Gini Coefficients from the World Bank:
https://data.worldbank.org/indicator/SI.POV.GINI
•Top 1% Share of Income and Wealth from the World Inequality Database:

Home

Save your graph from Excel as an image file and upload into a Word Document. In the document, below your trend line graph, answer the following questions in, altogether, no more than 400 words. Please submit as an attachment within this assignment (click the button in “assignment submission” section below to “browse local file”)
Tutorial Showing Steps for Downloading Data From Government/NGO Websites and Creating a Time Trend Graph in Excel
***All Examples are of the United States (please choose any two countries other than the U.S. for your homework submission this week)***
I. GDP per capita, Maddison Historical Statistics (A Rough Measure of Average Poverty)
Steps:
Go to https://www.rug.nl/ggdc/historicaldevelopment/maddison/releases/maddison-project-database-2020
Click on first button labelled “Excel”
In the Excel file “mpd2020”, click on the fourth tab labelled “GDP pc”
Scroll to the left to column “FF” which holds data for the United States
Scroll down to row “737” for data beginning in 1980
Click and drag your cursor to highlight data in column FF from row 737 to 775 (i.e. 1980 to 2018)
Click the “+” sign just to the right of the sixth panel below.
Put your cursor over and click on the cell in row 2 of column B
Paste your selection from the previous panel
In row 1 of column B, write “GDP per capita)
In row 1 of column A, write “Year”
Label the years from 1980 to 2018 from row 2 to row 40 of column A
Highlight cells B2 – B40 *I have a MAC so your steps may differ a little from mine using excel.
Click Insert
Choose Chart, Line Graph
Right click on graph and choose “Select Data”
On the line that says “Horizontal axis”, paste “=Sheet1!$A$2:$A$40”
Edit the title (Double Click on Title and Edit it) to “U.S. GDP per Capita: 1980-2018”
Format the chart by adding Axis Information (Click Chart Design and add chart elements): the vertical axis should say “GDP per capita (in 2011$)”.
Right click on final line graph and click “Save as Picture”
Name and save file to your computer
Open your Word Doc for your Unit 3 Data Module assignment
Click insert, Picture, File from Browser
Click on the name given to your line graph.
II. Gini Coefficients, World Bank (a standard measure of income inequality):
Steps:
Go to https://data.worldbank.org/indicator/SI.POV.GINI
Click on the link for Excel by the word “Download” on the right side of the webpage
Open the downloaded Excel document labelled “API_SI.POV.GINI_DS2_en_excel_v2_2015296”
Click on the first panel called “Data”
Scroll down to the row “254” of column A for the “United States”
Highlight the data in columns Y through BM of this row, which correspond to the years 1980 to 2020, and copy this selection
Scroll over to the “+” sign just after the third panel at the bottom of the document
In this new panel, highlight and right click the cell in row 2 and column B
Choose Paste Special, and then check the box called “Transpose”
Go back to the initial first panel called “Data”
Highlight the cells in row 4 of the panel from columns Y to BM, Right click, and Copy
Go back to the newest panel you pasted the first selection into
Highlight and right click on the cell in row 2 in column A
Choose Paste Special, and then check the box called “Transpose”
In the cell in row 1 in column A, write the word “Year”
In the cell in row 1 in column B, write the word “Gini Coefficient”
Highlight rows 2 through 7, right click, and choose delete (repeat for all other yearly rows that have no associated Gini coefficient)
(You should have year-gini pairs for 1986, 1991, 1994, 1997, 2000, 2004, 2007, 2010, 2013, and 2016 only after this operation)
Highlight cells B2 – B11*I have a MAC so your steps may differ a little from mine using excel.
Click Insert
Choose Chart, Line Graph
Right click on graph and choose “Select Data”
On the line that says “Horizontal axis”, paste “=Sheet1!$A$2:$A$11”
Edit the title (Double Click on Title and Edit it) to “U.S. Gini Coefficient: 1986-2016”
Format the chart by adding Axis Information (Click Chart Design and add chart elements): the vertical axis should say “Gini Coefficient)”.
Right click on final line graph and click “Save as Picture”
Name and save file to your computer
Open your Word Doc for your Unit 3 Data Module assignment
Click insert, Picture, File from Browser
Click on the name given to your line graph.
III. Top 1% Share of Income and/or Wealth, World Inequality Database (another measure of income/wealth inequality):
Steps:
Go to https://wid.world
Click on the third panel on the main page on the far right called “Data Tables”
On the Key Indicators, click any from the Income Inequality or Wealth Inequality sections (i.e. I chose “Top 10% Income Share”)
On the Country choose any of your choice (i.e. I chose USA)
On the Years choose 1980 through 2019 (the most recent year of data)
Click the button “Retrieve Data”
Click the “Download” in the bottom right of the webpage OR just highlight the table generated below and copy and paste into a new Excel Document
…. Highlight the rows and insert a line graph in the resulting excel doc in the same way as in I and II above.