Step 1: Define Input Assumptions

An assumption is a variable input defined as a probability distribution (a range of possible values and their associated probabilities).

  To define assumptions in Crystal Ball EPM:

  1. In the Strategic Finance Worksheet under Uncertain Inputs, select a cell or a range of cells.

    Do not include header or label cells.

  2. Select Define, and then Define Assumption or click Define Assumptions icon.

  3. In the Distribution Gallery, select the distribution for the first cell.

    For help in selecting a distribution, see the Oracle Crystal Ball User's Guide. (From within Crystal Ball EPM in Microsoft Excel 2003, select Help, then Crystal Ball, and then Documentation. In Microsoft Excel 2007 or later, in the Help group, select Resources, and then Documentation.)

  4. In the Define Assumption dialog, enter the distribution parameters.

    Parameters can be numeric values or cell references.

  5. Click Enter to view the distribution curve.

  6. Click OK.

    If you selected multiple cells, the Define Assumption dialog box for the next cell appears.

    For details, click Help in any dialog box.

Note:

Time-series data is frequently correlated. For the most accurate results, review the information on correlating assumptions in the Oracle Crystal Ball User's Guide.

  Click here for Step 2: Define Output Forecasts.