Incorporating Risk Analysis Into Spreadsheet Forecastsby Douglas L. Wentworth, Harris County MTA, United States,
Abstract: The risk analysis technique presented overcomes the difficulties of sensitivity analysis by entering key input variables as probability distributions, rather than as discreet values. Using a well established technique called Monte Carlo Simulation, the analyst can easily modify his forecasting model to produce the bottom line results as a probability distribution also. This paper discusses the title subject by presenting a description of the model layout and application, and considerations in using risk analysis.
Subject Headings: Risk management | Forecasting | Spreadsheets | Sensitivity analysis | Model analysis | Transportation studies | Probability | Computer models | Probability distribution | Europe | Monaco | Monte Carlo
Services: Buy this book/Buy this article
Return to search