Question

Type of Donut Number purchased Probability Cumulative Probability
Chocolate Cream filled 5.00
Strawberry 1.00
Kale frosted 1.00
Blueberry 8.00
Cream filled surprise 10.00






________________________________________
Based on the above table, you want to create a vlookup table. What would be the range of values that would return a value of purchasing a Kale frosted donut?
a) 0.24 to 0.28
b) 0 to 0.20
c) 0.20 to 0.24
d) 0.28 to 0.60

Answer 1

Total = 25. Probabilities:
- Chocolate = 5/25 = 0.20 → cumulative 0.20
- Strawberry = 1/25 = 0.04 → cumulative 0.24
- Kale frosted = 1/25 = 0.04 → cumulative 0.28
- Blueberry = 8/25 = 0.32 → cumulative 0.60
- Cream filled surprise = 0.40 → cumulative 1.00

Kale corresponds to random values greater than 0.24 and up to 0.28, so answer: a) 0.24 to 0.28.