Calculating Odds of Royal Flush in Poker - Excel

  • Context: Undergrad 
  • Thread starter Thread starter c1gipe
  • Start date Start date
Click For Summary
SUMMARY

The probability of drawing a royal flush in poker is calculated using the formula 4*C(5,2)/C(52,2)*C(47,2)/C(50,5), resulting in a decimal value of 0.000015390. This translates to odds of approximately 1 in 64977.26, meaning a player would need to play about 64977 hands to expect to see a royal flush. The discussion emphasizes the importance of understanding probability calculations in poker and how to convert decimal probabilities into ratios.

PREREQUISITES
  • Understanding of combinatorial mathematics, specifically combinations (C(n, k))
  • Familiarity with probability concepts in gaming scenarios
  • Proficiency in Microsoft Excel for performing calculations
  • Basic knowledge of poker hand rankings and their probabilities
NEXT STEPS
  • Research how to use Excel functions for combinatorial calculations
  • Learn about advanced probability concepts in card games
  • Explore statistical analysis techniques for gaming scenarios
  • Study the implications of odds and probability in poker strategy
USEFUL FOR

This discussion is beneficial for poker players, statisticians, and anyone interested in understanding the mathematical aspects of gaming probabilities and odds calculation.

c1gipe
Messages
6
Reaction score
0
im trying to figure out probability of poker events happening and using excel to help


4*C(5,2)/C(52,2)*C(47,2)/C(50,5) = 0.000015390

how can i change this decimal into a ratio like 10:1. this number is the odds of getting a royal flush so i want to know how many hands i need to play before seeing one
 
Physics news on Phys.org
c1gipe said:
im trying to figure out probability of poker events happening and using excel to help


4*C(5,2)/C(52,2)*C(47,2)/C(50,5) = 0.000015390

how can i change this decimal into a ratio like 10:1. this number is the odds of getting a royal flush so i want to know how many hands i need to play before seeing one

That'll be a fraction of 1, so .000015390 chances in 1.

1/.000015390 = 64977.26

Or 1 chance in 64977.26.
 
ah yes. all my schooling is coming back to me now. thank you
 
BTW remember, the number of hands you need to play to see a royal flush ... is one.

:biggrin:
 
very true sir
thank you for your help
 

Similar threads

High School In dire Straights: Straights of 11+ w/ 2 Poker decks
  • · Replies 7 ·
Replies
7
Views
2K
High School Basic Poker Immediate Odds Question
  • · Replies 5 ·
Replies
5
Views
1K
Undergrad Calculating the Probability of a Royal Flush in Texas Holdem with 9 Players
  • · Replies 1 ·
Replies
1
Views
2K
Undergrad Calculating Probability of Flush in 7-Card Stud Poker
  • · Replies 8 ·
Replies
8
Views
5K
Undergrad Why do gamblers go broke even when the odds favour them at every step?
  • · Replies 7 ·
Replies
7
Views
2K
Comp Sci Poker test: probability of Full House (confusion)
  • · Replies 11 ·
Replies
11
Views
2K
High School Calculating Odds of Getting at Least One Pair in Pai Gow
  • · Replies 18 ·
Replies
18
Views
3K
Probability of getting a Four-of-a-kind?
  • · Replies 7 ·
Replies
7
Views
2K
Undergrad Odds ratio and percentages.... absolute beginner
  • · Replies 4 ·
Replies
4
Views
1K
High School Which probability calculation is "more correct" in Baccarat games?
  • · Replies 9 ·
Replies
9
Views
5K