Results 1 to 2 of 2

Math Help - (multivariate?) Hyper Geometric Distribution / excel

  1. #1
    Newbie
    Joined
    May 2012
    From
    Canada
    Posts
    1

    (multivariate?) Hyper Geometric Distribution / excel

    Hi everyone,

    I'm working on a problem related to Hyper Geometric Distribution; I searched the forum and found a number of posts related to it in this "advanced statistics" forum but wasn't able to find a specific thread that helps..

    Let's say I have a standard playing card deck (52 cards) and am looking for the odds of: In the first 15 cards I draw, finding at least 1 King *and* at least 1 Queen.

    I'm using Excel rather than have to do this by hand, so for finding a King in the first 15 cards, I have:

    =1-(HYPGEOMDIST(0,15,4,52)) - which gives me ~75.6%
    0 = finding none
    15 = sample
    4 = successes
    52 = population

    The odds of finding BOTH in a 15 card sequence would be roughly 0.756 squared, or 57.16%, but obviously if I draw a King in the first 15 cards, that will decrease the odds of drawing a queen. Over a small example like this one, the difference is probably negligible, but I'd like to get an idea how to calculate this for more precision on larger (and more important) problems.

    Any help - either relating to how to solve this mathematically or how to bend Excel to my will - is much appreciated!

    -Bort
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor

    Joined
    Aug 2006
    Posts
    18,605
    Thanks
    1574
    Awards
    1

    Re: (multivariate?) Hyper Geometric Distribution / excel

    Quote Originally Posted by bortsampson View Post
    I'm working on a problem related to Hyper Geometric Distribution; I searched the forum and found a number of posts related to it in this "advanced statistics" forum but wasn't able to find a specific thread that helps..

    Let's say I have a standard playing card deck (52 cards) and am looking for the odds of: In the first 15 cards I draw, finding at least 1 King *and* at least 1 Queen.
    Let K be the event that no kings are among the first fifteen drawn.

    Let Q be the event that no queens are among the first fifteen drawn.

    If you can find 1-\mathcal{P}(K\cup Q) you have it.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. [SOLVED] Hyper geometric Distribution
    Posted in the Statistics Forum
    Replies: 3
    Last Post: December 5th 2011, 03:40 PM
  2. Multivariate Probability Distribution
    Posted in the Advanced Statistics Forum
    Replies: 2
    Last Post: April 5th 2011, 10:17 PM
  3. Multivariate normal distribution
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: December 20th 2010, 10:28 AM
  4. Multivariate Distribution function
    Posted in the Advanced Statistics Forum
    Replies: 2
    Last Post: March 22nd 2010, 04:14 AM
  5. Multivariate Normal Distribution
    Posted in the Advanced Statistics Forum
    Replies: 1
    Last Post: November 22nd 2009, 02:43 PM

Search Tags


/mathhelpforum @mathhelpforum