Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

THE EXCEL DATA BELOW:

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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 promotion

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Auditing An Integrated Approach

Authors: Richard Cascarino

1st Edition

0702166693, 978-0702166693

More Books

Students also viewed these Accounting questions

Question

What evidence can you cite for the wave nature of particles?

Answered: 1 week ago

Question

1. What are your creative strengths?

Answered: 1 week ago

Question

What metaphors might describe how we work together?

Answered: 1 week ago