Improve the retention model in excel in two ways

Improve the retention model in excel in two ways
Deadline:24:00, 20 March GMT+0

Take a constant churn rate that affecting all cohorts as example

There are two ways in which you could improve this model. The first is for the
model to base retention on an average of the cohort retention decay curves for the
product. For example, you could create a new tab on the spreadsheet (and call it
“General Retention Metrics” for example). Then build a table on this tab with sample
data mirroring the shape of the green (top)or yellow (middle) curve from the
diagram below (which you’ll recognise from our lectures). You can then change the
Retention tab on your model to access data from this table for the retention figures
in your model instead of a simple fixed percentage. This would mean that retention
figures in your model then followed realistic retention behaviour. And changing the
cohort data in the General Retention Metrics would cause the Retention tab to
reflect these changes.