If none of the provided distributions fits the data, you can use the custom distribution to define the own. 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.
The following sections show how to use the custom distribution:
For summaries of the data entry rules used in the examples plus additional rules, see Entering Tables of Data into Custom Distributions and Other Important Custom Distribution Notes.