Home > Excel Business Solutions > Business Finance > Risk Analysis > Random Number Generator Share

Random Number Generator

Excel random number generator for risk analysis


Excel Random Number Generator

Rate this solution:
(3/5 from 2 votes)
Random Number Generator screenshot
Random Number Generator for Excel (ZRandom) 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 limited Excel RAND() and VBA Rnd() functions.

High quality random number generation can be applied to analytical business applications such as probability analysis, simulation studies and cryptographic key generation.

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. Random Number Generator for Excel 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 2^19937 - 1.

Key features of Random Number Generator for Excel include:
  • Generate random numbers from 16 discrete and continuous distributions. Pseudo random numbers can be generated from each distribution using the distribution wizard, directly in a spreadsheet cell using the excel functions and in VBA using the VBA functions. Distributions included are: Bernoulli, Beta, Burr, Exponential, Gamma, Geometric, Hypergeometric, Lognormal, Negative, Binomial, Normal, Pareto, Poisson, Triangular, Uniform, and Weibull.
  • Functions for use in spreadsheet formulas. The Mersenne Twister generator and all implemented distributions are implemented as excel formula's and can be accessed in spreadsheet cells and as part of other functions. The Random Number Generator for Excel functions ZRAND and ZRANDBETWEEN accept an optional seed and can return both single cell values and arrays for even greater speed.
  • A VBA interface to generate random numbers in your code. Just add a reference to 'ZRandom' and use Random Number Generator for Excel. Next and ZRandom.NextBetween to generate random numbers, or use one of the functions to generate random variables from a probability distribution like NextPareto or NextHypergeometric.
  • Generate large amounts of random numbers interactive user interface. Selecting Fill from Distribution from the Tools - ZRandom to enter the distribution wizard: 1. Choose a distribution, 2. Configure the parameters, 3. Choose an output method.
  • Generate random samples from a table. Select a block of cells to sample from choose the Sample item from the Tools - Random Number Generator for Excel sub menu. The samples will be place on the clipboard and can be pasted anywhere.
  • Random sort existing data. Select a block of cells and choose the Random Sort item from the Tools - ZRandom sub menu.

Get It

(Pricing is available on the next page)
(Updated on 2016-05-01)

Related Excel Solutions for Random Number Generator

Statistical AnalysisRisk Analysis  Monte Carlo Analysis Add-inRisk Analysis  Business Risk AnalysisRisk Analysis  Random SamplingTechnical Analysis

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.