Thursday, June 19, 2014

Birthday Distribution - How common is your birthday?

The date of birth marked on a high school mark sheet is treated as official birth date in India. So I tried to see how are the date of births on the mark sheets of Rajasthan Board students are distributed across the days of a year.

I had used around 3 million students DOBs for the analysis.


While, to me, at first look, the numbers look quite skewed, as July alone accounts for over 21% people's birth.


1st July, the day when the government schools open after summer holidays, seems to be the most popular birthday!

1, 5, 10, 15, 20, 25th days of a month seems to be most popular while choosing a day to be born !!  I leave it for you to trust the official date of births to be original.

Date of Birth Distribution - Heat Map
*I had removed 13 records where the date of births were inconsistent such as 31st June.
**An excel sheet got corrupt - taking away data for around 6,00,00 students of year 2012 :( :(