Home → Techniques and Tips → @RISK for Project 4.x → Ranking Sensitivities by Correlation instead of Regression Coefficients
Applies to:
@RISK for Project 4.x
Question:
The default sensitivity analysis is based on regression coefficients, but I would like the tasks ranked by correlation coefficients. How can I accomplish that?
Response:
Tornado graphs display a ranking of the tasks. The input distributions that have the largest impact on the output will have the longest bars in the graph. By default, the length of the bar shown for each input distribution is based on the regression coefficients.
If you just want the coefficients as numbers, you get them automatically in Quick Reports and also in the Sensitivity report. But if you @RISK to arrange the inputs in order of impact as measured by correlation coefficient, you have two options:
Generate the Sensitivity Report. (In the Results window, click Results » Report Settings. Select Sensitivities, and click Generate Reports Now.) This report shows two sets of tables. The left-hand set shows the ranking of the tasks using regression coefficients, and the right-hand set shows the ranking of the tasks using correlation coefficients.
Open the Sensitivity Analysis window. (In the Results window, click Insert » Sensitivities.) In this window, a drop-down list lets you select which calculation method to use to rank the tasks.
last edited: 2013-01-15