Connect and get the inside scoop on Airline Companies

Welcome to Airline Pilot Forums - Connect and get the inside scoop on Airline Companies

If this is your first visit, be sure to check out the FAQ. Join our community today and start interacting with existing members. Registration is fast, simple and absolutely free.


User Tag List

Post Reply
 
Thread Tools Search this Thread
Old 09-17-2020, 10:01 PM   #1  
Gets Weekends Off
Thread Starter
 
NotMrNiceGuy's Avatar
 
Joined APC: Oct 2015
Posts: 328
Default Check My Math

So, I’ve been bored lately and made a few spreadsheet to compare different aspects of COVID. The first area I focused on was a comparison between the USA and a comparable population size in Europe. The countries I selected in Europe were: Italy, Germany, Belgium, Sweden, Spain, France, and the U.K. These countries have a population of 344.7 million compared with the USA’s 331 million. I corrected the final numbers for population.

CASES DEATHS % Death Total POP Tot Tests


Europe 2,084,038 157,570 0.0476% (1 in 2100)* 67,341,545



USA 6,874,600 202,213 0.0615 (1 in 1635)* 95,235,000

The mortality rate represented when comparing the two regions is significant. Europe comes in with 7.56% mortality compared with 2.94% for the US. It is difficult to say what this means due to the number of tests done in the US. The US testing was 40% more when corrected for population which likely means I higher number of cases discovered. This larger denominator could perhaps drive down the mortality rate. It is likely that Europe has had more cases that have not been discovered.

*For reference, odds of dying in a fire is 1 in 1498.

The next area of comparison was across age groups. My reference point came from the CDC. My population death rates came from 2007 and I used total USA deaths from 2018. The data was difficult to find, so I had to do some interpolation, but the gist should be similar.

Death Rate/100000 Death
35-44 185 24,466
45-54 421 55,677
55-64 878 116,116
65-74 2,011 265,955
75-84 5,012 662,837
85+ 12,947 1,712,241

Total Death
2,837,292

The above numbers indicate all deaths in the US in 2018.

The below numbers are from the CDC. They are a few weeks behind. Total deaths at this point were 180K. I believe now it is over 200K.

Death Rate/100000 Total Deaths % COVID Deaths
35-44 28 3,675 2.04%
45-54 73 9,694 5.38%
55-64 175 23,134 12.83%
65-74 296 39,129 21.70%
75-84 364 48,136 26.70%
85+ 427 56,525 31.35%

Total Death
180,293

It is clear to see that the lion’s share of death is over the age of 65, coming in at 79.75%.

By dividing the number of COVID deaths by the annual deaths for each age group, you can determine the added rate of death stemming from COVID, respectively. For example, there are 3,675 deaths from COVID so far in the 35-44 age group. In 2018, there were 24,466. COVID deaths add a roughly 15% rate of death in this instance. Here are the other death rates broken down by age group.

Age % Increase

35-44 15.02%
45-54 17.41%
55-64 19.92%
65-74 14.71%
75-84 7.26%
85+ 3.30%

An observation that jumps out is that the age groups with the most risk from COVID have the least amplification of that risk.

The next section compares the number of deaths to the total population of that age group.

Age COVID Deaths Population % of Population
35-44 3,675 41,213,474 0.0089%
45-54 9,694 41,577,706 0.0233%
55-64 23,134 42,224,249 0.0548%
65-74 39,129 30,449,183 0.1285%
75-84 48,136 15,375,856 0.3131%
85+ 56,525 6,544,300 0.8637%

This example shows that although the 85+ age group is most at risk, COVID still accounts for less than 1% of this segments source of death. Again, 2018 population numbers were used as a source of interpolation.

The final grouping of numbers shows the current odds of death for each age group. The COVID Bump was then applied to determine the odds of death during the COVID Pandemic. Keep in mind, only six months of the year have past, so the data is incomplete.

Age 2018 Deaths Segment Population 2018 Odds of Death COVID Chance
35-44 24,466 41,213,474 0.0594% 0.06828%
45-54 55,677 41,577,706 0.1339% 0.15723%
55-64 116,116 42,224,249 0.2750% 0.32979%
65-74 265,955 30,449,183 0.8734% 1.00194%
75-84 662,837 15,375,856 4.3109% 4.62396%
85+ 1,712,241 6,544,300 26.1638% 27.02758%

As you can see, the risk jump for each group due to COVID is surprisingly low. The chance of death for someone in the 35-44 group goes from 0.0594% to 0.068% (15% jump). A 15% jump sounds like a lot, but when the odds are 1/1685 to begin with, not so much. The likelihood for someone 85+ to succumb to COVID as opposed to a non-COVID year went from roughly 1 in 3.82 to 1 in 3.7.

A couple of things in closing.
- I am keenly aware that all death is a tragedy, and by no means do I want to minimize anyone’s experience with sickness and death. My father is 75 and I don’t want him anywhere near this thing.
- I am not a statistician (but I did stay at a Holiday Inn last night). This project was borne of boredom. Feel free to critique or teach me some tricks of the trade. I’d like to know how to better interpret the data.

I really just thought there may be some interest in the data. I know it certainly is interesting to me.

https://www.cdc.gov/nchs/data/dvs/Mo...rktable23r.pdf

https://www.cdc.gov/nchs/nvss/vsrr/c....htm#AgeAndSex

https://www.worldometers.info/coronavirus/#countries
NotMrNiceGuy is offline  
Old 09-17-2020, 10:11 PM   #2  
Gets Weekends Off
Thread Starter
 
NotMrNiceGuy's Avatar
 
Joined APC: Oct 2015
Posts: 328
Default

Sorry about the data being all crunched together. It looked beautiful when I hit submit.
NotMrNiceGuy is offline  
Old 09-19-2020, 06:09 AM   #3  
Gets Weekends Off
 
Escargot's Avatar
 
Joined APC: Oct 2019
Posts: 241
Default

Good technical analysis.
Escargot is offline  
Old 09-19-2020, 07:05 AM   #4  
Perennial Reserve
 
Excargodog's Avatar
 
Joined APC: Jan 2018
Posts: 6,264
Default

The risk jump in relative terms attributable to COVID is surprisingly low, but the risk jump in ABSOLUTE terms is huge.

Take these figures from the UK (first ones I found when I searched) on all cause mortality:




an 85 year old male has an annual one chance in six (~17%) of dropping off the twig without coronavirus while a 5-14 year old has roughly one chance in 9000 (.011%). Increasing each number by a similar percentage results in a LOT more senior deaths of senior citizens than it does youngsters. And for special cases such as those living in nursing homes and long term care facilities, the annual deathrate is already 35% without COVID.

In absolute terms, the young and the old have hugely different risk.
Excargodog is offline  
Old 09-21-2020, 04:47 PM   #5  
Gets Weekends Off
 
RI830's Avatar
 
Joined APC: Mar 2011
Position: BD-700
Posts: 1,563
Default

To the OP......You either need a job, a woman, or a hobby!
RI830 is offline  
Old 09-22-2020, 06:09 PM   #6  
Gets Weekends Off
Thread Starter
 
NotMrNiceGuy's Avatar
 
Joined APC: Oct 2015
Posts: 328
Default

Quote:
Originally Posted by RI830 View Post
To the OP......You either need a job, a woman, or a hobby!
Couldn’t be more true! But I live in base and sit reserve. I started watching Ozark this week. Does that count?!?
NotMrNiceGuy is offline  
Old 09-22-2020, 09:57 PM   #7  
Gets Mon-Sun Off
 
TransWorld's Avatar
 
Joined APC: Aug 2016
Position: Up Front
Posts: 3,414
Default

Quote:
Originally Posted by NotMrNiceGuy View Post
I started watching Ozark.
I remember watching Ozark, too. “Go Getters Go Ozark”. I was excited when they started flying DC-9s up and down the Mississippi River.
TransWorld is offline  
Old 09-23-2020, 06:07 PM   #8  
Gets Weekends Off
 
RI830's Avatar
 
Joined APC: Mar 2011
Position: BD-700
Posts: 1,563
Default

Quote:
Originally Posted by NotMrNiceGuy View Post
Couldn’t be more true! But I live in base and sit reserve. I started watching Ozark this week. Does that count?!?
Does it have nudity, extreme violence and other material not suitable for most pilots and small children?
RI830 is offline  
 
 
 

 
Post Reply
 



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Related Topics
Thread Thread Starter Forum Replies Last Post
No news is good news on background check? kuma66 Air Wisconsin 3 04-21-2019 03:11 AM
Application *black eyes* & prospects Spiritant Career Questions 23 03-07-2019 02:17 PM
Check Airman types holymoly FedEx 4 08-15-2018 01:44 PM
Have you ever failed a check ride? Vader Career Questions 85 02-17-2011 12:04 PM


All times are GMT -8. The time now is 08:05 AM.