fbpx

DECIDE WITH CONFIDENCE

Probabilistic Decision Analysis in Excel With PrecisionTree

Improve your decision analysis by using decision trees and influence diagrams to visualize different outcomes with PrecisionTree in Microsoft Excel. Decision trees let you visually map out complex decisions in a sequential, organized manner – helping you identify all possible alternatives and choose the best option.

Select the Best Option with Confidence

PrecisionTree helps address complex sequential decision models by visually mapping out, organizing, and analyzing decisions using decision trees . Decision trees are quantitative diagrams with nodes and branches representing different possible decision paths and chance events. This helps you analyze the value of all possible alternatives, so you can choose the best option with confidence.

What is PrecisionTree?

With PrecisionTree, you can analyze and see the payoff and probability of each possible path through a decision tree. PrecisionTree nodes and functions may be added to any cell in a spreadsheet and can include arguments that are cell references and expressions – allowing great flexibility in defining decision models.

PrecisionTree determines the best decision to make at each decision node and marks the branch for that decision TRUE. Once your decision tree is complete, PrecisionTree creates a full decision analysis statistics report on the best decision to make and its comparison with alternative decisions. PrecisionTree can also create a Risk Profile graph that compares the payoffs and risk of different decision options. It displays probability and cumulative charts showing the probabilities of different outcomes and of an outcome less than or equal to a certain value.
Works with Microsoft Excel
Choose the Best Option with Confidence
Plan Better Strategies
Communicate Decision Paths to Others
Visually Map out Decisions

How PrecisionTree Is Used

PrecisionTree has a multitude of applications, including:
Oil, Gas, & Mineral Reserves: Map out sequential, probabilistic exploration plans of prospective sites containing oil, natural gas, or other minerals. Estimate uncertain reserves to make wise drilling decisions.
Litigation & Bidding Strategy: Plan step-by-step strategies in complex legal or business negotiations, or when bidding on contracts. Map what could happen at each stage and your response to, along with probabilistic chance events.
Real Options Valution: Quantify the value of real options, or the right to undertake an investment or not, in the face of uncertainty future outcomes.
Supply Chain Management: Develop multi-stage plans for complex supply chains, incorporating probabilities of failures and other chance events.
Medical Treatment Planning: Establish sequential, multi-stage treatment plans for complex medical conditions given uncertain outcomes at each stage.

Key Features

Visual, Probabilistic Decision Trees

PrecisionTree allows you to visually understand a decision, identify best options, and communicate results to others. You’ll see the payoff and probability of each possible path through a decision tree in Microsoft Excel.

100% Microsoft Excel Integration

With PrecisionTree, you never leave your spreadsheet, allowing you to work in a familiar environment, and get up to speed quickly.

Full Statistics Reports and Graphs

See results in risk profile graphs, 2-way sensitivity, tornado graphs, spider graphs, policy suggestion reports, and strategy-region graphs.

Bayesian Revision

“Flip” one or more chance nodes to show probabilities calculated using Bayes’ Rule. This is valuable when the probabilities of a model are not available in a directly useful form. For example: You need to know the probability of an outcome occurring given the results of a particular test. The test’s accuracy may be known, but the only way to determine the probability you seek is to “reverse” a traditional decision tree in Microsoft Excel using Bayes Rule.

Advanced Features

Set up your decision tree in Microsoft Excel exactly as you need it with logic nodes, reference nodes, linked trees, custom utility functions, and influence diagrams.
FeatureBenefitProfessionalIndustrial
Decision TreesVisually understand a decision, identify best options, and communicate results to others
Seamless Integration into Microsoft ExcelNever leave your spreadsheet; get up to speed quickly
Intuitive Toolbars and Right-click MenusEasy navigation—multiple ways to perform common tasks
Risk Profile ReportsShows payoffs and risks of different options
Sensitivity AnalysisIdentifies most influential variables in a decision
Policy Suggestion ReportShows optimal decisions and payoffs
Strategy Region GraphsDisplays value of decisions over ranges of 1 or 2 variables
Bayesian RevisionReverses chance nodes to show probabilities calculated using Bayes Rule
Reference nodes and collapsible branchesStreamline large trees for easy navigation
Logic NodesAllows conditional modeling
Linked Trees and VBA Payoff CalculationsAllows complex payoff computations outside of the tree itself
Utility FunctionsAccount for decision maker’s attitude toward risk when calculating the best decision
PrecisionTree Developer KitAutomate and customize PrecisionTree with Excel VBA
Compatibility with @RISKAccount for uncertainty and run Monte Carlo simulations to see all possible outcomes
Influence DiagramsVisually summarize a decision
Append Symmetric SubtreeQuickly build large trees, saving a lot of time.
Insert NodeEasily put a new node inbetween existing nodes in fewer steps.
Copy Tree Image to ClipboardCopy and paste any part of a decision tree into Word, PowerPoint, or any application for reports and presentations.
Number of Tree NodesProfessional allows up to 1000 nodes per tree; Industrial is unlimited.
FeatureBenefitProfessionalIndustrial
Decision TreesVisually understand a decision, identify best options, and communicate results to others
Seamless Integration into Microsoft ExcelNever leave your spreadsheet; get up to speed quickly
Intuitive Toolbars and Right-click MenusEasy navigation—multiple ways to perform common tasks
Risk Profile ReportsShows payoffs and risks of different options
Sensitivity AnalysisIdentifies most influential variables in a decision
Policy Suggestion ReportShows optimal decisions and payoffs
Strategy Region GraphsDisplays value of decisions over ranges of 1 or 2 variables
Bayesian RevisionReverses chance nodes to show probabilities calculated using Bayes Rule
Reference nodes and collapsible branchesStreamline large trees for easy navigation
Logic NodesAllows conditional modeling
Linked Trees and VBA Payoff CalculationsAllows complex payoff computations outside of the tree itself
Utility FunctionsAccount for decision maker’s attitude toward risk when calculating the best decision
PrecisionTree Developer KitAutomate and customize PrecisionTree with Excel VBA
Compatibility with @RISKAccount for uncertainty and run Monte Carlo simulations to see all possible outcomes
Influence DiagramsVisually summarize a decision
Append Symmetric SubtreeQuickly build large trees, saving a lot of time.
Insert NodeEasily put a new node inbetween existing nodes in fewer steps.
Copy Tree Image to ClipboardCopy and paste any part of a decision tree into Word, PowerPoint, or any application for reports and presentations.
Number of Tree NodesProfessional allows up to 1000 nodes per tree; Industrial is unlimited.

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

Included with The DecisionTools Suite

The complete risk and decision analysis toolkit, including @RISK, PrecisionTree, TopRank, NeuralTools, StatTools, Evolver, RISKOptimizer, and ScheduleRiskAnalysis.

magnifierarrow-right
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram