LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Creating a spreadsheet to calculate probailities of winning raffles

I need help designing a spreadsheet that can be used to figure the
probability and odds of winning this raffle. Here is the situation:

1) there will only be 500,000 tickets sold.
2) there will be 2 first place prizes of $500,000.00
3) there will be 2 second place prizes of $25,000.00
4) there will be 30 third place prizes of $5,000.00
5) there will be 700 fourth place prizes of $250.00
6) Tickets cost $5.00

If I were to buy 50 tickets spending $250.00 (the amount of the
smallest prize)...

1) what are my odds of winning atleast one of the first place prizes?
2) what are my odds of winning both of the first place prizes?
3) what are my odds of winning atleast one of the second place
prizes?
4) what are my odds of winning both of the second place prizes?
5) what are my odds of winning atleast one of the third place prizes?
6) what are my odds of winning more than one of the third place
prizes?
7) what are my odds of winning atleast one of the fourth place
prizes?
8) what are my odds of winning more than one of the fourth place
prizes?

Similarly...

9) what is the probability that I will win atleast one first place
prizes?
10) what is the probability that I will win both first place prizes?
11) what is the probability that I will win atleast one second place
prizes?
12) what is the probability that I will win both second place prizes?
13) what is the probability that I will win atleast one third place
prize?
14) what is the probability that I will win more than one third place
prize?
15) what is the probability that I will win atleast one fourth place
prize?
16) what is the probability that I will win more than one fourth place
prize?

What I am looking for is the explanation of the formula(s) required to
answer
the questions above.

Can anybody help?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Winning Percentages seme Excel Programming 3 April 5th 23 01:06 PM
add up winning teams sonia Excel Discussion (Misc queries) 1 April 24th 09 07:26 AM
Creating VBA Functions When Creating Spreadsheet Via VBA? PeteCresswell[_2_] Excel Programming 6 June 18th 07 12:38 PM
how do I calculate probability of winning a raffle RichM Excel Worksheet Functions 2 September 15th 06 02:19 AM
Winning Streak ParTeeGolfer Excel Worksheet Functions 4 December 31st 04 11:08 PM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"