MONTE CARLO EXCEL ADDIN
Updated 672 days ago
This Addin utilizes the Mersenne Twister algorithm to generate pseudo random numbers. The benefit to this is that the period is much longer than other methods. The native Excel VBA function, RND(), has a period of 16,777,216 numbers. After 16,777,216 pseudo random numbers are generated, the identical series of numbers repeats. The Mersenne Twister method has a much longer period of 2^(19937 − 1)...
Functions are available to the Excel user to provide a random values whose distribution follows statistical functions. By specifying the parameters of the distribution the functions return random values whose frequency of occurrence follow the specified distribution. These functions are available to your VBA macros as well.