bus03_top.gif
xlmodeling_bg1.jpg
Random Number Generator - Hypergeometric Distribution
The Hypergeometric distribution is a discrete distribution. It is alike the Binomial distribution. Both of the Hypergeometric distribution and the Binomial distribution describe the number of times an event happens in a fixed number of trials. The difference between the two distributions is that Binomial distribution trials are independent, while Hypergeometric distribution trials change the probability for each subsequent trial and are called "sampling without replacement." The Hypergeometric distribution can be used to describe sampling from a population. The Playing Card Probability example in the Excel VBA Project section demonstrates such usage.

The following example shows input and output from 3 simulations. Each with the different parameters listed in the table below. All three simulations have 50,000 iterations and alpha of 5% (for 1 tail test).
The output shows the estimate of skewness, mean, stand deviation, maximum value, minimum value, lower confidence interval, and upper confidence interval from each of the 3 simulations.
vbar10_output.gif
The following shows the charts generated from the 3 simulations.
example023002.gif
vbar10_chart2.gif
example023001.gif
Copyright ©   XL Modeling.
vbar10_input.gif
bus03_sidenav.gif
bus03_sidenav.gif
Home
Contact Us
Product
Consulting
Support