Simulates a desired truncated probability distribution using distribution parameters. 

Syntax

=MM_SIMULATE_TRUNC("DistName", Param1, Param2, Param3, LowerBound, UpperBound)

• "DistName"
  String. Name of the distribution you want to simulate. 

• Param1, Param2, Param3
  Parameters of the distribution. 
  
  Even if the distribution has less than three parameters, all entries should be filled; the reason being that Mind does not accept empty parameters.
  
  To check the definition of the parameters, refer to the MM_PARAMNAME function.

• LowerBound
  Lower bound of the truncated distribution. Restricts the domain of the distribution on the left side. Input empty string ("") for negative infinity.

• UpperBound
  Upper bound of the truncated distribution. Restricts the domain of the distribution on the right side. Input empty string ("") for positive infinity.

Remarks

• To check all supported distributions, use the MM_DISTRIBUTIONSLIST function. 

• Use the MM_SIMULATE_MS_TRUNC to simulate a truncated probability distribution using the mean and standard deviation.

• Use the MM_SIMULATE function to simulate a distribution using distribution parameters.
  Use the MM_SIMULATE_MS function to simulate a distribution using the mean and standard deviation.

• A single cell with this formula will inherit from the "SIM" dimension, meaning that the cell will have as many simulated values as the number of simulations chosen before running the model. 

Example 1: Truncated normal distribution

Formula1: =MM_SIMULATE_TRUNC("Normal",0,2,0,-10,10)
Simulates a truncated normal distribution with interval [-10, 10] as support, 0 as first parameter and 2 as second parameter. The third parameter which is zero (chosen arbitrarily) is ignored since the normal distribution only requires two parameters. 

Example 2: Error example

Formula2: =MM_SIMULATE_TRUNC("Normal",0,2,,-10,10)
Returns an error as Mind does not recognize empty parameters.