Data Geek Challenge III - Analyzing World's Top 500 Billionaire's

[Former Member]

Hello All,

I am presenting my story on the World's top 500 richest person on the globe. I am writing this analysis under the "House of Dragons" - Our Business Prevails.

Data Source : http://www.forbes.com/billionaires/list/

Analysis:

1) Below screen shot will tell us the sector which are more dominating in the economy. Most of the conglormartes comes from Retail, Diversified(Having more than one industry's busniess), Software, Real Estate, Internet(including e-commerce), Telecom, Beverages and Hedge Funds. On aggreagation basis,

Industry	Total Wealth (In Billion Dollar)
Retail	395.30
Diversified	360.60
Software	314.20
Real-Estate	190.10
Investments	168.20
Internet(E-Commerce)	143.50

By simply move the cusror on the area, it will give the name and weatlh assocaited with this industry.

Conclusion : Above are the top six trending sector which makes most of the billionaries so if you want to be billionaries better have industry/busniess area in those heavy economy boster sector. The probablities to become billionaire will be more than :wink: ! All the Best :smile:

2) Below is the pie chart consist of Country's name, Wealth associated with it and Number of Billionaire

Conclusion:

Number of Billionaries	Country	Total Wealth(In Billion $)
175	USA	1846.20
34	Germany	234.30
31	China	224.10
27	Russia	227
20	India	163.60

35% of the World's top 500 billionaires comes from USA holding 43.34% of total wealth created by top 500 billionaries! So if you are from USA, you have good chances to become billionaire! Cheers :wink:

The same analysis in another form, it gives aggragate wealth of the biilionairesof the corresponding country. USA is clearly a outperformer in this regard. Except USA all others countries cumalative wealth of their Billionaires falls under 0-380 Billion Dollar which is far less than USA figure of $1846B. This figure is almost 5times to every country's cumalative.

Country	Total Wealth (In Billion Dollar)
USA(Highest)	1846.20(43.34%)
Swaziland(Lowest)	3.70

3) Below is the pie chart gives the Name,Rank, Souce of Wealth, Wealth and Country of all the 500's Billionaries

We can have look of billionaries country wise for a specific countries by filtering the value based on citizenship. World's top 5 Billionaries are :

Rank	Name	Source	Wealth(In Billion $)	Citizenship
1	Bill Gates	Microsoft	82.4	USA
2	Carlos Slim Helu & Famliy	Telecom	79.5	Mexico
3	Warren Buffet	Berkshire Hathway	71.1	USA
4	Amanico Ortega	Retail	58.8	Spain
5	Larry Elison	Oracle	50.9	USA

Conclusion: Nearly 88% of world's 500 billionaries having wealth in the bracket of {0-18}$B

4) Below is the bubble chart which depits the individual contribution in percentage to the cumilative wealth of 500's.

Conclusion : The circle depicts, the highest contribution remains 1.96% of total Wealth, obvisouly by Rank 1 while lowest remains 0.08% (Rank Last).

5) Below is the pie chat for the contribution of wealth on Gender Basis.

 

Contribution By	Wealth(in Billion $)	Total
Male	4070.50 (91.57%)	459 (91.8%)
Female	374.90 (8.43%)	41 (8.2)

Conclusion : There are 459 Males Billionaires and 41 Females Billionaire's in World's 500 Billionaries. The contribution of the Male's Billionaire is $4070.50B and Female's Billionaire is $374.90 in the total wealth creation by 500's Billioanires.

6) Below is the tree map for the wealth creation on gender basis by each country.

Distribution of Male's and Female's in 500's Billioaire List. This distribution pattern implies that female's billionaires are much more less in number and in the range of 1-100 Rank they are in countable state.

7)

This graph shows the maximum and minimum age of Billionaires in 500 range. The minimun stoods 30 and the maximum is 97. Most of the billioanires are having wealth in the range of $(0-20)B, which we have already seen in Section 3 and this range is preciesly $(0-18)B and age in the range of 50-80 Years. So guys the favourable age to become billionaire starts from 50. Till that stick to your plans and carry on with Hard Work. There is no shortcut to Success! :smile:

This radar view of Wealth Distribution give the information as below

Gender	Probable Range Wealth (in Billion $)
Male	0-20
Female	0-10

The same info we can get from Box-Plot view, the maximum age is 97, minimum is 30 and the median remains 66.

Maximum Age	97
3Quartile Age	78
Median Age	66
1Quartile Age	55
Minimum Age	30

😎 GDP Vs Cumulative Wealth of Billionaire's by Country comparision :

USA outperform others in that comparision also, the highest number of billionaries along with the highest GDP numbers! I will go deep dive in this regard in the blelow analysis as well.

Above is the comparision of three measures in the same graph, GDP, Total Wealth(Country wise) and GDP/Wealth  Ratio.

Here is the Heat Map for the GDP/Total Wealth Country wise. Most of the countries having GDP/Wealth Ratio in the range of 0-44. I prefreably fell that more the GDP/Wealth Ratio, more money is evenly distributed within the citizens of the country. The lowest ratio is for Swaziland - 1.02 while the highest remains for Turkey -215.84.

Country	GDP/Total Wealth Ratio
Turkey (Highest)	215.84
Swaziland(Lowest)	1.02

Cumulative Wealth for all the billionaires falls in the range of $(0-250)B excpet USA for which it is $1846B.

Country	GDP(In Billion $)
USA	16800
Swaziland	3.79

Radar Chart represnts that except two countries China and USA, rest of them having GDP less than $5K Billion and USA is the only nation on the globe to cross $10K Billion mark in GDP.

This bubble chart specifies that there are only 3 countries with more than $4KBillion GDP. These are USA, China and Japan. USA GDP is almost 4times of Japan and twice of China. There are almost 40 countries out of 51 totally in 500's Billionaires list whose GDP is only 10% of USA. The rest are below :

Country	GDP(In Billion Dollar)	Total Welath of Billionaires	Number Of Billionaires	GDP/Total Wealth Ratio
USA	16800	1846.20	175	9.05
China	9240.27	224.10	31	40.11
Japan	4901.53	66.10	8	74.15
Germany	3634.82	234.30	34	15.51
France	2734.95	172.10	17	16.59
United Kingdom	2521.38	91.50	15	27.56
Brazil	2245.67	100.70	12	22.30
Russia	2096.78	247	27	8.49
Italy	2071.31	93.50	9	22.15
India	1876.80	163.20	20	13.09
Canada	1826.77	60.40	8	30.24

These are the ten countries on the globe to watch for! They are the Backbones of the world's Economy.

Good news for the people residing in these countries are their probability of becoming billioanaire's are quite high. Carry on hard work and dream to mak your entry in the list down the line! All the Best.

This is all from my side on this analysis. Any suggestion's/comments for improvement are more than Welcome! As it famous saying :

There is always space for improvement, no matter how long you've been in the business.

Thanks for spending your valuable time!

Regards,

Ankit Maloo

IGATE Global Solutions