Table of Contents | 6: Customized Input Distributions |
1: Modeling | 7: Decision Analysis – Expected Value Maximization |
2: Sensitivity Analysis | 8: Decision Analysis – Advanced Topics |
3: Indexed Sensitivity Analysis | 9: Optimization: Decisions With Constraints |
4: Scenario Analysis | 10: Optimization: Excel Solver |
5: Simulation Analysis | 11: Epilogue |
Unlock the power of prescriptive analytics using Excel. Jeffrey M. Keisler’s book offers a step-by-step guide to mastering sensitivity, scenario, simulation, decision, and optimization analysis with standard spreadsheet features. Learn through clear explanations, detailed screenshots, and practical examples.
Understand complex models and calculations through intuitive influence diagrams and non-intimidating terminology.
Apply what you learn immediately with step-by-step instructions and numerous screenshots for hands-on learning.
Expand your knowledge and skills with well-structured chapters, enrichment resources, and guidance for future career trajectories.
Jeffrey M. Keisler (MBA Chicago, PhD Harvard) is a renowned Professor of Management Science & Information Systems at the University of Massachusetts Boston.
With a distinguished career spanning over 30 years in industry, government, consulting, and academia, he has extensively applied and taught prescriptive analytics and spreadsheet tools. A former President of the INFORMS Decision Analysis Society and a Fellow of multiple prestigious societies, Keisler is also a prolific author and respected editor in his field.
Rooted in a rigorous decision framework, one of the most intuitive and accessible journeys into the world of prescriptive analytics.
Head of Management Science and Operations Group, Loughborough University
How can we make high quality decisions in an increasingly data-rich but also uncertain and complex world? This book provides the answer, preparing you for the prescriptive analytic future.
Professor of Operations Management, University of Bristol.
An important book. It will be invaluable in entry-level courses in prescriptive analytics and all related fields.
Director, Systems Engineering and Design Program, University of Michigan
A remarkable in-depth treatment of implementing complex analytical formulations using spreadsheets in a simple and accessible way.
Founding Director of the Neely Center for Ethical Leadership and Decision-Making, University of Southern California
This book starts the study of analytics with a simple problem and a few basic Excel formulas, and staying within that framework and emphasizing comprehension, builds up to cover all of the mainstream analytic topics and some very advanced ones as well.
Founding Dean, School of Business, Stockton University
A fresh and pragmatic approach to the challenges of developing analytical thinkers – and doers. Students will quickly add useful tools, and they’ll start to connect the dots of the bigger picture.
Emeritus Professor of Management & Decision Sciences. Emory University