CB.DefineAltParms Example 1

This example defines the assumption in cell B5 as a normal distribution using the mean and standard deviation. Because the normal distribution requires only these two parameters, use cbParmNone to stand in as the third (unused) parameter in the argument list.

CB.DefineAssumND receives this information about the distribution and parameter set and defines the assumption’s distribution with a mean of 10 and a standard deviation of 0.2.

Range("B5").Select
Value = CB.DefineAltParms(cbDfaNormal,cbParmMean,cbParmStDev,cbParmNone)
CB.DefineAssumND Value, 10, 0.2