8.5.11.37. xhypergeom_dist

xhypergeom_dist(sample_s, number_sample, population_s, number_pop, cumulative)

EXPON.DIST(x, lambda, cumulative)

• cumulative TRUE -> 1 - exp(-lambda * x)

• cumulative FALSE -> lambda * exp(-lambda * x)

• Excel errors:

  • x < 0 or lambda <= 0 -> #NUM!

  • cumulative not TRUE/FALSE -> #VALUE!