Cohort analysis cumulative value calculation?
How are the cumulative values for Week 2 and Week 3 calculated? I understand that the Week 1 values are a weighted average, but it's unclear why the other values are so low when the underlying weekly values are much larger.
As an example, here is what I see:
|Users||Week 1 retention||Week 2 retention||Week 3 retention|
Re: Cohort analysis cumulative value calculation?
In your example, the "overall" number for week 3 should be 32.23%
Actually, I don't even know how they are calculating, because
(.3223 * 3304) / 8067 = 13%
so even the 6% value being displayed is wrong by that metric