COVID Odyssey: NZ New Year Fear 23 Post #950~ COVID-19 simulation~ Table: COVID-19 spread using a formula

We have developed in the previous post a formula to use instead of using Goal Seek in Excel. Our formula when r = 1.4 (daily increase in case numbers of 1.4) is:

R = SQRT( (10 x 1.4^10)/10 – 3/4 ) – 1/2

See:

COVID Odyssey: NZ New Year Fear 22 Post #949~ COVID-19 simulation: COVID-19 spread using a formula instead of Goal Seek

This enables us to generate the table below:
(See column R)

FormulaCalculationTable

This PDF may be easier to read:
(See columns R 5 Day and R 6 Day)

CasesRoCase10P1BFormulaRo

Welcome

Shared Posts (Pingbacks)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s