Answered step by step
Verified Expert Solution
Question
1 Approved Answer
THE EXCEL DATA BELOW: Watershed is a media services company that provides online streaming movie and television content. As a result of the competitive market
THE EXCEL DATA BELOW:
Watershed is a media services company that provides online streaming movie and television content. As a result of the competitive market of streaming service providers, Watershed is interested in proactively identifying will unsubscribe in the next three months based on the customer's characteristics. For a test set of customers, the file Watershed contains an indication of whether a customer unsubscribed in the past three months and the classification model's estimated unsubscribe probability for the customer. In an effort to prevent customer churn, Watershed wishes to offer promotions to customers who may unsubscribe. It costs Watershed $10 to offe a promotion to a customer. If offered a promotion, it successfully persuades a customer to remain a Watershed customer with probability 0.6, and the retaining the customer is worth $60 to Watershed. Click on the datafile logo to reference the data. DATA Assuming customers will be offered the promotion in order of decreasing estimated unsubscribe probability; determine how many customers Watershed should offer the promotion to maximize the profit of the intervention campaign. Compute the average profit from offering the top n customers a promotion as: Profit = Number of unsubscribing customers in top n (P( unsubscribing customer persuaded to remain )(6010) +P( unsubscribing customer is not persuaded )(010)) + Number of customers who don't intend to unsubscribe (010) The maximum profit of $ occurs when customers are offered the promotion. Watershed is a media services company that provides online streaming movie and television content. As a result of the competitive market of streaming service providers, Watershed is interested in proactively identifying will unsubscribe in the next three months based on the customer's characteristics. For a test set of customers, the file Watershed contains an indication of whether a customer unsubscribed in the past three months and the classification model's estimated unsubscribe probability for the customer. In an effort to prevent customer churn, Watershed wishes to offer promotions to customers who may unsubscribe. It costs Watershed $10 to offe a promotion to a customer. If offered a promotion, it successfully persuades a customer to remain a Watershed customer with probability 0.6, and the retaining the customer is worth $60 to Watershed. Click on the datafile logo to reference the data. DATA Assuming customers will be offered the promotion in order of decreasing estimated unsubscribe probability; determine how many customers Watershed should offer the promotion to maximize the profit of the intervention campaign. Compute the average profit from offering the top n customers a promotion as: Profit = Number of unsubscribing customers in top n (P( unsubscribing customer persuaded to remain )(6010) +P( unsubscribing customer is not persuaded )(010)) + Number of customers who don't intend to unsubscribe (010) The maximum profit of $ occurs when customers are offered the promotionStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started