How To Create Decision Tree In Excel

PrecisionTree

Decision Trees in Microsoft Excel

Visual Decision Analysis in Your Spreadsheet

PrecisionTree's graphical representations were quite valuable in communicating our modeling efforts to others.
Program Manager, Bucknell University

What we needed was a set of practical, comprehensive, broadly applicable tools... I think we have that now, and PrecisionTree is really key components in that set of tools.

Dr. Douglas Armstrong
Actuarial Analyst, World Conservation Union

Its attraction is its capacity to value complex decisions, which often involve multiple, sequential decision steps

Bob Hunt
Associate Director for Investment Analysis, Procter & Gamble

Select the Best Option with Confidence Using PrecisionTree

The PrecisionTree Microsoft Excel add-in 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.

See What's New in Version 8

Overview

With the PrecisionTree Excel add-in, you can analyze and see the payoff and probability of each possible path through a decision tree. PrecisionTree 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 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 Models
Visually Map out Decisions
See All Possible Paths and Chance Events
Choose the Best Option with Confidence
Communicate Decision Paths to Others

How PrecisionTree Is Used

PrecisionTree has a multitude of applications, including:

Resource Management
Portfolio Selection
Real Options Analysis
Exploration and Production
Sensitivity Analysis
Decision Modeling
Sequential Decisions
Quantitative Diagrams
Bayesian Revision
Cumulative Risk Profile Graphs
2-way Sensitivity Graph
Policy Suggestion Reports
Strategy Region Graphs

Customer Success Stories

Learn how PrecisionTree has helped analysts and executives improve decision making.

London Business School/ Novartis Pharmaceutical

View Info

Product Resources

Explore examples and tutorials on how to make PrecisionTree work best for you.

Included with The DecisionTools Suite

The DecisionTools Suite

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

Additional Benefits

Subscription

Your software subscription has you fully covered.

Free upgrades when new software versions are released
Full access to Technical Support

Support

Technical Support is available to help with installation, operational problems, or errors.

Included with subscription
Phone, web, or email

Next Steps