Need to hypergeometric distribution calculations? Microsoft Excel supplies a statistical functions for just such a purpose says bestselling computer book author Stephen L. Nelson

Excel provides a sometimes useful statistical function for making hyper geometric distribution calculations. (Note: People sometimes call the distribution “hypergeometric” [one word] rather than a “hyper geometric” [two words].)

Background information on Hyper Geometric Distributions

The hyper geometric probability distribution is much like the binomial probability distribution. The hyper geometric distribution describes the outcome of a multi-step experiment, consisting of n trials, where each trial ends in either a success or a failure.

Share This

Trying to make sense of Microsoft Excel’s statistical analysis tools? Make sure you understand the statistical terms Excel uses, says bestselling computer book author Stephen L. Nelson. Such an understanding will both ease and expedite your analysis.

Excel provides an almost countless number of statistical tools you can use to analyze data and make meaningful statements about it. However, without understanding the definitions of the statistical terms that Excel uses, the statistical tools offer little help.

Accordingly, this article supplies some background information about Excel’s statistical tools and also defines the important statistical terms used by Excel.

Share This