Started By
Message
locked post

Some Coronavirus Spread Analysis

Posted on 3/20/20 at 10:05 am
Posted by Not Cooper
Member since Jun 2015
5051 posts
Posted on 3/20/20 at 10:05 am
I'm doing some analysis on how many actual cases there are in Louisiana (not the number confirmed or reported). These are going to be some huge assumptions and we can play around with the numbers some. This is simply me being a nerd and looking at data.

Based on data released by China and Italy, time from onset of symptoms to death is about 15 days, and incubation time is about 5 days. This gives a general estimate of 20 days from infection to death. Obviously this is an average.

Now for mortality rate. Some places have reported as high as 8%, some as low as 0.6%, but this is just the number of reported cases. I will assume 0.5% for this and we can run different numbers for different rates later.

If 0.5% of the population dies, and it takes 20 days for them to die, then 20 days before the first death, there were 200 infections. Louisiana's first death was on March 16th. That means on February 25th, there were 200 cases.

Now it gets a little bit tricky. In Italy, the number of cases doubled roughly every 3-4 days before they shut everything down. I'll assume that from Feb 25th we doubled every 3 days because we were running business as usual at that point.

That means that by the time of the first death (March 16th), our number of cases would have doubled 6 times. So by the time of the first death, there were already 12,800 cases. Since Italy shut everything down they have been doubling about every 5 days. If we assume the same for us since we've started shutting things down, we've doubled 1 more time since the first death, putting our current number of actual cases at 25,600. Which is about 0.54% of the population of Louisiana. We are currently reporting 392 cases. We are really behind on testing but as the tests begin to ramp up so will the number of cases. If the math is correct (huge assumption lol), then by April 9th we will have around 128 deaths in Louisiana.

This isn't a sky is falling thread I'm just playing with numbers. You can move the mortality rate up and down and the length of time it takes the virus to double and you'll get a wide variety of numbers.


*Based off of estimated 542 cases by COB today. IF ALL RATES REMAIN THE SAME THROUGH MARCH 30*
This post was edited on 3/20/20 at 10:33 am
Posted by castorinho
13623 posts
Member since Nov 2010
88344 posts
Posted on 3/20/20 at 10:07 am to
I was told there would be spreadsheets
Posted by Damone
FoCo
Member since Aug 2016
32966 posts
Posted on 3/20/20 at 10:07 am to
No graphs, no care
Posted by Not Cooper
Member since Jun 2015
5051 posts
Posted on 3/20/20 at 10:07 am to
quote:

I was told there would be spreadsheets

I was not the one who relayed that information. Lies were told.
Posted by tiger91
In my own little world
Member since Nov 2005
40259 posts
Posted on 3/20/20 at 10:08 am to
quote:

Lies were told.


It was the media.
Posted by Not Cooper
Member since Jun 2015
5051 posts
Posted on 3/20/20 at 10:08 am to
quote:

No graphs, no care

Ugh fine, I'll make a graph
Posted by SloaneRanger
Upper Hurstville
Member since Jan 2014
14340 posts
Posted on 3/20/20 at 10:13 am to
I'm not sure that using data from Italy to draw conclusions about the US makes sense. And when the final chapter of this is written, the mortality rate will be lower than .5%. Your basic point that there are way more positives out there than we know is correct. Actually, I think we will never know the true number, because we are now learning that many positives never show any symptoms at all.
Posted by TigerstuckinMS
Member since Nov 2005
33687 posts
Posted on 3/20/20 at 10:18 am to
quote:

Ugh fine, I'll make a graph

Make it pretty. Maybe with kitties and puppies in the corners so it doesn't scare people
Posted by Not Cooper
Member since Jun 2015
5051 posts
Posted on 3/20/20 at 10:18 am to
quote:

I'm not sure that using data from Italy to draw conclusions about the US makes sense.

It's the only data we have. I'm not drawing conclusions I'm playing with numbers here
Posted by Shepherd88
Member since Dec 2013
4950 posts
Posted on 3/20/20 at 10:19 am to
LINK

Spreadsheets on spreadsheets here. It’s tracking % of those tested that are coming out positive. Which is way less than what the media wants you to believe.
Posted by Winston Cup
Dallas Cowboys Fan
Member since May 2016
66986 posts
Posted on 3/20/20 at 10:19 am to
lsupride87 died. got ran over by a mardi gras float
Posted by SidetrackSilvera
Member since Nov 2012
2904 posts
Posted on 3/20/20 at 10:23 am to
Yeah, yeah, yeah. Show me the bodies, please.
Posted by Bamadiver
Member since Jun 2014
4165 posts
Posted on 3/20/20 at 10:27 am to
quote:

You can move the mortality rate up and down and the length of time it takes the virus to double and you'll get a wide variety of numbers.
Which is why analytics are calculated after an outbreak, not during.

Edit: Look to the Diamond Princess.
This post was edited on 3/20/20 at 10:28 am
Posted by iAmBatman
The Batcave
Member since Mar 2011
12382 posts
Posted on 3/20/20 at 10:32 am to
quote:

I'm doing some analysis on how many actual cases there are in Louisiana (not the number confirmed or reported).


How are you getting the number of actual cases if you are not using the number confirmed? Seems like you're making a pretty large assumptions that would totally invalidate your data.
Posted by Not Cooper
Member since Jun 2015
5051 posts
Posted on 3/20/20 at 10:34 am to
quote:

Seems like you're making a pretty large assumptions that would totally invalidate your data.


From my original post:
quote:

These are going to be some huge assumptions

So, yeah. I made large assumptions. That's kinda the whole point. Maybe read the post.
This post was edited on 3/20/20 at 10:36 am
Posted by Not Cooper
Member since Jun 2015
5051 posts
Posted on 3/20/20 at 10:37 am to
quote:

Which is why analytics are calculated after an outbreak, not during.

That's why projecting is a little bit harder than just looking at numbers after. Play with the numbers however you want
Posted by iAmBatman
The Batcave
Member since Mar 2011
12382 posts
Posted on 3/20/20 at 10:38 am to
quote:

So, yeah. I made large assumptions. That's kinda the whole point. Maybe read the post.



I did read it...seems pretty pointless if you aren't going to use accurate date. Why not save yourself so time and just make everything up...looks like that's what you're doing anyways.
Posted by castorinho
13623 posts
Member since Nov 2010
88344 posts
Posted on 3/20/20 at 10:39 am to
quote:

lsupride87 died. got ran over by a mardi gras float
just realized I haven't seen his name. He'd be very active on corona threads. Was he banned?
Posted by Not Cooper
Member since Jun 2015
5051 posts
Posted on 3/20/20 at 10:42 am to
quote:

seems pretty pointless if you aren't going to use accurate date.

So you think that only 479 people in Louisiana have the virus right now? Because that's the only "accurate data" we have. I'm making projections here.
Posted by pistolpete23
In the present
Member since Dec 2007
7285 posts
Posted on 3/20/20 at 10:42 am to
What percentage of these have underlying medical issues already?
This post was edited on 3/20/20 at 10:44 am
first pageprev pagePage 1 of 2Next pagelast page

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on X, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookXInstagram