This example selects the assumption in cell B7 and defines a triangular distribution using the 25th percentile, the likeliest value, and the 75th percentile. CB.DefineAssumND receives this information about the distribution and parameter set and defines the assumption’s distribution with a 25th percentile value of 5, a likeliest value of 10, and a 75th percentile value of 15.
Note: | If you use the numeric value of the index instead of the constant name for cbParmPercentile, as in Example 3, you must use the sample syntax, 0 +percentile, so that the function can identify the parameter by the numeric value. |
Range("B7").Select
Value1 = CB.DefineAltParms(cbDfaTriangular, 0 +25, -10, 0 +75)
CB.DefineAssumND Value1, 5, 10, 15