Implications for the Manager

A tornado diagram is a useful picture of the relative effects of uncertainties upon the measure of value (usually NPV). Knowing which uncertainties are important allows you to focus your attention on what is important. Many times experts will disagree—sometimes passionately—about the ranges that should be associated with your uncertainties. If—using the widest possible assessments between the p10 and p90—the uncertainty is low on the tornado, this can help the experts to more quickly agree on how the uncertainty should be approached.

The first few times you develop a tornado graph in Excel will take some time, but after you’ve done two or three, you can set them up reasonably quickly. And, as we noted earlier, completing ...

Get Decision Analysis for Managers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.