WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Hypergeometric Distribution

Hypergeometric Distribution

Hypergeometric Distribution Definition

In the statistics and the probability theory, hypergeometric distribution is basically a distinct probability distribution which defines probability of k successes (i.e. some random draws for the object drawn that has some specified feature) in n no of draws, without any replacement, from a given population size N which includes accurately K objects having that feature, where the draw may succeed or may fail.

The formula for the probability of a hypergeometric distribution is derived using a number of items in the population, number of items in the sample, number of successes in the population, number of successes in the sample, and few combinations. Mathematically, the probability is represented as,

P = K C k * (N – K) C (n – k) / N C n

Hypergeometric Distribution Formula

where,

  • N = No. of items in the population
  • n = No. of items in the sample
  • K = No. of successes in the population
  • k = No. of successes in the sample

The mean and standard deviation of a hypergeometric distribution is expressed as,

Mean = n * K / N
Standard Deviation = [n * K * (N – K) * (N – n) / {N2 * (N – 1)}]1/2

Explanation

Step 1: Firstly, determine the total number of items in the population, which is denoted by N. For example, the number of playing cards in a deck which is 52.

Step 2: Next, determine the number of items in the sample, denoted by n—for example, the number of cards drawn from the deck.

Step 3: Next, determine the instances which will be considered to be successes in the population, and it is denoted by K. For example, the number of hearts in the overall deck, which is 13.

Step 4: Next, determine the instances which will be considered to be successes in the sample drawn, and it is denoted by k. E.g., the number of hearts in the cards drawn from the deck.

Step 5: Finally, the formula for the probability of a hypergeometric distribution is derived using a number of items in the population (step 1), number of items in the sample (step 2), number of successes in the population (step 3) and number of successes in the sample (step 4) as shown below.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

P = K C k * (N – K) C (n – k) / N C n

Examples of Hypergeometric Distribution (with Excel Template)

You can download this Hypergeometric Distribution Excel Template here – Hypergeometric Distribution Excel Template

Example #1

Let us take the example of an ordinary deck of playing cards form where 6 cards are drawn randomly without replacement. Determine the probability of drawing exactly 4 red suites cards, i.e., diamonds or hearts.

  • Given, N = 52 (since there are 52 cards in an ordinary playing deck)
  • n = 6 (Number of cards drawn randomly from the deck)
  • K = 26 (since there are 13 red cards each in diamonds and hearts suite)
  • k = 4 (Number of red cards to be considered successful in the sample drawn)

Solution:

Therefore, the probability of drawing exactly 4 red suites cards in the drawn 6 cards can be calculated using the above formula as,

Hypergeometric Distribution Formula Example1

Probability = K C k * (N – K) C (n – k) / N C n

= 26 C 4 * (52 – 26) C (6 – 4) / 52 C 6

= 26 C 4 * 26 C 2 / 52 C 6

= 14950 * 325 / 20358520

The probability will be –

Example1.1

Probability = 0.2387 ~ 23.87%

Therefore, there is a 23.87% probability of drawing exactly 4 red cards while drawing 6 random cards from an ordinary deck.

Example #2

Let us take another example of a wallet that contains 5 $100 bills and 7 $1 bills. If 4 bills are chosen randomly, then determine the probability of choosing exactly 3 $100 bills.

  • Given, N = 12 (Number of $100 bills + Number of $1 bills)
  • n = 4 (Number of bills chosen randomly)
  • K = 5 (since there are 5 $100 bills)
  • k = 3 (Number of $100 bills to be considered a success in the sample chosen)

Solution:

Therefore, the probability of choosing exactly 3 $100 bills in the randomly chosen 4 bills can be calculated using the above formula as,

Hypergeometric Distribution Formula Example2

Probability = K C k * (N – K) C (n – k) / N C n

= 5 C 3 * (12 – 5) C (4 – 3) / 12 C 4

= 5 C 3 * 7 C 1 / 12 C 4

= 10 * 7 / 495

Probability will be –

Example2.1

Probability = 0.1414 ~ 14.14%

Therefore, there is a 14.14% probability of choosing exactly 3 $100 bills while drawing 4 random bills.

Relevance and Uses

The concept of hypergeometric distribution is important because it provides an accurate way of determining the probabilities when the number of trials is not a very large number and that samples are taken from a finite population without replacement. In fact, the hypergeometric distribution is analogous to the binomial distribution, which is used when the number of trials is substantially large. However, hypergeometric distribution is predominantly used for sampling without replacement.

Recommended Articles

This article has been a guide to Hypergeometric Distribution Formula. Here we discuss how to calculate the probability of hypergeometric distribution in excel with examples and a downloadable excel template. You can learn more about excel modeling from the following articles-

  • Poisson Distribution
  • Bill of Sale
  • Formula of T Distribution
  • Formula of Standard Normal Distribution
  • Deferred Interest
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Hypergeometric Distribution Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More