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

We develop the previous post and create 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 In February 2020 we looked at the animation below. if 5 people with…