HARMEAN INTERCEPT

HYPGEOMDIST

HYPGEOMDIST —

Synopsis

HYPGEOMDIST(x,n,M,N[,cumulative])

Description

HYPGEOMDIST function returns the hypergeometric distribution. x is the number of successes in the sample, n is the number of trials, M is the number of successes overall, and N is the population size.

If the optional argument cumulative is TRUE, the cumulative left tail will be returned.

  • If x,n,M or N is a non-integer it is truncated.
  • If x,n,M or N < 0 HYPGEOMDIST returns #NUM! error.
  • If x > M or n > N HYPGEOMDIST returns #NUM! error.
  • This function is Excel compatible.

Examples

HYPGEOMDIST(1,2,3,10) equals 0.4666667.

See also

BINOMDIST, POISSON.

HARMEAN INTERCEPT