1 Attachment(s)
Australia appears to be doing very well indeed...at the moment
CAVEAT: Any figures worked around the number of cases, such as the death rate, have several reasons why they are rubbery, as we have previously discussed (so I won't repeat what they are).
I have done a little Excel work with some of the figures from the Johns Hopkins site, and some interesting things (for me anyway) have come out of it. Firstly here is a screenshot of today's figures, sorted 3 different ways. On the left is # cases descending, middle is # deaths (not death rate) descending, and right is population infection rate (cases/pop%).
Notes:
- white text on red is the worst example, white on magenta is next worst, followed by paler pink. Yellow represents the better examples.
- I was going to talk about 1000+ cases as the cut-off, but as you will see, <2000 cases yields skewed results, so the cut-off in future will be 2000 cases.
- Johns Hopkins talks about recoveries, but eventually they will equal cases minus deaths, and they have a long way to go. Only China appears to be near the end of the cycle (which is pretty encouraging in itself, if it can be trusted....)
- If there is interest I will be happy to post a summary every 2 or 3 days (every 3 probably makes the best sense)
- I may well add a "Continent" field, for another sort. (and I would expect Antarctica to be the world leader of success! :U)
Attachment 470664
Now Bob, as our resident mathematician/statistics guy might have some valuable input here, so please feel free to say so Bob. These are just my observations of these figures. There are a few different stats that could be added to give this more meaning (such as poverty rates, international travel rates, pop density, and so on) but that's just getting on for a bit too much research....:no:
- The number of deaths is pretty much in the same order as the death rates, particularly at the bad end and especially if you take what I would think are dodgy China stats.
- The total population of the countries with 2000+ cases is approx equal to the 1000 to 2000 bracket population (this is only for the moment though)
- WRT only 2000+ cases, the totals for that category for cases, deaths, death rate are more or less the same as for the total world population (blue figures). The population infection rate is very different though.
- European countries are streaking away with Pop Infection Rate (10 of the worst 11 spots)
- By next Wednesday I expect virtually all of the 1000-2000 case countries to be included in 2000+.
- Look at Japan's astonishing figures, considering their population and proximity to China!
- Taiwan, with its 23.82 mill pop, 283 cases and 2 deaths is never going to get on that list! Death rate is 0.71%, PIR is 0.0012% which will in time become the lowest rate of all, I suspect
- Forget India's numbers at the moment, they will explode.
- I also expect figures from Brazil, Indonesia, South Africa, Philippines, Pakistan to deteriorate badly and rapidly. Maybe even Russia.... if they tell the truth.
- WRT only 2000+ cases, Australia is almost at the bottom of deaths and death rate, and not far off that for Pop Inf Rate. This might change, but that gives me quite some hope that we are doing pretty well.
*I have just noticed that some of the colour coding is wrong so I will fix it, and upload again.