Software Search, Categories and Specials Categories: Excel Add-ins / Excel Templates
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Excel Random Number Generator

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

Excel Random Number Generator-30 Day Money Back Guarantee <See Also Excel Monte Carlo Add-in >

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.

More about Z Random: Continuous Distributions | Functions | A VBA Interface | Interactive User Interface | Generate Random Samples | random Sort

Z Random for Excel << Click for price  Secure Payment Options 30 Day Money Back Guarantee



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