Excel Random Number Generator
Rate this solution:(3/5 from 2 votes)
|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:
(Pricing is available on the next page)
(Updated on 2017-04-01)
Related Excel Solutions for Random Number GeneratorStatistical 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 CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity