Here is a chart to show the nights (midnight-6am) in a row when my heart rate was below 50 beats per minute.
Data Analyst
Category: Data Analysis / Analytics
English Premier League Table (before World Cup 22 break)
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):
Maximum Distance Run in 2, 3, and 4 days
After running a 10k today (13th November 2022) after 18k yesterday, I looked at the furthest I had run in a 2-day, 3-day, and 4-day period.
Processing Garmin Watch 24/7 Heart Rate Data in Excel
My Garmin Forerunner 245 watch records my heart rate, stress levels, steps, activities, sleep, location, and much more throughout the day. The resulting data can be viewed on the associated Garmin mobile phone app and via the Garmin Connect web service. The watch is a fantastic piece of technology, but there is no way to…
Lowest Recorded Heart Rate per Night for last Six Months
Below is an Excel chart of my lowest recorded heart rate (BPM) every night for the last six months. Click on the chart to view in full size. There is not a huge amount to say about it except that my lowest heart rate each night has been below 50bpm much more often since the…
Running Training 2021 – 08Apr21
Today I used Excel to compare my current training for a half marathon in early September 2021 with the training of my friend who is training for the London Marathon in late April 2022. I looked only at runs of over 5km so far (8th April) in 2021 with my data coming from my own…
Premier League Football Match Odds Visualisations – 31Mar21
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…
Effect of Vaccination on the Distribution of Weekly Covid-19 Deaths in England
I took a look at the latest Covid-19 daily deaths in English hospitals statistics, available to download from the NHS website here: https://www.england.nhs.uk/statistics/statistical-work-areas/covid-19-daily-deaths/. They include a weekly breakdown by age of those who have lost their lives after testing positive for coronavirus. The Excel chart above shows the number in each age-group who died with…
Analysing Concept 2 Rowing Data – Sprints – Heart Rate and Power Output
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…
Coronavirus Worldwide Analysis – 19Mar21
Using the Coronavirus Pandemic Dataset, downloadable: https://ourworldindata.org/coronavirus-data from Our World in Data, I looked at how the number of deaths attributed to Coronavirus is changing for various countries. I selected only those countries which have a population in excess of 2 million, and which had already suffered a total of at least 500 deaths per…