Crystal_Ball (1) - Crystal Ball Copyright Iordanis...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Copyright ® Iordanis Karagiannidis Crystal Ball
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
FI 455 Crystal Ball Three new menus in Excel Define to define and select assumption, (decision), and forecast cells Run to start, reset, and single-step through simulation Analyze To create a variety of charts and reports
Background image of page 2
FI 455 Crystal Ball Defining Assumptions Assumption Cells = random independent variables Forecast Cells = dependent variables, contain formulas that refer to one or more assumption and decision variable cells Decision Variable Cells = variables that are within our control to change
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
FI 455 Crystal Ball Defining Assumptions Select cell or range of cells Choose Define > Define Assumption Select Distribution and click OK Input parameters and click OK Cell(s) turn green to identify as Assumptions
Background image of page 4
FI 455 Crystal Ball Defining Forecasts (dependent) Select a formula cell or range of cells that identifies dependent variables Select Define > Define Forecast Input forecast name and unit of measurement
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 15

Crystal_Ball (1) - Crystal Ball Copyright Iordanis...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online