Correlating Assumptions with Definitions in List View and Correlating Assumptions in Matrix View provide specific information about correlating assumptions in different ways. The following is other general information not contained in those topics or elsewhere:
Correlations and correlation matrixes are always contained within single workbooks; they cannot span workbooks.
Unlinked matrices or linked matrices without given names are named automatically. If you delete Matrix 1, Matrix 2 is renamed Matrix 1, and so on.
When entering correlations in either List or Matrix view for a matrix that is not linked to a worksheet, you can enter a decimal, a cell reference, or a range name.
When adding assumptions, you cannot add an assumption that is part of a linked matrix.
An uncorrelated assumption cannot be correlated with an assumption in a linked matrix. However, it can be added to the linked matrix.
Generally, Crystal Ball can correlate discrete distributions with other discrete or continuous distributions without problems. However, if one of the correlated distributions is discrete with a low number of data points (for example, less than 5 bars visible in the Define Assumption dialog), then an inaccurate correlation can result; that is, the imparted correlation is generally lower than the input correlation.
The accuracy of imparted correlations improves with the number of trials—the more trials, the greater the correlation accuracy. The only exception occurs when correlating discrete distributions with a low number of data points, in which case accuracy does not improve with the number of trials.
Initial selections determine what displays in the Define Correlations dialog (About the Define Correlations Dialog, Cell Selection Rules for Smart Selection).