COVID Odyssey: NZ New Year Fear 25 Post #952~ COVID-19 NZ~ Calculating Re over two cycles using Goal Seek

We want to estimate Re and hence Ro and COVID-19 spread when the period of infection is over two five day cycles. We have weights w1 for Cycle 1 and w2 for Cycle 2 where w1 + w2 = 1 or w2 = 1 – w1. Let C be the number of new cases in…