Rajiv Krishna Prasad A0148542A

Sanjeev Kumar Chandran A0148398L

Mahendra Kumar KS A0148495N

Kotlanka Krishna Chaitanya A0150146R

_________________________________________________________________

Age dependency ratio (% of working-age population) data from 1960 till 2015 was used for the analysis, and was projected for 2016 and 2017.

Age dependency ratio is the ratio of dependents (people younger than 15 or older than 64) to the working-age population (ages between 15 and 64). Data is shown as the proportion of dependents per 100 working-age population.

The data obtained from the data source did not contain the latitude and longitude points for the countries. To incorporate these points, we obtained latitude and longitude data for all the countries from “http://www.csgnetwork.com/llinfotable.html”

We have converted countries into the signed degrees’ format (DDD.dddd), which are then used as markers on the map.
e.g.: Singapore into geographic coordinates latitude 1.290270 and longitude 103.851959

Findings/Insights:
1. Majority of the countries with least change in age dependency are from the European Union while those for increasing age dependency are from Africa
2. There was no general trend observed for countries with decreasing age dependency
3. There are more number of countries with decreasing age dependency (148) than countries with increasing age dependency (40)

Age dependency ratio for 1960:

adr-1960

Age dependency ratio for 2015:

adr-2015

Projected age dependency ratio for 2017:

adr-2017

In addition, the link to access the sheet published online is given below:

https://public.tableau.com/profile/publish/DA-Assignment/Geovisualization#!/publish-confirm

Advertisements