DESCRIPTION
|
|
SensIt Sensitivity Analysis Add-In
For Microsoft
® Excel 97-2007, Windows or Macintosh |
|
|
|
SensIt
®
performs sensitivity analysis on
your worksheet what-if model and creates simple plots, spider charts,
and tornado charts. In a decision situation, sensitivity analysis helps
you determine which of your input assumptions are critical so that you
know where to focus your effort for gathering more information or
reducing uncertainty. |
|
Benefits: |
* |
Save time by automating your what-if sensitivity analysis. |
|
* |
Identify which of your model's input assumptions are
critical. |
|
* |
Use Sensit's charts to explain your analysis to
colleagues. |
|
* |
Decide which inputs require probability distributions for
subsequent Monte Carlo simulation using RiskSim. |
|
* |
Easily use the single-file SensIt add-in with no
complicated installation; simply open SensIt.xla whenever and wherever
you need it. |
To use SensIt, you
(1) create a spreadsheet model,
(2) identify the input cells (e.g., variable cost, demand,
etc.),
(3) specify a range for each input
value,
(4) identify the output cell (e.g., annual profit), and
(5) choose Tools | Sensitivity Analysis from Excel's menu.
|
|