Using the Custom Distribution

custom distribution icon

If none of the provided distributions fits the data, you can use the custom distribution to define one. For example, a custom distribution can be especially helpful if different ranges of values have specific probabilities. You can create a distribution of one shape for one range of values and a different distribution for another range. You can describe a series of single values, discrete ranges, or continuous ranges. This section uses real-world examples to describe the custom distribution.

Since it is easier to understand how the custom distribution works with a hands-on example, you may want to start Crystal Ball and use it to follow the examples. To follow the custom distribution examples, first create a new Microsoft Excel workbook then select cells as specified.

For additional information see the listed topics and the Oracle Crystal Ball Reference and Examples Guide. Also see Growth Rate Assumption: Custom Distribution.