Mitigate Risks
@RISK (pronounced “at risk”) software is an add-in tool for Microsoft Excel that helps you make better decisions through risk modeling and analysis. It does this using a technique known as Monte Carlo simulation. @RISK’s Monte Carlo analysis computes and tracks many different possible future scenarios in your risk model, showing you the probability of each occurring. In this way, @RISK shows you virtually all possible outcomes for any situation. This probabilistic approach makes @RISK a powerful tool that you can use to judge which risks to take and which ones to avoid — critical insight in today’s uncertain world.
Learn how @RISK has helped decision makers to improve risk and decision analysis efforts.
| Feature | Benefit | Professional Edition | Industrial Edition |
|---|---|---|---|
| Monte Carlo simulation | Shows possible outcomes to avoid pitfalls and identify opportunities |  | |
| 100% Excel calculations for simulation | Highest level of accuracy, and maximum use of multi-core processors for speed | | |
| Feature | Benefit | Professional Edition | Industrial Edition |
|---|---|---|---|
| Seamless Integration into Microsoft Excel | Never leave your spreadsheet; get up to speed quickly | | |
| Intuitive toolbars and right-click menus | Easy navigation—multiple ways to perform common tasks | | |
| Feature | Benefit | Professional Edition | Industrial Edition |
|---|---|---|---|
| Distribution Palette and Insert Function command | Easy and accurate definition of uncertain factors | | |
| Distribution Fitting and Distribution Artist | Use data and expert judgment to define uncertain factors | | |
| Over 90 built-in distribution functions | Represent virtually any uncertain factor for accurate modeling | | |
| @RISK Function Swap | Remove (and later restore) @RISK functions for sharing models with non-@RISK users | | |
| Predefined Distributions | Create customized distributions with your own parameters and names | | |
| Compound function | Combines two distributions into one, to streamline insurance or other large models | | |
| Percentile distribution parameters | More flexible ways to define uncertainty | | |
| Correlation and Copulas | Standard correlation available, along with copulas, which provide sophisticated methods for correlating uncertain @RISK variables that allow more control over the correlation pattern | | |
| @RISK Data Viewer | Display any spreadsheet data using all @RISK charts and graphing options | | |
| Excel Developer Kit (XDK) | Automate and customize @RISK for Excel through a library of commands and functions that let you control every aspect of @RISK in your spreadsheet | | |
| Feature | Benefit | Professional Edition | Industrial Edition |
|---|---|---|---|
| Demo Mode and live updating | Graphs and reports update during simulation for illustration to others | | |
| Extensive settings control | Customize simulations to specific needs | | |
| Feature | Benefit | Professional Edition | Industrial Edition |
|---|---|---|---|
| Fully customizable, presentation-quality graphs | See the impact of risk and communicate to stakeholders | | |
| Reporting in Office | All graphs and charts can be exported to Excel, Word, and PowerPoint in native chart format for easy distribution to others | | |
| Customized Excel Reports | Create exactly the simulation results reports you want directly in Excel, automatically formatted for optimal viewing. Apply Excel themes to your graphs. | | |
| Histograms, area, line, cumulative, summary, box plot, and overlay graphs | Variety of graphing and charting options for easy, accurate communication | | |
| Tornado charts and scatter plots | Visually identify critical factors and trends, overall and for particular scenarios | | |
| Sensitivity and Scenario Analysis | Identify the individual tasks that have the most impact on results, and the particular scenarios that lead to certain results | | |
| Six Sigma functions | Report Six Sigma statistics for quality analysis | | |
| 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 | | |
| Feature | Benefit | Professional Edition | Industrial Edition |
|---|---|---|---|
| Simulation of Time-series forecasts | Understand the risks in values that change over time |  | |
| Correlation of Time Series | It is possible to correlate two or more time-series functions so that during each iteration the array of values returned by the individual time series are subject to the specified correlation coefficient. | | |
| Multi-core processor and multiple CPU support | Speed up simulations. “Split up” large simulations to run on multiple CPUs or cores and reduce simulation run time. | | |
| RISKOptimizer | Solve problems with more accuracy than ever. | | |
| Feature | Benefit | Professional Edition | Industrial Edition |
|---|---|---|---|
| Optimization under uncertainty | Combines Monte Carlo simulation with sophisticated optimization techniques to find optimal solutions to uncertain problems. Used for budgeting, allocation, scheduling, and more. | | |
| Efficient Frontier Analysis | Especially useful in financial analysis, Efficient Frontiers determine the optimal return that can be expected from a portfolio at a given level of risk | | |
| Ranges for adjustable cells and constraints | Streamlined model setup and editing | | |
| Genetic algorithms | Find the best global solution while avoiding getting caught in local, “hill-climbing” solutions | | |
| Six solving methods, including GAs and OptQuest | Always have the best method for different types of problems | | |
| RISKOptimizer Watcher and Convergence Monitoring | Monitor progress toward best solutions in real time | | |
| Overlay of Optimized vs Original Distribution | Compare original output to optimized result to visually see improvements | | |
| Original, Best, Last model updating | Instantly see the effects of three solutions on your entire model | | |
@RISK and the DecisionTools Suite is only compatible in a Windows environment. If you have a Mac then you can set up a Windows emulator to access the software. More information on this set up is available here: https://community.lumivero.com/s/article/risk-on-the-apple-mac?language=en_US
Discover the globally trusted tool that empowers you to manage risk and make confident, data-driven decisions.
