In this video, learn how to repurpose one column in the framework to get the information you need to evaluate multiple branches efficiently.
- [Instructor] Earlier I noted that the decision tree model…we created only represented one branch; that is,…you could decide to invest in a project…and evaluate the outcomes but you had to use…multiple Excel tables to represent separate projects.…In this movie, I will show you how to repurpose…one column in the framework to give you the information…you need to evaluate multiple branches efficiently.…My sample file is DecisionTree_05,…and you can find it in the chapter four folder…of the exercise files collection.…
The Excel table that we created…captures information about the decision tree…we were working with.…I have a different tree toward the top, however.…The decision tree that we're going to be working with…is still available at the bottom,…just below the screen where I was working.…So, I will drag this other decision tree up a bit…so I can see all the probabilities.…Before I start recording this tree's information,…I need to make one change.…So I'll go to cell B1, and rather than Level,…which you probably noticed…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Finding target values using Goal Seek
- Finding a solution using Solver
- Tuning investment portfolios
- Organizing worksheets
- Creating objective and control formulas
- Experimenting with different constraints
- Optimizing resource placement
- Defining decision trees