Question

Please explain via excel with formulas

8b What is the probability that at least four of ten new customers would Enroll in the new Program (using all the data)? Exactly seven? Less than six? Now compute these same questions and report your findings based on the new probability value after you remove the customers that were given No Offer. Briefly explain how the results change.

Customer ID	Promotion Offer	Enrolled in Program	Pre Promotion Avg Spend	Post Promotion Avg Spend	Marketing Segment
1	Free Flight Insurance	Yes	150.39	246.32	Average Spender
2	Double Miles + Free Flight Insurance	Yes	90.32	182.8	Low Spender
3	Double Miles	Yes	14.93	20.55	Low Spender
4	Double Miles	Yes	45.86	75.25	Average Spender
5	No Offer	No	257.89	397.05	Med Low Spender
6	Free Flight Insurance	Yes	864.59	1098.3	Med High Spender
7	Double Miles	No	137	94.76	Low Spender
8	No Offer	No	1152.27	781.75	Med High Spender
9	Double Miles	Yes	25.82	144.57	Average Spender
10	Double Miles + Free Flight Insurance	Yes	1540.66	1605.88	High Spender
11	Free Flight Insurance	Yes	253.61	312.15	Average Spender
12	Double Miles + Free Flight Insurance	No	37.4	47.78	Low Spender
13	Free Flight Insurance	Yes	1150.51	806.47	Med High Spender
14	Double Miles + Free Flight Insurance	Yes	22.34	545.82	Average Spender
15	Free Flight Insurance	Yes	179.47	334.25	Average Spender
16	Double Miles	Yes	162.42	678.43	Med Low Spender
17	Double Miles + Free Flight Insurance	Yes	24.85	90.83	Low Spender
18	Double Miles	Yes	285.45	121.53	Med Low Spender
19	Free Flight Insurance	No	3005.15	3012.99	High Spender
20	Double Miles + Free Flight Insurance	Yes	28.81	77.26	Low Spender

Answer 1