decision tree

decision tree - TreePlan Documentation Note: This document...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
TreePlan Documentation Note: This document assumes you are using older version of Excel. If you are using the 2007 version, Treeplan is located under Add-Ins tab. TreePlan is an Excel add-in that allows you to build decision trees in Excel. It was developed by Professor Michael R. Middleton at the University of San Francisco and modified for use at Fuqua (Duke) by Professor Jim Smith. After opening TreePlan in Excel, the command "Decision Tree. .." appears at the bottom of the Tools menu. (If you're running Excel 4.0, the command appears under the Options menu.) Building Decision Trees in TreePlan You can start a new tree in TreePlan either by hitting Ctrl-t or by selecting Tools, Decision Tree from the menu bar. TreePlan then prompts you with a dialog box with three options; choose New to begin a new tree. TreePlan will then draw a default initial decision tree with its upper left corner at the selected cell. For example, the figure below shows the initial tree when $B$2 is selected. (Note that TreePlan writes over existing values in the spreadsheet: begin your tree to the right of the area where your data is stored, and do not subsequently add or delete rows or columns in the tree-diagram area .) 1 2 3 4 5 6 7 8 9 10 A B C D E F G H Decision 1 0 0 0 1 0 Decision 2 0 0 0 Build up a tree by adding or modifying branches or nodes in the default tree. To change the branch labels or probabilities, click on the cell containing the label or probability and type the new label or probability. To modify the structure of the tree (e.g., add or delete branches or nodes in the tree), select the node or branch in the tree to modify and select Tools, Decision Tree or hit Ctrl-t . TreePlan will then present a dialog box showing the available commands. For example to add an event node to the top branch of the tree shown above, select the terminal node at the end of that branch ($G$5) and hit Ctrl-t . To select a terminal node in Excel 97, select the square cell next to the vertical line at the end of a terminal branch. TreePlan then presents this dialog box.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Building Decision Trees in TreePlan To add an event node to the branch, we change the selected terminal node to an event node by selecting Change to event node
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/18/2009 for the course BUAD 311 at USC.

Page1 / 5

decision tree - TreePlan Documentation Note: This document...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online