RandNum function

Simulation Modelling category - Monte Carlo family Home 
What the name means"Compute a semi random number"
SyntaxRandNum ( )
DescriptionThis function generates a random number. The number it generates is actually a semi-random number, because it comes from a pre-ordained sequence of random numbers from a seed. The Business Functions menu, under Monte-Carlo, gives you the option to seed the generator. If the generator is re-initialised time and again with the same seed, the identical set of random numbers will flow from the RandNum function. In fact, because the sequence of numbers is determined in one go rather than each number dependent on the previous, you can even use PickRandom to choose what number you'd like from the sequence, if desired. The repeatability from a specific seed means that your workbooks are repeatable. Our experience of Monte-Carlo simulation work is that it really helps to have the random number sequence repeatable, for debugging your model and seeing changes in isolation.
VolatilityThis function is termed 'volatile', which means it recalculates whenever the worksheet is recalculated, regardless of whether any of its inputs have changed. See Volatility.
VariableType or ValueDescription
Output:
Return Value Result Float The result of the function, expressed as a number.
Examples
  • Preview of the RandNum example.
  • The above spreadsheet can be accessed from the Quick Reference (on the Business Functions menu), on the Examples menu, or in the Business Functions\Component Examples directory
Published Edition Changes in Behaviour

This function has experienced some changes in its behaviour over its history. Click here to see more.