@RISK Key Features

Feature Benefit
Monte Carlo simulation Shows possible outcomes to avoid pitfalls and identify opportunities
Introduction to Risk Analysis using @RISK
100% Excel calculations for simulation Highest level of accuracy, and maximum use of multi-core processors for speed
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
Distribution Palette and Insert Function command Easy and accurate definition of uncertain factors
Which Distribution Should I Choose in @RISK
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 Correlation and Copulas: Gaining Insights into your Inputs
@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
Demo Mode and live updating Graphs and reports update during simulation for illustration to others
Extensive settings control Customize simulations to specific needs
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
@RISK Tornado Graphs and Sensitivity Analysis: Gaining Insights into your Models
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
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
More on RISKOptimizer

Rocking Optimization with RISKOptimizer - Decision Making Under Uncertainty
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.
Rocking Optimization with RISKOptimizer - Decision Making Under Uncertainty
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