1. Go to the World Bank's World Development Indicators (WDI) database at: http://databank. worldbank.org/data/ For the following Pacific Island Countries: Fiji, Papua New Guinea, Samoa, Solomon Islands, Tonga and Vanuatu, download data (if available) on each of the following indicators for the years 2000-2015 Fig. Indicator in Slide Comparable indicator in WDI database GNI per capita, PPP ( current international S, GNI per capita, PPP (current log scale) international 5) 1.1 Energy use per capita, 2002 (kg of oil Energy use, (ky of oil equivalent per equivalent, log scale capita) 1.2 Rural Population (%% ), 2003 Rural Population (7% of total population) 1.3 Life Expectancy at Birth, 2003 Life Expectancy at Birth, total (years) 14 Female Adult Literacy Rate (9%) Literacy Rate, adult female (1% of females ages 15 and above) Then picking data as close to the years (use 2003 and if not use 2004 date) represented in Figures 1.1 to 1.4 of the lecture on slides, identify where each of the PICs lies in relation to the trend line Comment on whether each PIC is above or below the trend line and comment on its significance. Additional Task: 2. Again from the WDI website, download the following date for the following PICs: Fiji, Papua New Guinea, Samoa, Solomon Islands, Tonga and Vanuatu, along with at least 20 other countries, chosen proportionately from each of the World Bank income classes: GNI per capita, PPP (current international $), Year =2015 Population of age 0-14 (%), Year =2015 Place your data in an Excel Workbook and then convert GNI per capita into logarithmic values. Now do a scatter plot of the relationship between log GNI and 9% of population aged 0-14 and fit a trend line through it. What does this plot indicate about how the percentage of minor dependents varies with GNI? For each of the PICs, indicate whether it lies above or below the trend line and interpret the meaning of this. 3. Summarise and identify the strategies taken by Fiji government to improve the welfare of people as reported in various newspaper this week