What is the quickest way to create a correlation matrix?
• In Excel, Click the List Inputs by Outputs toolbar button. • In the Explorer pane of the @RISK-Model window, select the inputs to be correlated. You can use the Shift key to select a contiguous range of inputs, or the Ctrl key to select a disjoint range of inputs. • Right click, and choose the Correlate Distributions menu item from the pop-up menu. This creates a new correlation window, with the selected elements “attached” to the row and column headers. • Fill in the matrix coefficients which relate the distributions to one another. • Click the Apply button. Q2: What is the quickest way to add a new input to an existing correlation matrix? A2: Note: This information is valid for @RISK 4.0.3 or higher. In previous versions of @RISK, you must use a slightly more complicated procedure. • Locate the existing matrix’s entry in the @RISK Explorer pane of the @RISK-Model window. • Right click and choose Edit Correlation Matrix from the pop-up menu. • Select the input or inputs you wish to
