Examples of Performing Simulations on Spreadsheets with Crystal Ball
Examples of Performing Simulations on Spreadsheets with Crystal Ball
Section 20.6 introduced the subject of how to perform simulations on a spreadsheet
while using the powerful Excel add-in, Crystal Ball 2000 (Professional Edition), which
is included on the CD-ROM. This chapter elaborates considerably further on the same
subject.
Sections 28.1–28.5 present five additional examples that further illustrate how to formulate
simulation models on a spreadsheet for a variety of important applications while
applying Crystal Ball. Section 28.6 then describes Crystal Ball’s Distribution Gallery and
the characteristics of the 17 probability distributions it provides. A special procedure that
Crystal Ball provides for identifying the continuous distribution that best fits historical
data is also outlined. Section 28.7 illustrates the application of Crystal Ball’s Decision
Table tool to two of the previous examples.
