Forum Discussion
Work out probability for a multi event raffle
I’m going to enter a contest where there is 100 prizes beneath 100 tickets, there are 15 star prizes - I want to work out what are the probability of me getting one of these 15 prizes with 1 ticket, 2 tickets 3 etc
If there a formula on excel which can help me
If there a formula on excel which can help me
1 Reply
I certainly hope this isn't a homework problem. Nonetheless...
If the amount of tickets you purchase are in cell A1, then in cell B1:
=1-(85/100)^A1
is the probability of obtaining one star prize.
