Practical Spreadsheet Risk Modeling for Management

1st Edition

Dale Lehman, Huybert Groenendaal, Greg Nolder

Chapman and Hall/CRC
Published September 8, 2011
Reference - 284 Pages - 190 B/W Illustrations
ISBN 9781439855522 - CAT# K12589

For Instructors Request Inspection Copy


Add to Wish List
FREE Standard Shipping!


Risk analytics is developing rapidly, and analysts in the field need material that is theoretically sound as well as practical and straightforward. A one-stop resource for quantitative risk analysis, Practical Spreadsheet Risk Modeling for Management dispenses with the use of complex mathematics, concentrating on how powerful techniques and methods can be used correctly within a spreadsheet-based environment.


  • Covers important topics for modern risk analysis, such as frequency-severity modeling and modeling of expert opinion
  • Keeps mathematics to a minimum while covering fairly advanced topics through the use of powerful software tools
  • Contains an unusually diverse selection of topics, including explicit treatment of frequency-severity modeling, copulas, parameter and model uncertainty, volatility modeling in time series, Markov chains, Bayesian modeling, stochastic dominance, and extended treatment of modeling expert opinion
  • End-of-chapter exercises span eight application areas illustrating the broad application of risk analysis tools with the use of data from real-world examples and case studies

This book is written for anyone interested in conducting applied risk analysis in business, engineering, environmental planning, public policy, medicine, or virtually any field amenable to spreadsheet modeling. The authors provide practical case studies along with detailed instruction and illustration of the features of ModelRisk®, the most advanced risk modeling spreadsheet software currently available. If you intend to use spreadsheets for decision-supporting analysis, rather than merely as placeholders for numbers, then this is the resource for you.