Question

12) If you were to use probabilities to create tiers for the top 15%, 10%, and 5% of all future customers based on Post-Promotion spending, at what dollar values would you set those cutoffs?

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