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)

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

CasesRoCase10P1BFormulaRo

Welcome

Shared Posts (Pingbacks)