Wednesday, October 6, 2010

ZRandom for Excel

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.
  • 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.