This function calculates the certainty level (or probability, as a percent) of achieving a forecast value at or smaller than a specific threshold. The value returned is equivalent to setting the right (highest value) endpoint grabber on the forecast chart to a specific value and obtaining the calculated certainty level. You can call this function from either a macro or a worksheet.
For example, suppose trial values for a forecast range from 5 to 300. If you enter 200 for the Value parameter (see Table 101, CB.GetCertainty Parameters), CB.GetCertainty would return the probability of obtaining a value within the range of 5 to 200, including those end points.
Table 100. CB.GetCertainty Returned Data Type
Certainty (probability as a percent) of achieving a value within a range from the minimum up to and including the specified forecast value. |
You must run a simulation before you call this function, or it returns 0.