Data Visualization

Blog of the Data Visualization & Communication Course at OSB-AUB

This is my favorite part about analytics: Taking boring flat data and bringing it to life through visualization” John Tukey

Lebanon: The Crisis & The Opportunities

Lebanon: The Crisis & The Opportunities

Rafic Srouji, Lara Zbibo, Anas Sidani, Dima Daouk, Ziad Moghabghab, Celine Kabbara

 

As MSBA students, we are used to working with data daily, we are accustomed to hearing about its importance and how it holds the answers to any question we might have. We didn’t really understand how powerful data was until we were asked a question we didn’t have the answer to, and with the use of data we were able to unearth the answers to our question.

It was Monday February 22, directly after our Data visualization class, we were walking from OSB to Zaituna Bay and we were discussing different potential ideas for our upcoming visualization course when suddenly we were stopped by a SkyNews reporter. He asked us if we were students and then proceeded with asking us the one question that captured our curiosity:

 

Luckily, they included MSBA’s one and only Rafic Srouji in the news report the next day. His answer was:

This whole interaction got us thinking and sparked our curiosity; we wanted to find out why is the cost of consumer goods drastically increasing and what can we do about it.

As residents of Lebanon, we experienced first-hand the dramatic rise of prices every time the Lira devalues with an average inflation rate of 132.98%, so we joined the monthly inflation rate data in Lebanon with the monthly Lira rate data from 2019 till 2022. After plotting the timeseries data, we found that when the lira rate increases the inflation rate increases substantially. With further research, we found that the price of consumer goods changes substantially with the fluctuation of the lira because most consumer goods are imported, thus being purchased with the USD.

In order to get more insights about the nature of the trade deficit (exports and imports), we analyzed the Lebanese exports and imports data. This enabled us to create charts that compare the import and export values in Lebanon, and to divide them by sector.

As we can see in the dashboard’s charts, Lebanon has a large trade deficit of $12.81 Billion with most consumer goods being imported, this definitely plays a huge role in the increase of prices. If Lebanon was more self-sufficient when it comes to consumer goods and other basic products, the price of said products could potentially decrease and would be less volatile to changes in the lira rate.

Lebanon imports 20% of its total imports from the Agriculture sector, as well as 20% from the Minerals sector, which both constitutes to its highest imports. Our focus as to evaluate whether this amount could be reduced.

A big discovery was found! Lebanon has opportunities all over its area, hidden in its chaos; the country has at least one available factory that can produce goods from any tradeable sector. Lebanon has more than enough factories to reach the dream of putting a dent in the trade deficit. The country has 1,616 factories in the food industry that can dramatically decrease the high prices of food and beverages, if properly exploited.

A comparison between Turkey and Lebanon was found to be a great validation to our proposed solution. Turkey’s Lira has lost more than 70% of its value since 2021, but it was found that the inflation rate didn’t follow as aggressively as that of Lebanon. The weaker correlation between the Turkish Lira rate and the Turkish inflation rate is a direct result of the strong local production in Turkey. Turkey has a negligible trade deficit of $29 million which is negligible in comparison to its population (85 million), in opposite to Lebanon who has a trade deficit of $12.82 billion with a population of 6.83 million.

Local production is a key player in decreasing Turkey’s yearly trade deficit. Improving local production is seen to be effective in decreasing the country’s trade deficit, and decreasing the prices of goods.

From here, our findings demonstrate that there is a crucial need for local production. To do so, the government must allocate resources towards these factories and exploit them, especially in times we need them the most. This would potentially increase tourism, increase local jobs, and decrease prices all together.

Impact of Lebanon’s Economic Collapse on the Lebanese Population

Impact of Lebanon’s Economic Collapse on the Lebanese Population

Featured Image Courtesy of: albawaba.com

    Contributors in Alphabetical Order:

  • Nour El-Habhab
  • Salem Grayzi
  • Antoine Rahal
  • Bahige Saab
  • Ziad Shehab
  • Mahmoud Yaghmour

 

Lebanon has been living one of the worst economic crises that a country has lived in the modern era. According to the World Bank , it is likely to rank among the top 10 most severe crises experienced globally since the 1850s. In this article, we will explore the impact of Lebanon’s economic collapse on the mental health of the Lebanese people, their productivity, and their forecasts of the country’s future. We will also try to discuss two potential measures that could mitigate its severe economic crisis.
The following graphs plotted in the dashboard were based on the UN World Indicators dataset. These graphs reflect the severity of the Lebanese collapse. The bar chart of Lebanon’s GDP per capital for the last ten years demonstrates that the country’s GDP has shrunk by 43% in two years only! To make things worse, the inflation rate line chart show that the country’s inflation rate has skyrocketed by 2724% in two years only! An item that cost 1000LBP in 2018 cost almost 27,240 LBP in 2020! For further details refer to the “Lebanon’s Economic Collapse in Numbers” dashboard.

These shocking numbers have motivated us to study the effect of the economic collapse on the Lebanese people’s mental health and productivity in addition to explore their insights about the future. Therefore, we designed a survey in which 370 people of different age and employment groups participated. The results were extremely alarming: 61% of the surveyed people said that their mental health was affected by the economic collapse while almost 60% of them revealed the negative impact of the crisis on their productivity. To make things worse, 69% of the respondents said that they wanted to leave Lebanon while 62% of them were pessimistic about the country’s future! Almost 1 in every 5 Lebanese said that there is no hope in Lebanon. On the other hand, almost half of the respondents said they would stay in Lebanon if the situation improved. The “Survey Dashboard” summarizes the survey’s results.

The Currency Board:

As Lebanon’s economy has been in crisis for almost two years now, ranked in possibly the top three most severe economic and financial crises since the nineteenth century, an ultimate solution does exist but is nearly impossible to achieve, replacing the ruling political parties. As ambitious young minds, we looked for practical solutions that we can possibly push for to help our country. A suggested solution from an economic perspective would be a currency board, a solution that has been implemented in countries that were facing a similar crisis to Lebanon such as Lithuania and Bolivia. A currency board is an entity separated from the central bank that is given the authority of managing the country’s currency reserves and fixing exchanges rates, it is regulated by law and not the government, hence limiting any pressure from political parties. Having a currency board would fix the inflation rate and trigger a domino effect on the economy by improving GDP, growth, and many other factors.
The “Currency Board Solution” dashboard below shows that there is a prompt decrease in the inflation rate after applying the currency board solution in the late 90s in Bulgaria, Estonia, and Lithuania, who’ve faced severe cases of hyperinflation just like Lebanon. Alongside the stability of the inflation rate over 20 years, GDP has shown a steady increase since the setup of the board as a result of inflation being stabilized. This shows how this solution has an immediate impact and could help Lebanon start the recovery process directly.

Obtaining then Commercializing IP to boost GDP:

Another solution for Lebanon’s current problem is obtaining then commercializing intellectual property; Given Lebanon’s rich human capital this seems like a reasonable solution. Also, by patenting Lebanon’s ideas, they can offset copycat competitors thus preserving Lebanon’s newly found income source, for a reasonable timeframe [till the patent expires]. Some of the metrics to measure a country’s participation in intellectual properties, at least from the World Bank World Development Indicator dataset are:
– Patent application, residents and Patent application, non-residents
o These were summed to a new metric: Patent Applications, Total
– Industrial design applications, resident by count and Industrial design applications, nonresident by count
o These too were summed to a new metric: Industrial design applications (Total)
– Trademark applications total
o No summing of several metrics was needed here
Besides generating high-value, and off-setting copycat competitors, plenty of the high-value wages in many fields are not energy-intensive; for instance, consider the designers of the iPhone package boxes at the Apple headquarters; these box designers literally sit in a room designing carton boxes, and these designers make more money than the overseas employees working in the energy-intensive factory manufacturing these boxes. This is a model that Lebanon who has high creativity but is experiencing an energy shortage can pursue.
And as the “Potential Solution: Patenting” dashboard demonstrates, we’re able to see that these three Intellectual property metrics are positively-correlated with GDP – so it is something that we believe Lebanon as a society should consider as a route to follow.

Conclusion:

To conclude, it is true that Lebanon’s economic crisis has merged us into a dark tunnel from which it is not easy to get out of. However, with conscientious diligent ethical work, we can accelerate the recovery process. At the end, it is in our hands to decide whether we shall stay this obscure tunnel for a long time or encounter the light of salvation at its end as fast as possible.

Supporting Agricultural Sector in Lebanon

Supporting Agricultural Sector in Lebanon

Lebanon is suffering from an economical and financial crisis since 2019. The world bank has classified this crisis as one of the worst 3 crises since mid-nineteenth century. One main reason behind this crisis is the high external debt and its services which have led eventually to a great negative impact on Lebanon’s GDP. One way to control the increase of this debt is working on the development of the agricultural sector.

Problem:


The external dept as well as its services have increased dramatically over years. This increase was highly sharp between the years 2019 and 2020. At the same time, this high increase in the debt was associated with a decrease in GDP growth, specifically between the years 2016 and 2020.

Solution:


The contribution of agriculture in the GDP of Lebanon was decreasing over years. So, supporting the agricultural sector would be one of the solutions that can help freezing the increase in debt. In fact, Lebanon has the required elements to do that, i.e., a cultivatable land and water resources. According to the World Bank collection of development indicators, Lebanon has 64.32% of its land cultivatable.

Supporting the agricultural sector means that the government is requested to work on a plan that can improve the agricultural sector. This is important as a development in the agricultural sector would be reflected as an increase in the agricultural production. Therefore, this will lead to a decrease in the imports and an increase in the exports of agricultural products. Finally, all of this would cause a higher contribution of agriculture in GDP and a decrease in borrowing and debt levels.

This proposed solution has been adopted by many other countries to support their economy. According to the World Bank, agriculture has accounted for more than 25% of GDP in developing countries in the year 2018.

Findings:

  • Developing agricultural sector is essential for the development of the Lebanese economy.
  • Improving the agricultural sector will help Lebanon in getting out of the economic and financial crisis.

Recommendation:

The government should construct and implement a plan that can enhance the agricultural sector in Lebanon.

Lebanon’s Economic Crisis: Challenges & Solutions

Lebanon’s Economic Crisis: Challenges & Solutions

 

In this article, I’ll be discussing the Lebanese economic crisis, it’s challenges and solutions.   – Fun fact: the 0’s and 1’s (above) are, ‘Lebanon’ in binary. 

Most news today about Lebanon, is unfortunately, bad news.  

There’s an electric and currency crisis, a brain drain and so much more. 

And in these dark times, Lebanon is losing its lights, its educated people, to the other place.  
But outside sensational news, and using data, can we verify these challenges and offer a solution?

Well, after Investigating Lebanon’s inflation and GDP, we clearly see sky-rocketing inflation and a tumbling GDP.  

But what is the solution? 

Now, for a country to trade, it needs to find a niche – that is that one or two things it can do better than it’s competition and trade with those things. 

The bottom chart (in the above visualization) represents the population and export sizes of Lebanon, Saudi Arabia and UAE – Lebanon, the one in red, is greatly surpassed in both metrics.
 

However, if we look on the chart on-top, in 2017,  we see a golden opportunity, in the form of a golden bar: This is Lebanon’s Human Capital Index; which at a fraction of the budget, performs relatively close  to the two economic powerhouses of the region. 

This is where Lebanon can do trade! This is Lebanon’s niche!
You are Lebanon’s niche! 

And here are the solution details summarized 

‘While in Lebanon, the Lebanese youth should work  to obtain then commercialize patents in the digital service space.’- This is the Solution!  

This will diminish inflation, brain drain, unemployment, and offset copycat strategies! 

For the detailed version of the solution, please examine the visual above. 

And, to validate that Lebanese ideas are commercially lucrative 

According to the IMF, Lebanon ranks second in terms of Venture capital investment as a % to GDP. The United States ranks 1st with 2.84%, Lebanon comes in a close-second with 2.8%  
– so experienced investors see great potential in Lebanese talent! 

And in being part of the solution, I’m in the process of launching MSBA.io! – a site dedicated to the MSBA Alumni, where they can tell their stories, share their portfolios and get discovered; there will even be a collaboration section where they can work on projects to help build up the Lebanese tech scene!

So, this story has not ended; it is only just beginning! 

Thank you! 😊 

 —————-

References:

National Debt & Population Income

National Debt & Population Income

Does a Country’s Borrowing Policy Affect its Population’s Income level?

The Case of Lebanon

 

DOLLAR? LBP?       

WHAT’S THE EXCHANGE RATE TODAY?

DISCOUNTING CHECKS? AT WHAT RATE?

WHAT????     20%????

THIS MEANS I’M LOSING 80% OF MY MONEY!!!

I WAS DOING OK BUT NOW I CAN BARELY MAKE ENDS MEET…  

 

This has unfortunately been the sad reality that
theLebanese people have been living for since
October of 2019.

 

WHY?

 

Because a Banking | Financial | Currency | Crisis

Made a Huge Bubble Burst!                                             

 

 

BUT HOW DID WE GET HERE?

Lebanon has had a budget deficit for over 20 years
and has been borrowing from external parties
for as long as we can remember.

So, as Lebanese citizens, we are born indebted.

 

A country’s national debt affects its population’s income level:

  • Growing debt has a direct effect on economic opportunities

  • If high levels of debt crowd out private investments, workers would have less to jobs do and therefore earn lower wages

Countries with LOWER DEBT exhibit HIGHER INCOME levels per capita.

 

SO HOW HAS LEBANON’S DEBT BEEN CHANGING OVER TIME?

 

WHAT CAN WE DO TO MAKE THINGS BETTER?

Potential Solutions include but are not limited to:

  • Supporting Production and Services Sectors leading to more Job Creation and eventually More Wages

  • Improving Trade Agreements leads to more exports which would Reduce Budget Deficits and make the country economically healthier

  • Attracting Foreign Direct Investments by providing a healthy capital market (ex: improving Reporting Practices) which leads to More Investments & More economic opportunities, More Jobs and eventually More wages

 

IS THERE PROOF?

                                            

Countries with Open Trade Policies seem to have higher income levels

 

Countries with Updated Reporting Practices also have higher income levels

SO, WHAT ARE THE RECOMMENDATIONS?

STOP borrowing from international Agencies

CONTROL High National Debt Levels

 

Implement Policies to boost the economy