Simulates a truncated probability distribution using the mean and standard deviation.

Syntax

=MM_SIMULATE_TRUNC("DistName", Mean, StdDev, Param3, LowerBound, UpperBound)

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

• Mean
  Mean of the initial distribution. 

• StdDev
  Standard deviation of the initial distribution. 

• Param3
  Third parameter of the distribution. To check the definition of the parameters, refer to the MM_PARAMNAME function.

Even if the distribution does not require StdDev and/or Param3, all entries should be filled; the reason being that Mind does not accept empty parameters.

• 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_TRUNC to simulate a truncated probability distribution using distribution parameters.

• 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_MS_TRUNC("Normal",0,2,0,-10,10)
Simulates a truncated normal distribution with interval (-10, 10] as support, 0 as initial mean and 2 as initial standard deviation. The third parameter which is zero (chosen arbitrarily) is ignored since the normal distribution has only two degrees of freedom. 

Example 2: Error example

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