Calculating Odds of Royal Flush in Poker - Excel

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

Discussion Overview

The discussion revolves around calculating the probability of obtaining a royal flush in poker using Excel. Participants explore the mathematical formulation of the probability and how to express it in terms of odds and expected hands to play.

Discussion Character

  • Mathematical reasoning
  • Technical explanation

Main Points Raised

  • One participant presents a formula for calculating the probability of a royal flush and arrives at a decimal value of 0.000015390.
  • Another participant suggests converting the decimal probability into a ratio, calculating it as approximately 1 in 64977.26.
  • A later reply humorously asserts that the number of hands needed to see a royal flush is one, which may imply a different interpretation of the question.

Areas of Agreement / Disagreement

Participants express differing views on the interpretation of the probability and the expected number of hands to play, with some humorously suggesting that one hand is sufficient to see a royal flush.

Contextual Notes

The discussion does not resolve the assumptions behind the calculations or the implications of the humorous remark regarding the number of hands needed.

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
2K
High School Which probability calculation is "more correct" in Baccarat games?
  • · Replies 9 ·
Replies
9
Views
5K