E-Book Overview
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. Highlights 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.
E-Book Content
Practical Spreadsheet Risk Modeling for Management
Dale Lehman Huybert Groenendaal Greg Nolder
Practical Spreadsheet Risk Modeling for Management
Practical Spreadsheet Risk Modeling for Management
Dale Lehman Huybert Groenendaal Greg Nolder
CRC Press Taylor & Francis Group 6000 Broken Sound Parkway NW, Suite 300 Boca Raton, FL 33487-2742 © 2012 by Taylor & Francis Group, LLC CRC Press is an imprint of Taylor & Francis Group, an Informa business No claim to original U.S. Government works Version Date: 20110808 International Standard Book Number-13: 978-1-4398-5554-6 (eBook - PDF) This book contains information obtained from authentic and highly regarded sources. Reasonable efforts have been made to publish reliable data and information, but the author and publisher cannot assume responsibility for the validity of all materials or the consequences of their use. The authors and publishers have attempted to trace the copyright holders of all material reproduced in this publication and apologize to copyright holders if permission to publish in this form has not been obtained. If any copyright material has not been acknowledged please write and let us know so we may rectify in any future reprint. Except as permitted under U.S. Copyright Law, no part of this book may be reprinted, reproduced, transmitted, or utilized in any form by any electronic, mechanical, or other means, now known or hereafter invented, including photocopying, microfilming, and recording, or in any information storage or retrieval system, without written permission from the publishers. For permission to photocopy or use material electronically from this work, please access www.copyright. com (http://www.copyright.com/) or contact the Copyright Clearance Center, Inc. (CCC), 222 Rosewood Drive, Danvers, MA 01923, 978-750-8400. CCC is a not-for-profit organization that provides licenses and registration for a variety of users. For organizations that have been granted a photocopy license by the CCC, a separate system of payment has been arranged. Trademark Notice: Product or corporate names may be trademarks or registered trademarks, and are used only for identi