Covid 19 stats, part 4

Some good news.

For the first time since mid-March, excess deaths are below the five year average. Regular readers will know that I have been tracking “excess deaths” (based on data provided by Office for National Statistics ) as it strips out any debate as to whether a death was due to Covid 19 or not. Instead, it compares the number of deaths in a week to the five year average for the equivalent week.

The graph above does not mean we are out of the woods yet (as I write, Leicester is being placed in to local lock-down to combat a regional spike) but it does give cause for hope.


(note: week 25 is the week ending 19th June 2020. Week 11 – the last time excess deaths were negative, was the week ending 13 March 2020)

Posted in Uncategorized | Leave a comment

Covid 19 stats, part 3

I continue to crunch the numbers, and explore different ways to display the data.

In the graphs above, I have taken the total number of weekly deaths in England and Wales (as reported by Office for National Statistics) and subtracted from that the average number of deaths for that week.

Before the outbreak of Covid 19, 2018 had been a “bad year” for deaths, with the weekly death rate often being above the 5 year average (see graph of cumulative deaths, below) so I plotted that – on the same scale – to make an easy comparison with the tragedy of this year.


Posted in Handling Data | Leave a comment

Covid 19 stats, part 2

Data can tell us many things, but we need to understand what data we are looking at, and what the data is showing us. As the Covid crisis has continued, there has been debate and discussion about how many deaths are due to the disease.

The government, daily, discloses the number who have died in hospital from Covid-19, but this only tells part of the story as many are dying from the virus in care homes and, possibly, at home.

How do we know the true impact the virus is having?

One way is to look at total deaths per week, and compare them to equivalent weeks in years gone by.

The data is all available at the Office for National Statistics  and I’ve used the data to generate the graphs above.

Its quite clear that, whilst there is variation from year to year, the trend for each year is similar.

Until you reach week 13 of 2020 (week ending 27 March) when the line takes a sinister upwards turn, and does not stop its climb.

By the week ending 17 April 2020 (the last week data is currently available) more than 22 thousand people in England and Wales died in that week, circa 12 thousand more than the average for that week.

12,000 excess deaths in one week alone. A sobering reminder of the deadly effect of the corona-virus.

Posted in Handling Data | Leave a comment

Covid 19 Stats

The unfolding tragedy that is Covid 19 is being fought on many fronts, and data, statistics and mathematics are playing a strong supporting role, by helping to inform what is happening and allow the scientists and politicians make decisions and review the outcome of the policies that have enacted.

Much data is being made publically available, and I have been experimenting with a new tool I have found to display that data. Whilst not up there with some of the excellent graphs and infographics being produced by many sources, I’m quite pleased with what I have achieved. Later this term, I will be teaching (remotely) some of my students how to access the data and use various tools to visualise and interpret said data.

I needed somewhere to host my first couple of forays in this field, so here they are.

Data sources:

Our world in data

Office for National Statistics


Posted in Handling Data, Large Data Sets | Leave a comment

The Good, The Bad and The Ugly

This cartoon is good. Very Good.

(FWIW, I definitely identify as a Pythagorean rather than a Trigonometric)

It came from “The Saturday Paper”, an online Australian newspaper. Here is a link to the original cartoon, and the paper.

And now we contrast it with something that is both bad and ugly. It is perhaps no surprise that this monstrosity comes from Fox News. Just look at that y-axis (if you dare) and weep.

Now go back up to the top of this post and look again at the brilliance of that cartoon. Hopefully it will erase the memory of that shockingly bad graph,

Posted in Maths Fail | Leave a comment