Data Analyst
Looking at the results in the English football Premier League as we hit the break for World Cup 2022 on 13th November 2022. Matches shown for each team as green for a win, amber for a draw, and red for a loss (raw match result data from https://fixturedownload.com/results/epl-2022):
Today I took a look at the odds for the next couple of rounds of football matches in the Premier League after the international break. I imported the data directly into Excel from https://www.oddschecker.com/football/english/premier-league. I removed the columns of data I was not interested in using Power Query, and split the odds columns in two…
The international break is the perfect time to take a look at the state of the Premier League and the form of the teams with more than three-quarters of the 2020-2021 season completed. All match results and fixtures are available here: https://fixturedownload.com/download/xlsx/epl-2020, downloadable in Excel format. This file gives the round number, match date, match…
Looking at some more Concept 2 rowing machine workout data – this time from a sprint/interval session (20 seconds @ 90% of max effort, 1 minute rest, repeat 20 times.)The Concept 2 Performance Monitor only records a line record of data when a stroke is pulled, therefore it does not record anything during the 1…
The Concept 2 ergometer (indoor rowing machine) has a performance monitor which will output CSV files of data relating to individual workouts. Pictured below is a small snapshot of the data contained within these files (I added the Time(mins) column).The machine takes a reading once per rowing stroke and saves a record index value (Number),…
Which are the Premier League football teams currently in form?I imported the Premier League table from https://www.bbc.co.uk/sport/football/tables into Excel via Power Query and used some M code to find the number of points earned by each team in their last 5 matches played (Last5Pts). I then calculated the league position for each team if it…
Having previously read in the BBC weather forecasts from the web using Power BI, today I attempted to read in and process the latest betting odds for the next 14 matches of Premier League football from https://www.oddschecker.com/football/english/premier-league. Initially it seemed like a very simple task, but then it turned out that the oddschecker.com sometimes changes…
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…