9780470387191

Modeling for Insight is a one-of-a-kind guide to building effective spreadsheet models and using them to generate insights. It provides readers with an effective modeling process and specific modeling tools to become a master modeler. The authors demonstrate how to approach problem-solving using four main steps: frame the problem, diagram the problem, build a model, and generate insights. Extensive examples, graduated in difficulty, help readers to internalize this modeling process, while also demonstrating the application of important modeling tools.

Preface
Using this book
Acknowledgments
Acknowledgments For Cases
About The Authors

Introduction
Models and Modeling
Well-Structured versus Ill-Structured Problems
Modeling versus Problem Solving
Modeling for Insight
Novice Modelers and Expert Modelers
Craft Skills in Modeling
A Structured Modeling Process
Modeling Tools
Summary
Foundations of Modeling for Insight
Introduction
The Modeling Process
Tools for Modeling
Presentation Skills
Summary
Spreadsheet Engineering
Why Use Spreadsheets?
Spreadsheet Engineering
Summary

A First Example-The Red Cross Problem
Introduction
The Red Cross Problem
Bringing Blood Quality into the Analysis
Improving and Iterating
Summary
Retirement Planning Problem
Introduction
Retirement Planning (A)
Retirement Planning (B)
Retirement Planning (C)
Presentation of Results
Summary
Technology Option
Introduction
Technology Option (A)
Technology Option (B)
Frame the Problem-M
Additional Refi nements
Presentation of Results
Summary

MediDevice
Introduction
MediDevice Case (A)
Revising the Model
MediDevice Case (B)
Presentation of Results
Summary
Draft Commercials
Introduction
Draft Commercials Case
Frame the Problem
Diagram the Problem
M1 Model and Analysis
M2 Model and Analysis
M3 Model and Analysis
M4 Model and Analysis
Presentation of Results
Summary
New England College Skiway
Introduction
New England College Skiway Case
Frame the Problem
Diagram the Problem
M1 Model and Analysis
Analyzing Mountain Capacity
M2 Model and Analysis
M3 Model and Analysis
Considering Uncertainty
Presentation of Results
Summary
National Leasing, Inc
Introduction
National Leasing Case
Frame the Problem
Diagram the Problem
M1 Model and Analysis
M2 Model and Analysis
M3 Model and Analysis
M4 Model and Analysis
Presentation of Results
Summary
Pharma X and Pharma Y
Introduction
The Pharma X and Pharma Y Case
Frame the Problem
Diagram the Problem
Expected Value or Simulation?
M1 Model and Analysis
M2 Model and Analysis
M3 Model and Analysis
Presentation of Results
Summary
Invivo Diagnostics, Inc
Introduction
Invivo Diagnostics Case
Frame and Diagram the Problem
M1 Model and Analysis
M2 Model and Analysis
M3 Model and Analysis
M4 Model and Analysis
Presentation of Results
Summary
Guide to Solver
Guide to Crystal Ball
Guide to the Sensitivity Toolkit
Index
Table of Contents provided by Publisher. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

Modeling for Insight: A Master Class for Business Analysts

047038719X

Summary

Table of Contents

Supplemental Materials

Rewards Program