I need the excel sheet formatted with the correct formulas in the cell.
HW assignment:
Questions
Use high-end (HE) customer churn data provided in the MS Excel workbook “Homework 3.xlsx”
to estimate the following models
1. The shifted Geometric model
2. Two segments shifted Geometric model
3. Three segments shifted Geometric model
4. Shifted Beta Geometric model
Provide the following in your answer:
– Excel sheet for model parameter estimation and predictions with calibration and hold-
out MAPE computation, and a line plot for # of actual versus predicted customers alive
with years
– Compare the MAPE from the two models and explain which one is better.
– Compare the line plot for # customer alive with years for all customers and HE
customers in the same plot.
– Compare and comment on the heterogeneity in churn rate (θ) from the sBG model for
high-end customers with the one obtained for regular customers in Lecture 02.02D.