Home

Work out probability for a multi event raffle

%3CLINGO-SUB%20id%3D%22lingo-sub-883350%22%20slang%3D%22en-US%22%3EWork%20out%20probability%20for%20a%20multi%20event%20raffle%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883350%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20going%20to%20enter%20a%20contest%20where%20there%20is%20100%20prizes%20beneath%20100%20tickets%2C%20there%20are%2015%20star%20prizes%20-%20I%20want%20to%20work%20out%20what%20are%20the%20probability%20of%20me%20getting%20one%20of%20these%2015%20prizes%20with%201%20ticket%2C%202%20tickets%203%20etc%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20there%20a%20formula%20on%20excel%20which%20can%20help%20me%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-883350%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-885956%22%20slang%3D%22en-US%22%3ERe%3A%20Work%20out%20probability%20for%20a%20multi%20event%20raffle%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-885956%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F417625%22%20target%3D%22_blank%22%3E%40Graham_Sargent%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20certainly%20hope%20this%20isn't%20a%20homework%20problem.%20Nonetheless...%3C%2FP%3E%3CP%3EIf%20the%20amount%20of%20tickets%20you%20purchase%20are%20in%20cell%20A1%2C%20then%20in%20cell%20B1%3A%3C%2FP%3E%3CP%3E%3D1-(85%2F100)%5EA1%3C%2FP%3E%3CP%3Eis%20the%20probability%20of%20obtaining%20one%20star%20prize.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Graham_Sargent
Visitor
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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies