Blog Archive

Wednesday, May 28, 2014

Mining through running stats

Recently, TCS 10k run was held which was organized quite well except for the part where people had to do commando over a puddle of water.

Anyways, coming to the point. The data for it is publicly available which made me wonder that some interesting charting can be done on it and may be some insights too.

The following charting has been done on Open 10k only.


1. Average time across age groups  
15 to 20 years 20 to 30 years 30 to 40 years 40 to 50 years 50 to 60 years 60 to 70 years 70 years and above 01020304050607080Minutes



The youngest age group clearly has the minimum time and the reasoning for it is obvious so no need to dwell over it. The 20 to 30 years have all kind of people running and mostly the 1st time runners because of which they have a higher average time. Subsequent age groups, People are more serious about running


2. Average time across gender

FEMALE MALE 0102030405060708090Minutes


3. Maximum time across age groups

15 to 20 years 20 to 30 years 30 to 40 years 40 to 50 years 50 to 60 years 60 to 70 years 70 years and above 020406080100120140160Minutes


If you look at the max time across the age groups, its evident that the last person stepping the finish line is not only getting wiser but also is faster


4. Minimum time across age groups
15 to 20 years 20 to 30 years 30 to 40 years 40 to 50 years 50 to 60 years 60 to 70 years 70 years and above 051015202530354045505560Minutes

In the end, the fastest always have the age advantage

5. Distribution of people across age groups
15 to 20 years 20 to 30 years 30 to 40 years 40 to 50 years 50 to 60 years 60 to 70 years 70 years and above 45.4%36.9%12.2%


6. Overall gender distribution
FEMALE MALE 16.7%83.3%

7. Gender distribution across age groups
FEMALE MALE 20.6%79.4%


You can click on the buttons to see the specific category distribution. The younger lots have more female participation which is a good sign. Hopefully in the coming years, there will be a more even number of participants.

8. Distribution of people across age groups and different time intervals
100Minutes05001,0001,5002,000Number of People02,27715 to 20 years20 to 30 years30 to 40 years40 to 50 years50 to 60 years60 to 70 years70 years and aboveStackedStreamExpanded


This chart is quite an informative one which tells how many people finished at a given time interval across different age groups.

I'll leave the inference for this up to you.

oh yeah, the chart is interactive so you can go ahead and click on those small circles.

No comments:

Post a Comment