Download Chapter 1 - Search Faculty

1
Additional assumption features
6. Enter a correlation coefficient using one of the following methods:
•
Enter a value between -1 and 1(inclusive) in the Coefficient Entry
field.
Type the number that you want to use in the field to the left of the
slider control. After you type the number, the slider control on the
correlation coefficient scale moves to the selected value.
•
Choose a cell that contains the correlation coefficient.
Crystal Ball Note: If you choose a cell with values that change during the
simulation, it is the initial value of the cell that is used for the coefficient.
•
Drag the slider control along the correlation coefficient scale.
The value you select appears in the field to the left of the scale.
•
Type the desired correlation coefficient in the Coefficient field in the
correlation list.
•
Click Calc.
A small dialog appears at the bottom of the first dialog. Enter the
range of cells on your spreadsheet that contains the empirical values
that Crystal Ball should use to calculate a correlation coefficient.
Enter the range of cells in the standard A1:A2 format, where A
designates the column and 1 and 2 designate the first and last cell
rows, respectively. For example, if one set of values is in column Q,
rows 10 through 15 and the second set of values is in column R, rows
10 through 15, enter the range in the left field as Q10:Q15 and the
range in the right field as R10:R15.
Crystal Ball calculates the correlation coefficient, enters it in the field
to the left of the correlation coefficient scale, and moves the slider
control to the correct position.
Crystal Ball Note: The two cell ranges do not necessarily have to have the same
dimensions, but they must contain the same number of value cells and must be in the
same workbook. The cell ranges are read in a row-by-row fashion.
Each time you select a new assumption or correlation coefficient, Crystal Ball
displays a sample correlation of the correlated assumption values in the chart
to the right.
Crystal Ball User Manual
37