Book contents
- Frontmatter
- Contents
- Associated Links
- Preface
- Section 1 Getting Oriented
- Section 2 Harvesting Intelligence
- Section 3 Leveraging Dynamic Analysis
- 8 Controlled Simulation Analysis
- 9 Simulation Search, Optimization, and Reporting
- 10 Visualizing Complex Analytical Dynamics
- Section 4 Advanced Automation and Interfacing
- Glossary of Key Terms
- Appendix: Shortcut (Hot Key) Reference
- Index
10 - Visualizing Complex Analytical Dynamics
Published online by Cambridge University Press: 05 August 2013
- Frontmatter
- Contents
- Associated Links
- Preface
- Section 1 Getting Oriented
- Section 2 Harvesting Intelligence
- Section 3 Leveraging Dynamic Analysis
- 8 Controlled Simulation Analysis
- 9 Simulation Search, Optimization, and Reporting
- 10 Visualizing Complex Analytical Dynamics
- Section 4 Advanced Automation and Interfacing
- Glossary of Key Terms
- Appendix: Shortcut (Hot Key) Reference
- Index
Summary
The visualization of analytical dynamics comes naturally to the tools developed in Excel. This is largely due to the dynamic nature of graphs constructed in Excel. For example, if we wanted to depict the range of possible outcomes associated with specific decisions for which outcomes had a describable level of uncertainty or variation, it would be simple enough to introduce a random term into tabular forms and then graph the result. As always, pressing the F9 key would simply draw another random number from the built-in generator and augment the associated data tables and plots to represent the volatility of those outcomes.
For example, based on the Data Table generated in the Lobo's Reservations case, we could graphically depict the variable nature of our results using the high-low-close plot (although tricked out a bit) provided in that workbook. Every time F9 is pressed, we would see how much the variability in outcomes across policy types was subject to change (simply based on different separate and independent sets of random data draws). The result, shown in Figure 10.1, would depict an alternative array of outcomes that could be associated with a set of decisions. Another example is shown with the second Data Table example, shown in Figure 10.2.
- Type
- Chapter
- Information
- Excel Basics to BlackbeltAn Accelerated Guide to Decision Support Designs, pp. 269 - 288Publisher: Cambridge University PressPrint publication year: 2013