Reposting for the morning pedes

I pulled the latest data available from https://www.worldometers.info/coronavirus/#countries for the China Flu because I was curious what the data showed.

Here are some screenshots of the spreadsheet I created. I will happily upload this somewhere, but I don't know where to share excel docs and I'm not using a Google Drive because fuck Google.

https://imgur.com/lVxJYoS

https://imgur.com/UNUTlHD

https://imgur.com/OVENH58

https://imgur.com/cHMpV6L

I have included 166 countries in this spreadsheet but have not included the ones where number of tests performed is unavailable. I also did not include China because they are liars and nothing they say is true.

Methodology:

Positive Test Rate was calculated by dividing number of cases by number of tests for each country.

Extrapolated Cases was calculated by multiplying positive test rate by total population

Death Rate was calculated by dividing "confirmed" deaths by total extrapolated cases.

Why did I do it this way? Because this is EXACTLY how the CDC calculates the flu numbers every year.

Findings:

The average positive test rate across the world is only 9.82%. 90 tests out of 100 are negative.

The median positive test rate across the world is 5.09%. 95 tests out of 100 are negative.

The US is currently at a 17.31% positive test rate, while France is at a 35.89% positive test rate.

Conversely Germany has a 6.33% positive test rate and Portugal has a 6.46% positive test rate

Using the average test rate across the world shows 572,344,035 cases which puts the world death rate at 0.0389%

Using the median test rate across the world to extrapolate total cases shows 296,481,154 cases which puts the world death rate at 0.0751%

For comparison In the United states the flu is usually around 0.095%.

The highest death rates in the world are Italy (0.4297%), Spain (0.3100%), and Belgium (0.3066%). San Marino does have a 0.4797% death rate but is estimated to only have 8,547 cases.

The United States Death Rate is 0.1073% while the UK is at 0.1905%

Currently in the US the flu is just as deadly as the coronavirus as a whole for the nation.

Worldwide coronavirus is between 33% and 80% as deadly as the flu (based on the US average flu death rate of 0.095%)