Software Search, Categories and Specials Categories: Excel Add-ins / Excel Templates

# Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Buy Today, send us your order ID, and claim over \$70.00 worth of FREE software

## Pseudo Excel Random Number Generator. Mersenne Twister Algorithm

Z Random 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. Z Random implements the following discrete distributions: Uniform, Bernoulli, Geometric, Hypergeometric, Negative Binomial and Poisson. Z Random 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.

Z Random implements a high quality pseudo-random number generator for Microsoft Excel:

Use the high quality Mersenne Twister algorithm to generate better pseudo-random numbers than the Excel RAND() and VBA Rnd() functions.

High Quality RNG

The Excel RAND() and the VBA Rnd() functions use very simple algorithms to generate pseudo-random numbers. In some Excel versions, the RAND() can even generate negative numbers! If a high degree of randomness or a large quantity of random numbers are required, these functions should not be used.

ZRandom uses the Mersenne Twister algorithm to generate pseudo-random numbers, one of the best algorithms available. Mersenne Twister is very fast and has a cycle period of 219937 - 1.

FAQ

What are the system requirements for Z Random Number Generator?

Windows 2000/Windows XP or greater and Excel 2000 or greater.

What is new in this version

Adds Excel and VBA interfaces for 14 non-uniform distributions.

Adds the distribution wizard, samples and random sort.