I am trying to gain basic understanding on how to calculate probabilities. Below are a few examples of what I am trying to calculate. I would prefer (if possible) for formulas to be given on how to solve these using Microsoft Excel. Also, educating me on Probability Terminology involved would be helpful.
Situation 1: I am going to draw "X" cards (5, for 5-card stun poker) from a "Y" card deck (52), what are the odds of getting a flush in hearts (Variable I have labeled as "Z" = 13... in my current ignorance, I refer to this as the "Targets" variable)?
My algebraic solution: = (13/52) * (12/51) * (11/50) * (10/49) * (9/48) Solution to chance of getting any flush would be the above times 4 to represent a flush in any suit.
The problem with the above solution is that it becomes impractical when the situational probabilities I am trying to calculate become more complicated.
QUESTION 1: What is a more statistical way of calculating the above? (using excel)
Situation 2: I am going to draw "X=5" 5 cards from a "Y=10" 10 card deck. In this deck there are only two different draw possibilities, Card 1 or Card 2... There are 7 copies of Card 1 which are all identical and 3 copies of Card 2 which are all identical.
What is the probability of getting 0-3 copies of Card 2?
X = 5, Y = 10, Z = 3
QUESTION 2: What is the statistical way of calculating the above? (using excel)
X = 7, Y = 60, Z = 20
QUESTION 3: How do I calculate, using excel, what the odds are of getting 0-7 of the target cards in a draw of 7?