Executive Solution Overview
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. Thr…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
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.
\
Homework3data.xlsx](https://www.sweetstudy.com/files/homework3data-xlsx "Homework3data.xlsx")
Leave a Reply