Work out probability for a multi event raffle

Copper Contributor
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
1 Reply

@Graham_Sargent 

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.