@Risk

 

Up

 

@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:

  1. 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.
  2. 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.
  3. 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:

bulletIntegrated distribution fitting: Defines distribution functions for you based on historical or industry data.
bullet@RISK Library: A SQL database for storing and sharing with others @RISK distribution functions, model components, and simulation results.
bulletExcel 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.
bulletStress 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.
bulletAdvanced Sensitivity Analysis: Lets you see how changes in any input – distributions or regular values – affect simulation results.
bullet@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:

bulletRISKOptimizer 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.
bulletIntegrated @RISKAccelerator: Speed up large simulations with parallel processing by using multi-core processors and up to four CPUs within a single machine.

Copyright 1995-2011 - Last updated 05-March-2015