Using Simulation to Develop S-curves
There are two commercially available products that can be used to run Monte Carlo (random number) simulations: @Risk™ and Crystal Ball™. These programs use your Excel model as a calculation engine, and you specify the input distributions for each uncertainty that you want to use and then specify the measures of value that you want to examine. Once you’ve run the simulation, you can extract the data and develop a graph similar to the one in Figure 9.3. As these products have been extensively written about elsewhere,1 I’m not going to provide step-by-step instructions on how to operate the software.
The advantage of using one of the commercial programs is that you can set up the simulation much more quickly ...
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.
