Commissioner_rumY
New member
- Joined
- Feb 29, 2012
- Messages
- 5
Hi,
I'm looking for some help figuring out draft pick probability for my fantasy hockey league draft (math of this level is not my thing).
It's a ping-pong ball draft (4 of 14 lotto style), like in real life, where each team is assigned a certain number of chances to weight their odds of getting a better pick. What I need to know is each team's odds of getting each of the nine draft picks. There are no duplicates, as in once a team is pulled their balls are removed from the equation. The weighting is as such:
Out of 1001 balls:
Team 1: 400 balls
Team 2: 300 balls
Team 3: 150 balls
Team 4: 75 balls
Team 5: 40 balls
Team 6: 20 balls
Team 7: 10 balls
Team 8: 5 balls
Team 9: 1 ball
I'd love to know how to figure this out myself (or how to get Excel to do it) but if that's too much of an ordeal just knowing the percentages for this scenario would be greatly appreciated.
Thank you for your time.
I'm looking for some help figuring out draft pick probability for my fantasy hockey league draft (math of this level is not my thing).
It's a ping-pong ball draft (4 of 14 lotto style), like in real life, where each team is assigned a certain number of chances to weight their odds of getting a better pick. What I need to know is each team's odds of getting each of the nine draft picks. There are no duplicates, as in once a team is pulled their balls are removed from the equation. The weighting is as such:
Out of 1001 balls:
Team 1: 400 balls
Team 2: 300 balls
Team 3: 150 balls
Team 4: 75 balls
Team 5: 40 balls
Team 6: 20 balls
Team 7: 10 balls
Team 8: 5 balls
Team 9: 1 ball
I'd love to know how to figure this out myself (or how to get Excel to do it) but if that's too much of an ordeal just knowing the percentages for this scenario would be greatly appreciated.
Thank you for your time.