As someone pointed out in a comment to my previous post, simply using RAND() in Excel gives you independent random variables. That’s perfectly OK for situations where the risks are not closely related to each other. For instance, the if you are trying to project the cost of bandwidth, the uncertainty in the growth of your traffic is likely to be independent from the uncertainty around the price per TB of data. But in many cases, risk is correlated and ignoring that correlation or relying on h...

As someone pointed out in a comment to my previous post, simply using RAND() in Excel gives you independent random variables. That’s perfectly OK for situations where the risks are not closely related to each other. For instance, the if you are trying to project the cost of bandwidth, the uncertainty in the growth of your traffic is likely to be independent from the uncertainty around the price per TB of data. But in many cases, risk is correlated and ignoring that correlation or relying on h...