Compare the mape from the two models

Assignment Help Other Subject

Reference no: EM133898985

Question

Use high-end (HE) customer churn data provided in the MS Excel workbook "Homework" 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.

Attachment:- Homework data.rar

Reference no: EM133898985

Questions Cloud

What external threats are facing by the canopy growth : How does the "Canopy Growth" company fit into the cannabis industry overall? What external threats are facing by the Canopy Growth?

What resources have you used to help overcome challenges : What resources (UOPX resources or otherwise) have you used to help overcome challenges? How do you see these enhanced skills benefiting your future career?

How do these funding categories interact to support the goal : A line-item appropriation for developing a new therapy wing. How do these funding categories interact to support the program's goals?

How do matrix structures and product team structures differ : How do matrix structures and product team structures differ?

Compare the mape from the two models : Compare the MAPE from the two models and explain which one is better and Compare the line plot for # customer alive with years for all customers and HE customer

Potential impacts of the types of financial risk : Describe the potential impacts of the types of financial risk on the Walt Disney Company based on the quarterly report

What have you always been naturally good at : What have you always been naturally good at?; What issues or problems do you feel the most strongly about?; How do you like to work?

What specific quality and pricing factors are you using : For your Product Buying Analysis on semiconductor chips, what SPECIFIC quality and pricing factors are you using to assess your suppliers?

Develop an action plan to mitigate the risks : Develop an action plan to mitigate the risks. Review how you will use technology to understand the voice of the customer.

User Account

All Pages