Data Analysis of COVID-19: Comparing Dates

--

Never before have we been in so much need for good data analysis than now. As you may know, I love analysing data in all its forms, and COVID-19 is a good opportunity to drill down on data.

So to understand the changes around the death rate in each country, let’s take the death date for two dates (between 2 April and 9 April), and look to see the changes [here]:

COVID-19 Deaths on 9 April 2020 against 2 April 2020 [here]

I have thus plotted 2 April 2020 on the x-axis and 9 April 2020 on the y-axis. So any country above the red line is increasing its rate more than the average, and any country below the red line is reducing its rate against the average. Thus the US, France and UK are above the average, and China, Italy and Iran are below. Spain sits right on the red line. If you are interested, here is the Ordinary least squares (OLS) analysis for the red line, and where the R-squared value is 0.666:

'08/04/2020 = 2.768 * 25/03/2020 + ', '160.791'
OLS Regression Results
====================================================================
Dep. Variable: 25/03/2020 R-squared: 0.666
Model: OLS Adj. R-squared: 0.665
Method…

--

--

Prof Bill Buchanan OBE FRSE
ASecuritySite: When Bob Met Alice

Professor of Cryptography. Serial innovator. Believer in fairness, justice & freedom. Based in Edinburgh. Old World Breaker. New World Creator. Building trust.