EU Life Quality Geo Report

Living longer, living better?


It's equally important to measure the longer living as well as its quality.
Analyzing data from [eurostat](http://ec.europa.eu/eurostat/publications/recently-published?p_auth=ZKofrOKp&p_p_id=estatsearchportlet_WAR_estatsearchportlet&p_p_lifecycle=1&p_p_state=maximized&p_p_mode=view&_estatsearchportlet_WAR_estatsearchportlet_position=HLY_M&_estatsearchportlet_WAR_estatsearchportlet_dimension=break_sd&_estatsearchportlet_WAR_estatsearchportlet_sort=lastUpdateDate&_estatsearchportlet_WAR_estatsearchportlet_theme=PER_POPSOC&_estatsearchportlet_WAR_estatsearchportlet_action=search&_estatsearchportlet_WAR_estatsearchportlet_collection=dataset&_estatsearchportlet_WAR_estatsearchportlet_publicationDate=2015) which containts the following two variables:

1- Healthy life years: Is a health expectancy indicator which combines information on mortality and morbidity.


2- Life expectancy: Life expectancy at birth is defined as the mean number of years still to be lived by a person at birth

Original data is splitted into gender, but here the average was computed between female and male to have only one metric. The last updated data belongs to 2012.

Following plots shows these indicators in a map, Each metric is expressed in years.


Life expectancy (left) Vs. Healthy life years (right)

Life expectancy (left) Vs. Healthy life years (right).



Top 3 - Countries

Top 3 table
**Here we can see that top 3 countries with the highest healthy life, *are not* the top 3 highest with longer life expectancy.**

Gap healthy life

Now we've know how "expectancy" and "healthy" is distributed, we proceed to compute the gap among them, generating a new metric called "Gap healthy life"


This metric tends to be higher when people live more years in a no-good life condition until their final days, on the other side this value is close to 0 when people tends to live all their life in good condition, let's life expectancy and life quality have similar values.

Gap between healthy expectancy
To reflect quantitavely the most dissimilar (left) and the most equitative (right), following table was created:
Top 3 Gap  table

Final thoughts

It's interesting to note how many years people lives in a bad quality of life until their dead, like Germany which their good living ends at the age of 57, while their life expectancy is around 81 years.


Looking at Slovenia which holds the highest gap, we can see their people lives 35% of their lifes in a bad-quality (healthy: 52 vs expectancy:80.2 years)




One further analysis could be to analyze these metrics, across the time to see global trends.



#### Finally...
  • For a live and dynamic graph version, please go here
  • R Code & data available in github


Pablo Casas

Pablo Casas

Data Analysis ~ The art of finding order in data by browsing its inner information.

Read More
EU Life Quality Geo Report
Share this