Note: In order to use the spreadsheet examples, you need to download Business Functions
|DistCumulative (CumProbs, Values, [CumSwitch], [RandOpt])|
|Generate a value from a specified cumulative probability distribution|
|This is the completely generalised distribution function, where you input a distribution governed by CumProbs (0 to 1) and Values. CumSwitch (optional) governs whether to interpolate the probability between two points or round to the nearest input|
This function handles discrete as well as continuous cumulative probabilities.