@RISK | Risk Analysis in Excel | Lumivero (2024)

@RISK | Risk Analysis in Excel | Lumivero (1)

Mitigate Risks

From the financial to the scientific, anyone who faces uncertainty in their quantitative analyses can benefit from @RISK. @RISK integrates directly into Microsoft Excel and employs Monte Carlo simulation to map out all possible scenarios and the probability they will occur – taking the guesswork out of big decisions. With @RISK, you can calculate the chances of making money on your next venture, staying within budget, and more to plan strategies with confidence. Buy now or request a free trial to start uncovering new opportunities.

REQUEST A DEMOBUY @RISK

@RISK | Risk Analysis in Excel | Lumivero (2)

See All Possible Outcomes using Monte Carlo Simulation

H5 Subheading might be a lot of text here so let's make sure it'll look good in those circ*mstances. Great, this is exactly what I wanted. Good job.

@RISK | Risk Analysis in Excel | Lumivero (3)

How @RISK Works

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

Works with Microsoft Excel

Avoid Pitfalls and Uncover Opportunities with Risk Analysis

Plan Better Strategies

Model Risk Factors and Protect Yourself with Contingency Planning

Communicate Risk To Others

REQUEST A DEMOBUY @RISK

Endless Applications

As the pace of change in business continues to increase, organizations are challenged to increase margins and explore new opportunities for growth, all while reducing risk. @RISK is designed to meet these challenges.

Investment Planning & Portfolio Optimization. Simulate multiple portfolio assets (such as stocks, bonds, real estate, or projects) to maximize return while minimizing risk. Calculate Value-at-Risk, or the probability of different losses on a portfolio.

Cost Estimation. Get an accurate probabilistic estimate of materials and labor costs throughout the entire project. Understand the likelihood of going over budget under a variety of scenarios.

Engineering Reliability. Using Six Sigma calculations, gain insight into confidence levels around the risk of equipment failure or safety violations. Identify areas of weakness to ensure quality results and prevent failures.

Capital Reserves. Probabilistically forecast future claims or losses in order to determine optimal reserve levels. Perform stress testing on high-impact, low-probability events.

Oil, Gas, & Mineral Reserves. Assess the likelihood of prospective sites containing oil, natural gas, metals, or other minerals. Probabilistically estimate reserves and production decline in order to make wise drilling decisions.

REQUEST A DEMOBUY @RISK

@RISK | Risk Analysis in Excel | Lumivero (4)

@RISK | Risk Analysis in Excel | Lumivero (5)

Get Insights for Better Decisions

While @RISK provides sophisticated analytics, don’t be intimidated. All techniques @RISK uses are intuitive applications that integrate seamlessly with your existing Excel spreadsheets and provide actionable results with point-and-click ease.

Monte Carlo Simulation. By sampling different possible inputs, @RISK calculates thousands of possible future outcomes and the chances they will occur. This helps you avoid likely hazards — and uncover hidden opportunities.

100% Excel Integration. @RISK integrates seamlessly with Excel’s function set and ribbon, letting you work in a familiar environment with results you can trust.

Sensitivity Analysis. @RISK identifies and ranks the most important factors driving your risks so you can plan strategies — and resources — accordingly.

Graphs and Reports. @RISK offers a wide variety of customizable, exportable graphing and reporting options that let you communicate risk to all stakeholders.

Extensive Modeling Features. With a broad library of probability distributions, data fitting tools, and correlation modeling, @RISK lets you represent any scenario in any industry with the highest level of accuracy.

REQUEST A DEMOBUY @RISK

Customer Success Stories with @RISK

Learn how @RISK has helped decision makers to improve risk and decision analysis efforts.

  • "@RISK helps Petrobras reduce the calculation time for projections that used to take thousands of hours to a single day. If you multiply the saved hours by staff pay rates, you can get a pretty good picture of some huge cost savings." Rafael Hartke Financial Planning, PetrobrasREAD THE CASE STUDY
  • "The combination of our data and @RISK's technology has given us the confidence to predict exactly what risks we face, as a result of which we do not need to pay so much for our insurance." Ulrik Mester Risk Management Consultant at Post DanmarkREAD THE CASE STUDY
  • "@RISK tells us the probability of making our contractual dates and highlights any areas of risk that we may not have identified. We want to know what it’s going to take to hit our milestones on time – for example, launch is extremely important." Michael Watson Integrated Program Planning - NASA Orion Multi-Purpose Crew Vehicle, Lockheed MartinREAD THE CASE STUDY
  • "@RISK gives us the power to perform Monte Carlo methods in a single cell in Excel. This saves us time and simplifies the spreadsheets we work in." Liran Blasbalg Actuarial Analyst, DeloitteREAD THE CASE STUDY
  • "We love @RISK because it incorporates distribution fitting and gives us the flexibility to evaluate alternative distributions on screen." Art Misyan MerckREAD THE CASE STUDY

Industries Using @RISK

Enterprise Licensing
Better Research, Insights, and Outcomes for All

Whether your organization’s focus is qualitative, quantitative, or mixed methods data analysis, we can help your whole team work better together — collaborating to aggregate, organize, analyze, and present your findings. Lumivero’s enterprise licensing options offer volume pricing for teams and organizations needing nine (9) or more licenses.

Enterprise licenses allow the flexibility to install Lumivero software and solutions on multiple computers (up to the maximum number of licenses that your site has purchased) with a centralized management solution.

Lumivero’s team-based solutions allow you to:

Stay up-to-date with free upgrades to the latest releases

Reduce IT costs with one platform deployed across your organization

Reassign licenses to different users as teams evolve

Centralize license and subscription management in one place

Streamline budget allocation, especially for smaller groups and consultancy firms

Enjoy a Dedicated Customer Success Manager and pro-rated rates for new users

REQUEST A DEMO

@RISK Key Features

General

Interface

Modeling

Simulation

Simulation Results

Industrial Edition Features

RISKOptimizer

FeatureBenefitProfessional EditionIndustrial Edition
Monte Carlo simulationShows possible outcomes to avoid pitfalls and identify opportunities@RISK | Risk Analysis in Excel | Lumivero (12)@RISK | Risk Analysis in Excel | Lumivero (13)
100% Excel calculations for simulationHighest level of accuracy, and maximum use of multi-core processors for speed@RISK | Risk Analysis in Excel | Lumivero (14)@RISK | Risk Analysis in Excel | Lumivero (15)
FeatureBenefitProfessional EditionIndustrial Edition
Seamless Integration into Microsoft ExcelNever leave your spreadsheet; get up to speed quickly@RISK | Risk Analysis in Excel | Lumivero (16)@RISK | Risk Analysis in Excel | Lumivero (17)
Intuitive toolbars and right-click menusEasy navigation—multiple ways to perform common tasks@RISK | Risk Analysis in Excel | Lumivero (18)@RISK | Risk Analysis in Excel | Lumivero (19)
FeatureBenefitProfessional EditionIndustrial Edition
Distribution Palette and Insert Function commandEasy and accurate definition of uncertain factors@RISK | Risk Analysis in Excel | Lumivero (20)@RISK | Risk Analysis in Excel | Lumivero (21)
Distribution Fitting and Distribution ArtistUse data and expert judgment to define uncertain factors@RISK | Risk Analysis in Excel | Lumivero (22)@RISK | Risk Analysis in Excel | Lumivero (23)
Over 90 built-in distribution functionsRepresent virtually any uncertain factor for accurate modeling@RISK | Risk Analysis in Excel | Lumivero (24)@RISK | Risk Analysis in Excel | Lumivero (25)
@RISK Function SwapRemove (and later restore) @RISK functions for sharing models with non-@RISK users@RISK | Risk Analysis in Excel | Lumivero (26)@RISK | Risk Analysis in Excel | Lumivero (27)
Predefined DistributionsCreate customized distributions with your own parameters and names@RISK | Risk Analysis in Excel | Lumivero (28)@RISK | Risk Analysis in Excel | Lumivero (29)
Compound functionCombines two distributions into one, to streamline insurance or other large models@RISK | Risk Analysis in Excel | Lumivero (30)@RISK | Risk Analysis in Excel | Lumivero (31)
Percentile distribution parametersMore flexible ways to define uncertainty@RISK | Risk Analysis in Excel | Lumivero (32)@RISK | Risk Analysis in Excel | Lumivero (33)
Correlation and CopulasStandard correlation available, along with copulas, which provide sophisticated methods for correlating uncertain @RISK variables that allow more control over the correlation pattern@RISK | Risk Analysis in Excel | Lumivero (34)@RISK | Risk Analysis in Excel | Lumivero (35)
@RISK Data ViewerDisplay any spreadsheet data using all @RISK charts and graphing options@RISK | Risk Analysis in Excel | Lumivero (36)@RISK | Risk Analysis in Excel | Lumivero (37)
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@RISK | Risk Analysis in Excel | Lumivero (38)@RISK | Risk Analysis in Excel | Lumivero (39)
Which Distribution Should I Choose in @RISK
@RISK Correlation and Copulas

Gaining Insights into your Inputs

FeatureBenefitProfessional EditionIndustrial Edition
Demo Mode and live updatingGraphs and reports update during simulation for illustration to others@RISK | Risk Analysis in Excel | Lumivero (40)@RISK | Risk Analysis in Excel | Lumivero (41)
Extensive settings controlCustomize simulations to specific needs@RISK | Risk Analysis in Excel | Lumivero (42)@RISK | Risk Analysis in Excel | Lumivero (43)
FeatureBenefitProfessional EditionIndustrial Edition
Fully customizable, presentation-quality graphsSee the impact of risk and communicate to stakeholders@RISK | Risk Analysis in Excel | Lumivero (44)@RISK | Risk Analysis in Excel | Lumivero (45)
Reporting in OfficeAll graphs and charts can be exported to Excel, Word, and PowerPoint in native chart format for easy distribution to others@RISK | Risk Analysis in Excel | Lumivero (46)@RISK | Risk Analysis in Excel | Lumivero (47)
Customized Excel ReportsCreate exactly the simulation results reports you want directly in Excel, automatically formatted for optimal viewing. Apply Excel themes to your graphs.@RISK | Risk Analysis in Excel | Lumivero (48)@RISK | Risk Analysis in Excel | Lumivero (49)
Histograms, area, line, cumulative, summary, box plot, and overlay graphsVariety of graphing and charting options for easy, accurate communication@RISK | Risk Analysis in Excel | Lumivero (50)@RISK | Risk Analysis in Excel | Lumivero (51)
Tornado charts and scatter plotsVisually identify critical factors and trends, overall and for particular scenarios@RISK | Risk Analysis in Excel | Lumivero (52)@RISK | Risk Analysis in Excel | Lumivero (53)
Sensitivity and Scenario AnalysisIdentify the individual tasks that have the most impact on results, and the particular scenarios that lead to certain results@RISK | Risk Analysis in Excel | Lumivero (54)@RISK | Risk Analysis in Excel | Lumivero (55)
Six Sigma functionsReport Six Sigma statistics for quality analysis@RISK | Risk Analysis in Excel | Lumivero (56)@RISK | Risk Analysis in Excel | Lumivero (57)
Stress AnalysisLets 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@RISK | Risk Analysis in Excel | Lumivero (58)@RISK | Risk Analysis in Excel | Lumivero (59)
Advanced Sensitivity AnalysisLets you see how changes in any input—distributions or regular values—affect simulation results@RISK | Risk Analysis in Excel | Lumivero (60)@RISK | Risk Analysis in Excel | Lumivero (61)
@RISK Goal SeekUses multiple simulations to find an input value that achieves a target simulation result you specify@RISK | Risk Analysis in Excel | Lumivero (62)@RISK | Risk Analysis in Excel | Lumivero (63)
@RISK Tornado Graphs and Sensitivity Analysis

Gaining Insights into your Models

FeatureBenefitProfessional EditionIndustrial Edition
Simulation of Time-series forecastsUnderstand the risks in values that change over time@RISK | Risk Analysis in Excel | Lumivero (64)@RISK | Risk Analysis in Excel | Lumivero (65)
Correlation of Time SeriesIt 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.@RISK | Risk Analysis in Excel | Lumivero (66)@RISK | Risk Analysis in Excel | Lumivero (67)
Multi-core processor and multiple CPU supportSpeed up simulations. “Split up” large simulations to run on multiple CPUs or cores and reduce simulation run time.@RISK | Risk Analysis in Excel | Lumivero (68)@RISK | Risk Analysis in Excel | Lumivero (69)
RISKOptimizerSolve problems with more accuracy than ever.@RISK | Risk Analysis in Excel | Lumivero (70)@RISK | Risk Analysis in Excel | Lumivero (71)
FeatureBenefitProfessional EditionIndustrial Edition
Optimization under uncertaintyCombines Monte Carlo simulation with sophisticated optimization techniques to find optimal solutions to uncertain problems. Used for budgeting, allocation, scheduling, and more.@RISK | Risk Analysis in Excel | Lumivero (72)@RISK | Risk Analysis in Excel | Lumivero (73)
Efficient Frontier AnalysisEspecially useful in financial analysis, Efficient Frontiers determine the optimal return that can be expected from a portfolio at a given level of risk@RISK | Risk Analysis in Excel | Lumivero (74)@RISK | Risk Analysis in Excel | Lumivero (75)
Ranges for adjustable cells and constraintsStreamlined model setup and editing@RISK | Risk Analysis in Excel | Lumivero (76)@RISK | Risk Analysis in Excel | Lumivero (77)
Genetic algorithmsFind the best global solution while avoiding getting caught in local, “hill-climbing” solutions@RISK | Risk Analysis in Excel | Lumivero (78)@RISK | Risk Analysis in Excel | Lumivero (79)
Six solving methods, including GAs and OptQuestAlways have the best method for different types of problems@RISK | Risk Analysis in Excel | Lumivero (80)@RISK | Risk Analysis in Excel | Lumivero (81)
RISKOptimizer Watcher and Convergence MonitoringMonitor progress toward best solutions in real time@RISK | Risk Analysis in Excel | Lumivero (82)@RISK | Risk Analysis in Excel | Lumivero (83)
Overlay of Optimized vs Original DistributionCompare original output to optimized result to visually see improvements@RISK | Risk Analysis in Excel | Lumivero (84)@RISK | Risk Analysis in Excel | Lumivero (85)
Original, Best, Last model updatingInstantly see the effects of three solutions on your entire model@RISK | Risk Analysis in Excel | Lumivero (86)@RISK | Risk Analysis in Excel | Lumivero (87)
Rocking Optimization with RISKOptimizer

Decision Making Under Uncertainty

More on RISKOptimizer

@RISK | Risk Analysis in Excel | Lumivero (88)

Join Decision-Makers Around the World Who Rely on @RISK

Our best-in-class solutions portfolio and proven support methodology are delivered by a dedicated and experienced team of experts who will support you throughout the partnership.

Request a demo

@RISK | Risk Analysis in Excel | Lumivero (2024)
Top Articles
Latest Posts
Article information

Author: Trent Wehner

Last Updated:

Views: 5727

Rating: 4.6 / 5 (76 voted)

Reviews: 91% of readers found this page helpful

Author information

Name: Trent Wehner

Birthday: 1993-03-14

Address: 872 Kevin Squares, New Codyville, AK 01785-0416

Phone: +18698800304764

Job: Senior Farming Developer

Hobby: Paintball, Calligraphy, Hunting, Flying disc, Lapidary, Rafting, Inline skating

Introduction: My name is Trent Wehner, I am a talented, brainy, zealous, light, funny, gleaming, attractive person who loves writing and wants to share my knowledge and understanding with you.