Data Visualization

Economic Impact of the EU Membership on the UK

23rd June 2016, voters from United Kingdom (UK) voted in the Brexit referendum to leave European Union (EU) with a small majority vote of 51.9 %. The decision to leave EU since joining in 1973 has consequences that are both profound and catastrophic. The post analysis of the referendum found that the issues for Brexit can be categorized into socio-economic factors, geographic division, domestic politics sentiment and attitude towards policy. Moreover, Michigan model of voting behaviour states that political sentiment is formed by socio-demographic factors and act as a funnel of causality [5].

A paper suggests that the major reasons people voted in favour of Brexit are the economic insecurity and social inequality felt by the voters because of the transformation of the workforce after the second world war. With the development of UK, the social landscape changed with income equality, wealth gap, rise of knowledge economy, automation, decreased manufacturing sector, erosion of organized labour as well as the increased immigration. This has led to dissatisfaction among the low-waged and unskilled, unemployed, households dependent on social welfare and social housing, families with single parent, poorer and white population living in deprived areas. The analysis further shows the division across generations, class, workers and education with persons receiving pension, low-skilled and less educated doing manual work steered the referendum to a Yes. In summary, the vote for Brexit was the general sense of insecurity for those left behind with sense of pessimism and marginalization [3].

Another issue which resulted in Brexit is the cultural backlash. Since the early 1970’s, the society in the UK has changed to more post-materialistic values of multiculturalism and cosmopolitanism. Voters have more access to college education, promotion of human rights and gender equality. The study states that these values are resented by older generation, white men, less educated and ethnic minorities because of the negative sentiment related to the progress. They feel this is a decline in their cultural values and displacement of traditional norms [6].

The other reason stated is that the British public has always been Eurosceptic since UK joined the EU in 1973. Moreover, referendums are often rejected by the voters because of the voter’s dissatisfaction with government policies. The paper states that voters with anti-immigration, anti-globalization and anti-establishment feeling, less-educated and less economically well voted to leave confirming a pattern from other researches. A survey also shows that public supported leaving EU since 2012. Remain side were more in larger multicultural cities and with more graduates while leave side was mainly from the English countryside, post-industrial north-eastern towns with large working-class populations [5].

This paper focuses on economic development based on aggregate-level data because it reflects social and economic progress. It includes a range of indicators such as:

  • Population growth comparing life expectancy at birth and rural and urban population
  • structure
  • Economic growth measuring annual increase in GDP, GDP per capita
  • Standard of living includes ination and unemployment
  • Education or literacy with number of enrolled at school
  • Division of industries [4];[1].

The aim of the paper is to visualize and analyse the changes in the economic indicators in the UK since joining the EU to determine the impact of the membership on the economy.

The data set is from the World Bank and includes indicators compiled from social sources. The type of data is time-series and includes national, regional and global estimates of topics such as economic growth, energy and extracts, climate change, trade and urban development, social development. The dataset was pre-processed using a programming language called Python prior to doing visualization. The main task was cleaning the data by removing missing values, outliers and inconsistencies.

The first approach to generate the visualizations was to use Tableau to understand and explore the data using its swift, out-of-the-box capabilities. This helped to create interactive visualizations which communicated a good story quickly. The static plots for this report are produced using Python libraries namely matplotlib, seaborn and plotly. Using the libraries enabled more customization and experimentation with different techniques, colour palettes and themes to visualize the data. The plots included in this paper are suitable for interactive demonstration and certain aspects cannot be included such as use of the tool-tip.

The code is available at link

Insight Figure 1

The annual growth rate for GDP determines how fast the economy is growing and includes drivers of growth such as personal consumption, business investment, government funding and net trade. Figure 1 shows that the maximum GDP growth for UK was in 1973 with the rate falling to approximately 2% when the first recession happened in 1975. The GDP recovered over the years but not to the same height as when the UK joined the EU. The rate decreased in 2009 to below 4% and kept on increasing till 2014 before falling again before the referendum. In contrast, the population grew in the UK. The maximum rate was in 2015 at 0.8% and falling the next year.

Figure 1: Yearly GDP Vs Population Growth

Insight Figure 2

The regression plot (see Figure 2) shows the population growth and annual GDP growth over the years. In the spirit of Tukey, the regression plots add a visual guide to emphasize the yearly population and GDP growth[11]. There is a relationship between the years and UKs population while GDP growth has a high variance over the years.

Figure 2: GDP Vs Population

Insight Figure 3

Life expectancy at birth is the number of years a new-born on average is expected to live if the death rate does not change. It is one of the health status indicators. In the UK, the life expectancy has continuously increased over the year with females most likely to live longer than males (Figure 3). However, since 2015, the years of life expectancy has not improved and is approximately 83 years for females and 79 years for males.

Figure 3: Life Expectancy at Birth

Insight Figure 4

The birth rate and death rate are the total number per 1000 people in a year. Figure 4 shows that both the birth rate and death has decreased over the years. The gain in life expectancy and the decrease in birth / death rate can be credited to rising living standards, better education, improved lifestyle and access to health services[8].

Figure 4: Birth Vs Death Rate

Insight Figure 5

Figure 5 shows the comparison between the trade and trade in services over the years. There is a constant increase in trade in services with it reaching 21% of the GDP in 2017. In comparison, there is more variation in trade of goods. It is always over 40% over the years. The increase in trade in services is possible due to the services provided by the UK such as financial services and information technology.

Figure 5: Trade Vs Trade Services

Insight Figure 6

Figure 6 shows how the exports and imports of goods and services progressed over the years. UK was exporting approximately the same amount as importing till 1997. Since then the UK imports more than it exports resulting in a trade defi cit. A trade defi cit leads to a country borrowing from other countries to pay for extra imports resulting in out ow of domestic currency to foreign markets and negative balance of trade.

Figure 6: Exports Vs Imports of Goods and Services

Insight Figure 7

Figure 7 shows a comparison between the merchandise exports and imports from a foreign country. Merchandise is referred to as retail goods and not services. It displays that over the years the imports have increased than exports. Since 2005, exports to other countries from the UK have remained almost the same with increased imports. This difference results in decreased pro t and unsustainable growth impacting the public’s opinion.

Figure 7: Merchandise Imports Vs Exports

Insight Figure 8 & Figure 9

Figure 8 & Figure 9 show the percentage of import and export of merchandise by sector. The plots show that manufacturing exports/imports are more important sector than food, fuel, agriculture and ores and metal. The increase in manufacturing imports has been more signi ficant than the exports. In 1973, UK manufacture exports and imports were 79% and 49% respectively of the merchandise. In 2016 both exports and imports stood at 75%. This can be attributed to the increased globalized and cross-border arrangements and fast-growing economy.

Figure 8: Merchandise Exports by Sector

Figure 9: Merchandise Imports by Sector

Insight Figure 10 & Figure 11

Focusing on the sectors without manufacturing show that imports for food has decreased over the years but has always been more than the exports. Import for agriculture, fuel, ore and metal sector has decreased to almost the same level as the exports. The increased imports and decreased exports result in a trade de ficit. Trade defi cit is described as when a country does not produce enough goods and must import goods for its residents. An increase in imported goods also leads to drop in prices for consumers and in inflation. However, in the long run, it results in creation of fewer jobs due to the domestic companies inability to produce goods and compete at lower prices. Normally, manufacturing and lower paid jobs are most affected due to the competition from imports[13].

Figure 10: Merchandise Exports without Manufacturing

Figure 11: Merchandise Imports without Manufacturing

Insight Figure 12

Figure 12 shows the percentage of commercial service imports and exports. It again highlights the growth in industries which are higher paid jobs against the lower paid jobs. The exports increased more than imports in computer, communication, fi nancial and insurance services industry. These industry had exports of 80% and 55% imports respectively. The growth of these industries has also occurred very quickly and had a strong relationship between economic growth and average contribution to GDP. However, transport and travel services industry has witnessed a dramatic fall in their exports from the total of 77% in 1973 to 20% in 2017. The imports of these sectors have also halved between 1973 and 2017. The change in commercial service industry has resulted in job insecurity and wage gap [2].

Figure 12: Commercial Services

Insight Figure 13

Figure 13 shows part-time employment as a percentage of total employment. Females are more likely to be in part-time employment than males. In 1974, females were 5 times more likely to be in part-time employment than males and with time the number dropped to 48% in 2017. In contrast, the part-time employment among males has doubled from 10% in 1973 to 21% in 2017. Normally, part-time employment pays less and is less protected than a full-time job. It also puts strain on the government by providing social welfare and medical bene fits to such employees. Employees need to seek multiple jobs to support themselves and their families affecting their quality of life.

Figure 13: Part-time Employment

Insight Figure 14

Figure 14 shows the unemployment among 15-24 years old. It depicts that males are more likely to be unemployed than females. The total youth employment was 22% in 2014 and since then has fallen to 12% in 2017. This fall can be attributed to the increase in part-time employment because a youth might accept a temporary position to gain some experience. Youth unemployment affects a job seeker by having a longer job searching period resulting in gap in employment history, unable to apply the education into practice and loss of skills. The job market risk loss of talent. There are increased economic costs with money being paid out on social welfare and less tax revenue generated.

Figure 14: Youth Unemployment

Insight Figure 15

Figure 15 shows school enrollment for primary, secondary and tertiary. It shows that the number of students entering secondary and tertiary education increased as time progressed resulting in more educated residents. This played an important role in both monetary and non-monetary bene fits in the UK. People changed their career to work in a knowledge-based industry sector such as fi nance, computer services, life sciences and telecommunications. They also have a high level of social tolerance and actively participate in the democratic process. However, the number of school enrollments fell between 2013 and 2016. This could be due to a drop in population growth as highlighted in Figure 3.

Figure 15: School Enrollment

Insight Figure 16

Figure 16 shows the annual GDP growth and inflation among the 5 largest economies in the EU since 2006. The left graph shows that the UK did not recover as quickly as Germany and France after the recession. Furthermore, since 2014 the annual GDP growth fell below Germany and Spain. At the same time, annual inflation of UK has remained the highest among the fi ve countries. Inflation impacts the cost of living for the residents with the purchasing power declining with each increase.

Figure 16: Annual GDP Growth and Inflation for EU

Insight Figure 17

Figure 17 shows the consumer price index (CPI) for the UK as compared to the 28 countries in the EU since 2006. CPI is the standard measurement of inflation for basic goods and services such as clothing, food, energy, housing and education. Till 2010, UK had the lowest CPI than the other four largest EU economies. However, since 2010, UK’s CPI continues to rise resulting in the highest value among all the EU countries. As CPI rises the house prices rise while income loses value.

Figure 17: Consumer Index for EU

Insight Figure 18

The foreign-born population doubled between 2004 and 2017 in the UK with 39% of them arrived from EU countries [12]. The left plot in Figure 18 shows that in 2015 UK’s annual GDP growth rate was less than the top 3 EU countries which make the foreign-born population. UK’s annual GDP growth rate was 2.35% compared to Poland at 3.84%, Romania at 3.97% and Ireland at 25.56%. The right plot in Figure 18 shows that there was a similar pattern in 2016. UK’s annual GDP growth rate was 1.936% compared to Poland at 2.86%, Romania at 4.82% and Ireland at 5.14%.

Figure 18: Average Annual Growth Rate in Percentage

Insight Figure 19

Figure 19 shows that in 2016 UK’s annual GDP growth rate was less than Ireland. It also shows that the countries which share the same borders have almost the same annual GDP growth rate than countries which are far from each other.

Figure 19: Average Annual Growth Rate for GDP for EU states in 2016


An analysis of the data from world bank indicates that the papers are correct to state that the economic and social landscape of UK has changed since joining the EU in 1973. The different visualizations show that the UK has developed with lower death rate and increased life expectancy. There has been a rise of knowledge economy with a decrease in manufacturing, low-paid and low-skilled jobs. However, the economic transformation has been developing over some time and the residents voted for Brexit as the insecurity and dissatisfaction increased with the governments economic policies.


[1] BBC. Brexit: All you need to know about the UK leaving the EU – BBC News. 2018. (Visited on 10/13/2018).
[2] Stanciu Anca Cristina, Constandache Mihaela, and Racoceanu Cristina. \The Importance of Commercial Services in the Trade Activity”. In: Ovidius University Annals, Economic Sciences Series XIII.1 (2013), pp. 1003{1008.
[3] Mathew J. Goodwin and Oiliver Heath. The 2016 Referendum, Brexit and the Left Behind: An Aggregate-level Analysis of the Result. Tech. rep. 2016.
[4] Norman Hicks and Paul Streeten. World Bank Reprint Series: Number 104 Indicators of Development: The Search for a Basic Needs Yardstick Indicators of Development: The Search for a Basic Needs Yardstick. Tech. rep. 1979, pp. 567{580.
[5] Sara B. Hobolt. \The Brexit vote: a divided nation, a divided continent”. In: Journal of European Public Policy 23.9 (Oct. 2016), pp. 1259{1277. issn: 1350-1763. doi: 10.1080/13501763.2016.1225785.
[6] Ronald F Inglehart, Pippa Norris, and Harvard Kennedy School. Trump, Brexit, and the Rise of Populism: Economic Have-Nots and Cultural Backlash Faculty Research Working Paper Series. Tech. rep. 2016.
[7] Elijah Meeks. Making Annotations First-Class Citizens in Data Visualization. 2017. (Visited on 10/31/2018).
[8] OECD. Health at a Glance 2017. Health at a Glance. OECD, Nov. 2017. isbn: 9789264280397. doi: 10.1787/health_glance-2017-en.
[9] Randy Olson. How to make beautiful data visualizations in Python with matplotlib | Dr. Randal S. Olson. 2014. (Visited on 10/31/2018).
[10] Alex Olteanu. How to Generate FiveThirtyEight Graphs in Python. 2017. (Visited on 10/31/2018).
[11] Seaborn. Visualizing linear relationships fd fd fd seaborn 0.9.0 documentation. 2017. (Visited on 10/28/2018).
[12] The Migration Observatory. Migrants in the UK: An Overview – Migration Observatory – The Migration Observatory. 2017. (Visited on 11/20/2018).
[13] UNCTAD. International trade in merchandise and services 4 4 4.1 Inte 4.1 International trade in merchandise and services 4.2 International trade in merchandise 4.3 International trade in services 4.4 Tari protection 48 48. Tech. rep. 2004.
[14] Vitsoe. Good design | About Vits | Vits. 2018. (Visited on 11/21/2018).
[15] Wtamu. Why are red, yellow, and blue the primary colors in painting but computer screens use red, green, and blue? | Science Questions with Surprising Answers. 2015. (Visited on 10/31/2018).


Leave a Reply

Your email address will not be published. Required fields are marked *