10-16-2020, 02:41 PM
(10-16-2020, 01:22 PM)tomh009 Wrote: Excel only allows two vertical axes, and I have the number of cases on one and the two percentages on the other. If I user a linear scale for the percentages, it is quite difficult to see movement in the positivity rate as the % of actives is roughly 5x the positivity. Not ideal this way, but I decided it was better than the other way
Positivity is up in the last five days, but that's partly because the number of tests is down by 20-25%. The two are interlinked and it's hard to know how exactly much of the positivity to attribute to the lower number of tests.
Indeed, that is my question as well.
I wonder how much validity there is in simply scaling the cases by the positivity rate?