General Discussion
In reply to the discussion: Good news on the case growth trend. [View all]progree
(12,995 posts)I'll have to dig up my notes, but what I might do when I get more time is:
Create a column of the log of the cases. E.g. Log(10,000 cases) = 4
If the daily percentage increases were constant for example, or random noisy around a constant, then a straight line would fit the log cases column, and Excel's simple linear regression capability would find the best fit line.
But since daily percentage increases are clearly trending down:
I'll fit a 2nd order polynomial to that log cases column, or a 3rd order polynomial, or whatever. Via Excel's linear regression functionality (which can be extended by some trick to fit polynomials or other types of curves)
I'll have to study the logistics curve too in that video and see if I can figure out how to get Excel to fit that.
Thanks again