Skip to main content Accessibility help
×
Hostname: page-component-7479d7b7d-m9pkr Total loading time: 0 Render date: 2024-07-10T21:39:01.887Z Has data issue: false hasContentIssue false

10 - Visualizing Complex Analytical Dynamics

from SECTION 3 - LEVERAGING DYNAMIC ANALYSIS

Published online by Cambridge University Press:  06 July 2010

Elliot Bendoly
Affiliation:
Emory University, Atlanta
Get access

Summary

The visualization of analytical dynamics comes naturally to 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 of such estimates and then graph those tabular forms. As always, pressing the F9 key would simply draw another random number from the built-in generator, and augment associated data tables and plots to represent such the volatility of those outcomes.

For example, based on the Data Table generated in the Lobo's Reservations case, we could depict the variable nature of our results graphically using the high-low-close plot (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 (based simply on different separate and independent sets of random data draws). The result, as shown in Figure 1.1, would depict an alternative array of outcomes that could be associated with a set of decisions. Similarly with the second Data Table example in that case, shown in Figure 10.2.

This in itself might be entirely adequate in providing insights regarding the sufficiency of the number of variants examined.

Type
Chapter
Information
Excel Basics to Blackbelt
An Accelerated Guide to Decision Support Designs
, pp. 229 - 246
Publisher: Cambridge University Press
Print publication year: 2008

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

Save book to Kindle

To save this book to your Kindle, first ensure coreplatform@cambridge.org is added to your Approved Personal Document E-mail List under your Personal Document Settings on the Manage Your Content and Devices page of your Amazon account. Then enter the ‘name’ part of your Kindle email address below. Find out more about saving to your Kindle.

Note you can select to save to either the @free.kindle.com or @kindle.com variations. ‘@free.kindle.com’ emails are free but can only be saved to your device when it is connected to wi-fi. ‘@kindle.com’ emails can be delivered even when you are not connected to wi-fi, but note that service fees apply.

Find out more about the Kindle Personal Document Service.

Available formats
×

Save book to Dropbox

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Dropbox.

Available formats
×

Save book to Google Drive

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Google Drive.

Available formats
×