MM_RANDOM function

Generates a random number greater or equal to 0 and less than 1 (excluded) using Mind generator.

Written By Nikolas Ethoré (Super Administrator)

Updated at November 24th, 2021

Description

Generates a random number greater or equal to 0 and less than 1 (excluded) using Mind generator. The generated numbers are evenly distributed between 0 and 1.

Syntax

=MM_RANDOM()

No parameters. 

Remarks

  • This function is equivalent to the RAND Excel function which uses Excel generator. Mind uses a different random number generator: xoshiro256**. You will only see a difference in Excel; indeed, after importing your file in Mind, only the xoshiro256** generator is used. MM_RANDOM is only useful if you want to use Mind generator within Excel.

  • New numbers are generated each time the model is ran. To lock the seed, see the article about stochastic models or the MM_RANDOMIZE function.

  • Note that, in Excel, MM_RANDOMIZE function locks MM_RANDOM but not RAND, in other words, functions that uses Mind generator. See MM_RANDOMIZE for more details.

Example

Formula: =MM_RANDOM()
The above table shows different results generated by the function.