 |
|
|
|
|
|
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.
- Generate random numbers from 16 discrete and continuous distributions .
- Functions for use in spreadsheet formulas.
- A VBA interface to generate random numbers in your code.
- Generate large amounts of random numbers interactive user interface .
- Generate random samples from a table or random sort existing data.
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.
Z Random for Excel
Secure Payment Options
30 Day Money Back Guarantee
| Pricing: |
|
Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
See Also: OzGrid Excel Plus || Monte Carlo Add-In for Excel || Random Numbers Generator and Statistics || Numerical Searching Methods and Option Pricing Models || Finance and Statistics Models || Excel Add-ins or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS