Practical Spreadsheet Modeling Using atRisk (Hardcover)

Dale Lehman

ISBN 10: 0367173867 / ISBN 13: 9780367173869

Published by Taylor & Francis Ltd, London, 2019

About this Item

Hardcover. Practical Spreadsheet Modeling Using atRisk provides a guide of how to construct applied decision analysis models in spreadsheets. The focus is on the use of Monte Carlo simulation to provide quantitative assessment of uncertainties and key risk drivers. The book presents numerous examples based on real data and relevant practical decisions in a variety of settings, including health care, transportation, finance, natural resources, technology, manufacturing, retail, and sports and entertainment. All examples involve decision problems where uncertainties make simulation modeling useful to obtain decision insights and explore alternative choices. Good spreadsheet modeling practices are highlighted. The book is suitable for graduate students or advanced undergraduates in business, public policy, health care administration, or any field amenable to simulation modeling of decision problems. The book is also useful for applied practitioners seeking to build or enhance their spreadsheet modeling skills.Features Step-by-step examples of spreadsheet modeling and risk analysis in a variety of fields Description of probabilistic methods, their theoretical foundations, and their practical application in a spreadsheet environment Extensive example models and exercises based on real data and relevant decision problems Comprehensive use of the atRisk software for simulation analysis, including a free one-year educational software license 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, this book dispenses concentrates on how powerful techniques and methods can be used correctly within a spreadsheet-based environment Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Seller Inventory # 9780367173869

Bibliographic Details

• Title: Practical Spreadsheet Modeling Using atRisk (Hardcover)
• Publisher: Taylor & Francis Ltd, London
• Publication Date: 2019
• Language: English
• ISBN 10: 0367173867
• ISBN 13: 9780367173869
• Binding: Hardcover
• Condition: new

About this title

Synopsis

Practical Spreadsheet Modeling Using @Risk provides a guide of how to construct applied decision analysis models in spreadsheets. The focus is on the use of Monte Carlo simulation to provide quantitative assessment of uncertainties and key risk drivers. The book presents numerous examples based on real data and relevant practical decisions in a variety of settings, including health care, transportation, finance, natural resources, technology, manufacturing, retail, and sports and entertainment. All examples involve decision problems where uncertainties make simulation modeling useful to obtain decision insights and explore alternative choices. Good spreadsheet modeling practices are highlighted. The book is suitable for graduate students or advanced undergraduates in business, public policy, health care administration, or any field amenable to simulation modeling of decision problems. The book is also useful for applied practitioners seeking to build or enhance their spreadsheet modeling skills.

Features

• Step-by-step examples of spreadsheet modeling and risk analysis in a variety of fields
• Description of probabilistic methods, their theoretical foundations, and their practical application in a spreadsheet environment
• Extensive example models and exercises based on real data and relevant decision problems
• Comprehensive use of the @Risk software for simulation analysis, including a free one-year educational software license

About the Author

Dale E. Lehman, PhD, is Professor of Business Administration and Director of the EMBA in Business Analytics at Loras College. He has taught at numerous universities in North America, Europe, and Asia. He has also published extensively in the areas of microeconomics, with applications in the telecommunications, health care, and natural resource industries. He has authored three previous books in these areas.

Huybert Groenendaal, PhD, is Managing Director at EpiX Analytics. He has extensive experience in using risk modeling to support decision making in fields that include business development, financial valuation, and R&D portfolio evaluation within the pharmaceutical and medical device industries, as well as health and epidemiology, energy, manufacturing and private equity. He regularly teaches risk analysis training classes.