In this project I analysed the top 20 Billionaires of year 1996, 2001, 2014 & 2022.
Data collected from Kaggle.
This is how our data looks after cleaning it in Excel.
First we see the year-wise change in the Net Worth of Top 20 people.
So we can see that the increase in wealth has undergone a steep rise from 2014 to 2022.
Next let's see which industries are these people associated with.
We can see that Consumer, Real Estate, Retail & Restaurant, Money-Management, Media & Computer-Technology make up almost 67% of all the industries.
Let's see the Top 6 Industries.
Now we saw from the dataset that there are a total of 73 countries from which these Billionaires belong. Having more number of Billionaire will definately affect the country as that implies more revenue & tax collection, job creation and manufacturing.
Let's see the top 20 countries which have the most Billionaires.
So we can see that United States of America has the most Billionaires, which is almost 6 times that of the next country and more than the sum of next 10 countries. That certainly explains why USA is considered a rich country.
Now let's see how the sum of Top 20 Billionaires has changed over the years. Our dataset has values for the Years 1996, 2001, 2014 & 2022.
So we can see that the total of net-worths of top 20 Billionaires has increased more by the year.
We can also see the change in total net-worth of Billionaires by countries over the years.
We can see from the above graph that USA, India and France in that order are the biggest collaborators to this steep increase in growth over the years.
Let's see the percent change in each country's increase.
So we can see that USA saw a big increase from 1996 to 2001 and since then has not grown as much, whereas India which is not even in the top 10 till 2014 has suddenly become the 2nd biggest contributor in 2022, and France has had a steady growth since 1996 to 2014 but not much since then.
Now let's see the distribution of this wealth by Industry.
We can see from the above charts that Real Estate which was the top contributor of wealth in 1996 has gradually decreased since then and has totally dropped out of the top 20 people's wealth by 2022, whereas as Consumer, Retail and Computer Technology are slowly becoming the top contributors to Billionaires wealth.
Now let's see what is the male-female ratio of Top 20 Billionaires over the years.
We can see that the percentage has increased drastically from 1996 to 2001 but has dropped since then. One reason a lot of women are dropping out of work force in a lot of countries is that as wealth of the family increases, women choose to or are made to stay at home instead of going to work. This has also declined the percentage of women in workforce world-wide by a significant amount.
Now, let's see how many of these Billionaires have inherited their wealth and how many are self made.
We can see from the charts that the percentage of people who Inherited their Billions increased from 1996 to 2001, but is decreasing gradually since, and a rise in the percentage of Self Made Billionaires is visible.
Finally, let's see how many people have been in the Top 20 list and how consistent they are. So from the data we know that there are a total of 51 people in the list of Top 20 during the specified years.
We can see that more than 25% of these people have been in the Top 20 Billionaires List for more than 10 years.