Question

Instructions:

To get full credit, ALL graphs should include a title, trendline, axes titles, legends when applicable, and make sure to use visible colors.

Question 1: Development is multidimensional.

As we argued in class, income per-capita is a good yardstick of development if it is strongly correlated with important indicators that directly measure wellbeing, such as education, health and gender equality. In this problem, you will empirically explore the strength of the relationships between income per capita and several indicators of women’s empowerment and health using data from the World Bank. Go to the World Bank database of development indicators and download the following indicators for year 2018:

• GDP per capita (constant 2010 US$): This measures the average income per person in a country
• Life expectancy at birth, total (years): This measures the number of years a newborn infant is expected to live given the prevailing conditions at the time of birth.
• Proportion of seats held by women in national parliaments for 2018.

Make sure not to download data points for regions, such as Small states, World, East and Pacific, etc. Also, delete countries with missing values.

1. Generate two scatter plots with trend-lines using excel:

1. Life expectancy against GDP per capita, and title this plot “Figure A1: Life Expectancy vs GDP per capita for 2018”
2. Proportion of women in national parliaments against GDP per capita, and title this plot “Figure A2: Proportion of Women in National Parliaments vs GDP per capita 2018”

Answer 1

COUNTRIES	LIFE EXPECTANCY AT BIRTH	GDP PER CAPITA FOR 2018
MIRACONA	68	3568.3
YEMEN	66	968.2
CAYAMAN ISLAND	82	85477.3
SAN MARIO	85	48481.0
MICRONESIA	68	3568.3
PALAU	69	15859.4
TONGA	71	4364.0
GREENLAND	71	54471.0

COUNTRIES	PROPORTION OF WOMEN IN NATIONAL PARLIAMENT	GDP PER CAPITA 2018
YEMEN	0	968.2
SAN MARIO	33	48481
MONACO	33	185.829
PALAU	13	15859.4
CUBA	53	8821.8
DENMARK	40	95882.8
DJIBOUTI	26	3408.8
MONACO	33	185829