In my Demographic Dashboard I have a scatter plot that shows the trend towards an aging society. Today I wanted to test the new Google Chart API and the Motion Chart with the same data set.
The chart displays the old dependency ratio against young dependency ratio. It clearly shows the shift from high ratios of young dependency to high ratios of old dependency specially in Europe and other developed countries. This means tough times ahead (the adult population will not be able to pay for social security systems, expensive medical care, etc.).
If you click a specific country a persistent label will allow you to track its evolution.
If you want to play with the chart click on it to go to the published spreadsheet or follow this link. [Update: you could play with the chart directly in the post but I was getting some problems with Microsoft Explorer so I decided to remove it.]
If you are not familiar with the demographic concepts, this is what you need to know to understand the chart:
- Old dependency ratio: ratio between population 65+ years old / adult population (15-64 yeas old);
- Young dependency ratio: ratio between population 0-14 years old / adult population (15-64 yeas old);
- Total dependency ratio is the sum of the above two.