| Description | Minimum Point of a Distribution (either p=0 or as defined for the distribution type DistType)
| | Data Type | Float
| | Example | 0
| | A floating point number can have decimal places. Floating point numbers in Excel, and Business Functions store data accurately to several decimal places. A string can be converted to a number: see Conversion of Input Strings to Values
| | Detail | The use of DistMin, DistMid and DistMax is to speed up data input by enabling you to specify a distribution using layman's terms instead of specifying statistical parameters. Strict statistical paramteres can be used with any of the stand-alone distribution functions if so desired.
The values of DistMin, DistMid and DistMax are as follows:
| Distribution | DistMin | DistMid | DistMax |
|---|
| Uniform | Minimum (0%) | (Ignored) | Maximum (100%)
| | Triangular | Minimum (0%) | Mode (Apex) | Maximum (100%)
| | Double Triangular | Minimum (0%) | Median (Apex, 50%) | Maximum (100%)
| | Normal | Minimum (1%) | Median (50%) | Maximum (99%)
| | LogNormal | Minimum (1%) | Median (50%) | Maximum (99%) |
Percentages refer to cumulative probability levels. For functions where the maximum and minimum do not (and could not) represent the limits of the distribution (such as the Normal, which attenuates gently to zero over and infinitely long tail) the distribution is truncated at the probability levels specified above. In otherwords, the distribution function will force values outside of the central 98% (1%>p>99%) to the specified minimum or maximum.
|
Variable 'DistMin' is used in the following components:
| 