Please explain, in excel. 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 offer a promotion to a customer. If offered a promotion, it successfully persuades a customer to remain a Watershed customer with probability $0\mathrm{.}6,$ and the retaining the customer is worth $$70$ to Watershed.

Click on the datafile logo to reference the 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

$\backslash$times $($P$($unsubscribing customer persuaded to remain$)\backslash$times $(70-10)$

$+$ P$($unsubscribing customer is not persuaded$)\backslash$times $(0-10))$

$+$ Number of customers who don't intend to unsubscribe $\backslash$times $(0-10)$

The maximum profit of $

occurs when

customers are offered the promotion.

Customer $|$Unsubscribe$?|$Probability of Unsubscribe

$5700\mathrm{.}99$

$11100\mathrm{.}99$

$14110\mathrm{.}99$

$15800\mathrm{.}99$

$18010\mathrm{.}99$

$11910\mathrm{.}98$

$14010\mathrm{.}98$

$19110\mathrm{.}98$

$3100\mathrm{.}97$

$3300\mathrm{.}97$

$5800\mathrm{.}97$

$7110\mathrm{.}97$

$12110\mathrm{.}97$

$9610\mathrm{.}95$

$13100\mathrm{.}95$

$19700\mathrm{.}95$

$700\mathrm{.}93$

$2610\mathrm{.}93$

$11610\mathrm{.}93$

$1500\mathrm{.}92$

$5610\mathrm{.}92$

$13000\mathrm{.}92$

$14900\mathrm{.}92$

$17800\mathrm{.}92$

$4400\mathrm{.}91$

$6610\mathrm{.}91$

$900\mathrm{.}90$

$7600\mathrm{.}89$

$14800\mathrm{.}89$

$17200\mathrm{.}89$

$500\mathrm{.}88$

$1110\mathrm{.}88$

$9100\mathrm{.}88$

$13300\mathrm{.}88$

$14700\mathrm{.}88$

$5410\mathrm{.}87$

$19400\mathrm{.}87$

$1800\mathrm{.}86$

$12010\mathrm{.}85$

$15000\mathrm{.}85$

$6410\mathrm{.}84$

$6900\mathrm{.}84$

$13910\mathrm{.}84$

$100\mathrm{.}83$

$12710\mathrm{.}83$

$15700\mathrm{.}83$

$17700\mathrm{.}83$

$14500\mathrm{.}82$

$9410\mathrm{.}81$

$8710\mathrm{.}80$

$12410\mathrm{.}80$

$10000\mathrm{.}79$

$10400\mathrm{.}79$

$12900\mathrm{.}79$

$15210\mathrm{.}79$

$18400\mathrm{.}79$

$7800\mathrm{.}78$

$19910\mathrm{.}78$

$10500\mathrm{.}77$

$10800\mathrm{.}76$

$9300\mathrm{.}74$

$16110\mathrm{.}74$

$14400\mathrm{.}73$

$7500\mathrm{.}71$

$8400\mathrm{.}71$

$1910\mathrm{.}70$

$13510\mathrm{.}70$

$20000\mathrm{.}70$

$1400\mathrm{.}69$

$16700\mathrm{.}69$

$9900\mathrm{.}68$

$15100\mathrm{.}68$

$19500\mathrm{.}68$

$5100\mathrm{.}67$

$6710\mathrm{.}67$

$4910\mathrm{.}65$

$2300\mathrm{.}64$

$6110\mathrm{.}63$

$3600\mathrm{.}62$

$18310\mathrm{.}62$

$16010\mathrm{.}61$

$11000\mathrm{.}60$

$15900\mathrm{.}60$

$19800\mathrm{.}60$

$10210\mathrm{.}58$

$2500\mathrm{.}57$

$5500\mathrm{.}57$

$7000\mathrm{.}57$

$16300\mathrm{.}57$

$1200\mathrm{.}56$

$17600\mathrm{.}56$

$18700\mathrm{.}56$

$2800\mathrm{.}54$

$3400\mathrm{.}54$

$9800\mathrm{.}54$

$13800\mathrm{.}54$

$2700\mathrm{.}52$

$300\mathrm{.}51$

$8500\mathrm{.}51$

$12800\mathrm{.}51$

$10300\mathrm{.}50$

$6300\mathrm{.}49$

$6800\mathrm{.}49$

$11500\mathrm{.}49$

$15500\mathrm{.}48$

$11300\mathrm{.}47$

$6000\mathrm{.}46$

$17100\mathrm{.}46$

$3710\mathrm{.}45$

$1700\mathrm{.}44$

$10100\mathrm{.}44$

$8000\mathrm{.}43$

$13200\mathrm{.}43$

$13400\mathrm{.}43$

$14200\mathrm{.}43$

$2910\mathrm{.}42$

$10710\mathrm{.}42$

$800\mathrm{.}41$

$18900\mathrm{.}40$

$3200\mathrm{.}39$

$7300\mathrm{.}39$

$3510\mathrm{.}38$

$5200\mathrm{.}38$

$11400\mathrm{.}38$

$12500\mathrm{.}38$

$18600\mathrm{.}38$

$600\mathrm{.}37$

$7400\mathrm{.}37$

$9500\mathrm{.}37$

$18500\mathrm{.}37$

$1600\mathrm{.}36$

$2000\mathrm{.}36$

$13600\mathrm{.}36$

$19200\mathrm{.}36$

$1000\mathrm{.}35$