Discrete Probability Distributions
Microsoft Excel Functions

Microsoft Excel may be used to perform calculations on all presented distributions.  The following table lists these functions.

Distribution Excel Function
Binomial BINOMDIST(number_s, trials, probability_s, cumulative)
Pascal NEGBINOMDIST(number_f, number_s, probability_s)
Hypergeometric HYPGEOMDIST(sample_s,number_sample,population_s,number_population)
Poisson POISSON(x,mean,cumulative)

Remarks:

  1. The Bernoulli distribution is a special case of the Binomial with 'trials' = 1.
  2. The Geometric distribution is a special case of the Pascal with 'number_s' = 1.
  3. The BINOMDIST and POISSON functions may be used to calculate cumulative distributions by specifying the 'cumulative' parameter as True.