Distributions

A number of fields allow you to express values as a distribution. The column drop-down provides a visual way to enter these values, using the Distribution Builder.

Define a distribution

  1. Click the drop-down arrow for the column to access the field builders. If the column has more than one field builder available, click to access the Distribution Builder.
  2. Select the distribution type from the drop-down list. The default is Normal. Corresponding fields are displayed on the form for data entry based on the type of distribution you select. For example, when a Normal distribution is chosen, Mean and SD are available. After entering these values, you see a thumbnail of the distribution.
  3. To access the full size Distribution Builder fly-out, click .

    The probability distributions you can select are:

    • Normal – The probability follows a standard bell curve. Enter the Mean and Standard Deviation (SD).

    • Exponential – With this distribution, the probability of smaller numbers is greater. Enter the Mean.

    • Uniform – The probability is evenly distributed. Enter a Number and a Range.

    • Triangular – The probability follows a triangular shape. Enter a Min, a Max, and a Mode.

    • Poisson – This distribution generates integer values. Enter a Mean.

    • Lognormal – The probability follows a bell curve after a log transform. Enter the Mean and Standard Deviation (SD) after the log transform.

    • Bounded Normal – The probability follows a standard bell curve within the specified range. Enter the Mean and Standard Deviation (SD), as well as the Min and Max values of the range.

    • Bounded Exponential – With this distribution, the probability of smaller numbers is greater up to a specified maximum. Enter the Mean and the Max.

    • Bounded Lognormal – The probability follows a standard bell curve, with a log transform, within the specified range. Enter the Mean and Standard Deviation (SD), as well as the Min and Max values of the range.

Last modified: Wednesday May 15, 2024

Is this useful?