|
| |
@RISK is a true add-in to Microsoft Excel, integrating
completely with your spreadsheet. Browse, define, analyze – while never leaving
Excel. All @RISK functions are true Excel functions, and behave exactly as
native Excel functions do. @RISK windows are all linked directly to cells in
your spreadsheet, so changes in one place are carried out in the other. @RISK
graphs point to their cells via callout windows. Drag-and-drop ease,
context-sensitive right-click menus, and the @RISK toolbar make learning and
navigating @RISK a snap.
Running an analysis with @RISK involves three simple steps:
- Set Up Your Model. Start by replacing
uncertain values in your spreadsheet with @RISK probability distribution
functions, like Normal, Uniform, or over 35 others. These @RISK functions
simply represent a range of different possible values that a cell could take
instead of limiting it to just one case. Choose your distribution from a
graphical gallery, or define distributions using historical data for a given
input. Even combine distributions with @RISK’s Compound function. Share
specific distribution functions with others using the @RISK Library, or swap
out @RISK functions for colleagues who don’t have @RISK.
Next, select your outputs – the "bottom line" cells whose values interest
you. This could be potential profits, ROI, insurance claims payout, disease
recovery rate, or anything at all.
- Run the Simulation. Click the Simulate
button and watch. @RISK recalculates your spreadsheet model thousands of
times. Each time, @RISK samples random values from the @RISK functions you
entered, places them in your model, and records the resulting outcome.
Explain the process to other by running your simulation in Demo Mode, with
graphs and reports updating live as the simulation runs.
- Understand Your Risks. The result of a
simulation is a look at a whole range of possible outcomes, including the
probabilities they will occur. Graph your results with histograms, Scatter
Plots, cumulative curves, Box Plots, and more. Identify critical factors
with Tornado charts and sensitivity analysis. Paste results into Excel,
Word, or PowerPoint, or place them in the @RISK Library for other @RISK
users. You can even save results and charts right inside your Excel
workbook.
@RISK Professional
Designed for professional-grade problems in any industry, @RISK Professional is
perfect for most commercial uses. It provides a balance of advanced analysis and
point-and-click ease of use, and includes:
 | Integrated distribution fitting: Defines distribution
functions for you based on historical or industry data. |
 | @RISK Library: A SQL database for storing and sharing
with others @RISK distribution functions, model components, and simulation
results. |
 | Excel Developer Kit (XDK): Automate and customize @RISK
for Excel through a complete library of commands and functions that let you
control every aspect of @RISK in your spreadsheet. Add @RISK for Excel to
any custom application. |
 | Stress Analysis: Lets you control the range that is
sampled from a distribution function, enabling you to see how different
scenarios affect your bottom line without changing your model. |
 | Advanced Sensitivity Analysis: Lets you see how changes
in any input – distributions or regular values – affect simulation results. |
 | @RISK Goal Seek: Uses multiple simulations to find an
input value that achieves a target simulation result you specify. |
@RISK Industrial
Designed for your largest, most complex models, @RISK Industrial
includes everything in @RISK Professional, plus the following:
 | RISKOptimizer 5.0: Combine Monte Carlo simulation with
genetic algorithm-based optimization to find the best combination of factors
to lead to a desired result under uncertain conditions. |
 | Integrated @RISKAccelerator: Speed up large simulations
with parallel processing by using multi-core processors and up to four CPUs
within a single machine. |
|