ZRandom implements high quality random number generation for Microsoft Excel using the Merssenne Twister algorithm :
- Use higher quality pseudo-random numbers than the Excel RAND() and VBA Rnd() functions.
- Generate random numbers from 16 discrete and continuous distributions.
ZRandom implements the following discrete distributions: Uniform, Bernoulli, Geometric, Hypergeometric, Negative Binomial and Poisson.
ZRandom implements the following continuous distributions: Beta, Burr, Exponential, Gamma, Lognormal, Normal, Pareto, Triangular, Uniform and Weibull.
ZRandom implements the following continuous distributions: Beta, Burr, Exponential, Gamma, Lognormal, Normal, Pareto, Triangular, Uniform and Weibull.
- Create large batches of random numbers using the interactive user interface.
- Excel functions for use in spreadsheet formulas.
- Random Sort and Random Sample
- Interactive distribution wizard
- A VBA interface to generate random numbers in your code.