@RISK Key Features

Feature Benefit
Professional
Industrial
Monte Carlo simulation Shows possible outcomes to avoid pitfalls and identify opportunities Monte Carlo simulation
Introduction to Risk Analysis using @RISK
100% Excel calculations for simulation Highest level of accuracy, and maximum use of multi-core processors for speed 100% Excel calculations for simulation
Seamless Integration into Microsoft Excel Never leave your spreadsheet; get up to speed quickly Seamless Integration into Microsoft Excel
@RISK Ribbon and Toolbar
Intuitive toolbars and right-click menus Easy navigation—multiple ways to perform common tasks Intuitive toolbars and right-click menus
Distribution Palette and Insert Function command Easy and accurate definition of uncertain factors Distribution Palette and Insert Function command
Which Distribution Should I Choose in @RISK
Distribution Fitting and Distribution Artist Use data and expert judgment to define uncertain factors Distribution Fitting and Distribution Artist
Better Distribution Fitting in @RISK
Over 90 built-in distribution functions Represent virtually any uncertain factor for accurate modeling Over 90 built-in distribution functions
@RISK Function Swap Remove (and later restore) @RISK functions for sharing models with non-@RISK users @RISK Function Swap
Thumbnail Graphs Graphically share input distributions and simulation results with non-@RISK users Thumbnail Graphs
@RISK Library Define, reuse, and share custom distributions and simulation results @RISK Library
@RISK Library
Compound function Combines two distributions into one, to streamline insurance or other large models Compound function
Precentile distribution parameters More flexible ways to define uncertainty Precentile distribution parameters
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. Correlation and Copulas
@RISK Correlation and Copulas: Gaining Insights into your Inputs
@RISK Data Viewer Display any spreadsheet data using all @RISK charts and graphing options @RISK Data Viewer
Integration with Microsoft Project Read Microsoft Project schedules into @RISK for Excel for risk modeling of any project with maximum flexibility Integration with Microsoft Project
Introduction to Project Risk Management using @RISK
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 Excel Developer Kit (XDK)
Automating @RISK for Excel with VBA Programming
Demo Mode and live updating Graphs and reports update during simulation for illustration to others Demo Mode and live updating
Extensive settings control Customize simulations to specific needs Extensive settings control
Fully customizable, presentation-quality graphs See the impact of risk and communicate to stakeholders Fully customizable, presentation-quality graphs
Graphs in @RISK
Reporting in Office All graphs and charts can be exported to Excel, Word, and PowerPoint in native chart format for easy distribution to others Reporting in Office
One-click Quick Reports Create exactly the simulation results reports you want directly in Excel, automatically formatted for optimal viewing. Apply Excel themes to your graphs. One-click Quick Reports
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. Customized Excel Reports
Histograms, area, line, cumulative, summary, box plot, and overlay graphs Variety of graphing and charting options for easy, accurate communication Histograms, area, line, cumulative, summary, box plot, and overlay graphs
Tornado charts and scatter plots Visually identify critical factors and trends, overall and for particular scenarios Tornado charts and scatter plots
@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 Sensitivity and Scenario Analysis
@RISK Tornado Graphs and Sensitivity Analysis: Gaining Insights into your Models
Six Sigma functions Report Six Sigma statistics for quality analysis Six Sigma functions
@RISK Advanced Features: Six Sigma Functions
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 Stress Analysis
@RISK Advanced Features: Stress Analysis
Advanced Sensitivity Analysis Lets you see how changes in any input—distributions or regular values—affect simulation results Advanced Sensitivity Analysis
Sensitivity Analysis in @RISK
@RISK Goal Seek Uses multiple simulations to find an input value that achieves a target simulation result you specify @RISK Goal Seek
@RISK Advanced Features: Goal Seek
Simulation of Time-series forecasts Understand the risks in values that change over time Simulation of Time-series forecasts
@RISK Advanced Features: Time Series
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. Correlation of Time Series
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. Multi-core processor and multiple CPU support
RISKOptimizer Solve problems with more accuracy than ever
More on RISKOptimizer
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. Optimization under uncertainty
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 Efficient Frontier Analysis
Ranges for adjustable cells and constraints Streamlined model setup and editing Ranges for adjustable cells and constraints
Genetic algorithms Find the best global solution while avoiding getting caught in local, “hill-climbing” solutions Genetic algorithms
Six solving methods, including GAs and OptQuest Always have the best method for different types of problems Six solving methods, including GAs and OptQuest
RISKOptimizer Watcher Monitor progress toward best solutions RISKOptimizer Watcher
Convergence monitoring and genetic operators Monitor progress toward best solutions Convergence monitoring and genetic operators
Original, Best, Last model updating Instantly see the effects of three solutions on your entire model Original, Best, Last model updating