Data Analyst
Looking at the fastest one-hundred 100 metre runs in history with raw data from WorldAthletics.org throws up some interesting statistics. There are a lot of athletes who have run a top 100 time who have served doping ban(s): Those who have served a doping ban are in italics in the table above. 68 out of…
I was just looking at the best one-mile running race times in history, inspired by my own ‘best’ one-mile time of around 7 minutes 30 seconds. Below is a list of the fastest fifty one-miles ever run. British runners are highlighted, because patriotic. [Raw data from WorldAthletics.org] Looking deeper, only two of the fastest fifty…
I run a wide range of distances from 5k up to (soon) half marathon, and I wanted to find a way to compare the relative quality of those runs. For example, which is the better achievement, a 10k in 53 minutes or a 5.9k in 28 minutes. I found and read this article (https://rat.run/articles/content/age-grading) about…
I have continued experimenting with Microsoft Power BI trying to find situations in which it is faster and easier to use than Excel for data visualisation. If I find something faster and easier in Power BI (in which I have <=0 experience), then it really must be a strong use case for the application. Looking…
I collected data for one month on the timestables.me.uk website from the Online Times Tables Test to look at which questions were most commonly answered correctly or incorrectly. During the month chosen, there were 1.2 million times tables questions answered by schoolchildren from around the world of which 91.4% were answered correctly. Looking in more…
My generic Chinese fitness watch measures my heart rate and sleep patterns 24/7. It has an associated app which displays very high level summary information on my phone via an associated app. The watch does however send all the data it has collected in a very non-standard file format every day via Bluetooth to my…
ESPN have scorecards online of every test cricket match ever played, but unfortunately not in a very easy way to download and analyse offline. They have one webpage per calendar year – for example for the year 1946, the URL: https://stats.espncricinfo.com/ci/engine/records/team/match_results.html?class=1;id=1946;type=year, gives the page that has a list of the test matches played that year.…
The biggest problem with renewable energy is intermittency – to generate solar power you need the sun to shine; to generate wind power you need the wind to blow. You can easily estimate how much power will be generated on average per month or per year, but that is not much help when you need to supply…