Practical Spreadsheet Modeling Using @Risk

By Dale Lehman and Huybert Groenendaal

Book Overview

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

• Format: Hardcover
• Language: English
• ISBN: 0367173867
• ISBN13: 9780367173869
• Release Date: December 2019
• Publisher: CRC Press
• Length: 222 Pages
• Weight: 1.27 lbs.
• Dimensions: 0.7" x 7.1" x 10.2"