Formulas for Excel®

The Mersenne Twister generator and all distributions are available as formulas and can be used directly in spreadsheet cells. The ZRandom formulas can also be used as part of in more complicated formulas. ZRAND and ZRANDBETWEEN accept an optional seed and can return both single cell values and arrays for even greater speed. The ZSAMPLE function samples a random value from a list.

Bernoulli =ZBERNOULL(p) Beta =ZBETA(a,b) Burr =ZBURR(alpha,theta,gamma) Exponential =ZEXPONENTIAL(mean) Gamma =ZGAMMA(alpha,theta) Geometric =ZGEOMETRIC(p) Hypergeometric =ZHYPERGEOMETRIC(p) Lognormal =ZLOGNORMAL(mu,sigma) Negative Binomial =ZNEGATIVEBINOMIAL(r,p) Normal =ZNORMAL(mean, stddev) Pareto =ZPARETO(alpha,theta) Poisson =ZPOISSON(lambda) Triangular =ZTRIANGULAR(minimum,maximum [, peak]) Uniform (cont.) =ZUNIFORM(minimum,maximum) Uniform =ZRAND(MIN, MAX) Weibull =ZWEIBULL(theta, tau)