Thoughts on the World

Combining Risk Factors

In "Waltzing with Bears" Tom DeMarco and Tim Lister introduce the very useful concept of the "Uncertainty Diagram", the probability distribution for project metrics such as delivery date, expenditure or benefit delivery. This is used, for example, to assess the likelihood of delay from a given risk.

However, when it comes to evaluating the net effect of several risk factors they rely entirely on Monte-Carlo simulation, claiming that the mathematics for an analytical solution are too complicated. While this might be true for complex curves, it isn't true where the curve is defined by, or can be approximated by, a few discrete points, which will be a common case in practice. Here's my attempt to show how this can be explained, and how a relatively simple analytical solution can then be used in place of simulation.

Consider the following two uncertainty diagrams, which show how two separate risk factors, Factor 1 and Factor 2, will affect a project's completion date relative to the earliest possible completion date.

(For simplicity we refer to delivery after the earliest possible date as a "delay", although a good project manager will actually agree a realistic target later than the earliest possible date.)

We want to combine these two profiles into a single probability function (which can then be expressed as an uncertainty diagram).

Consider the first value in each distribution, the probability of delivery up to one month after the earliest possible date. If Factor 1 affects the project so that there is up to one month's delay AND Factor 2 affects the project so that there is up to one month's delay then delivery will be delayed up to 2 months. This is the smallest net delivery delay we can assess. Note the use of the word "AND". This means we simply multiply the probabilities for those two cases, giving a net probability of 0.01.

Delivery delayed between two and three months means that either Factor 1 produces one month's delay AND Factor 2 produces two month's delay OR Factor 1 produces two month's delay AND Factor 2 produces one month's delay. Again, we multiply appropriate pairs of individual probabilities, then add the results together (where we use the word "OR").

The following spreadsheet shows the formulae for all the possible outcomes:

The right-most column is our net probability function, which can then be plotted as an uncertainty diagram:

In summary, as long as the two factors are independent (which is also the underlying assumption for the simulation approach) you can combine them using simple probability rules. To produce a single net uncertainty diagram they need to be in the same units, but you could produce a list, for example, showing probabilities like "the probability of two month's delay and $10,000 budget overrun".

I haven't found a way of doing this using simple Excel functions, but it would be very straightforward to write a small VBA routine to dynamically build the formulas given the input columns. I may have a go at this in a future version of this paper.

Click here to download the example spreadsheet.

Comments

2 Responses to Combining Risk Factors

John Burgess on 22 June 2010 at 9:23 pm

There is an underlying assumption to what you are doing that the risks impact in series rather than parallel. While this is clearly the safest (i.e. most conservative) assumption to make, I feel it does need to be made explicit.

It is certainly possible to imagine situations in which risks impact in parallel – the opening of the channel tunnel rail link could have suffered from both from problems with the earth under the channel and difficulties getting planning permission for the rail lines to the tunnel. However, these should probably have impacted in parallel and so the combined impact would be simply the greater of the two rather than the sum.


Andrew on 22 June 2010 at 9:28 pm

I agree that there are a number of possible ways to combine the risks. My point is that it is possible to use analytical rather than simulation-based techniques, and I think John’s analysis supports that.


If you'd like to comment on this article, with ideas, examples, or just to praise it to the skies then I'd love to hear from you.

Comment on this article

Please share: All Addthis servicesTweet thisFacebook thisLink thisYam thisShare on Google

© Questa Computing Ltd. 2003
Page last updated 14 May, 2015 13:43

Questa Computing Ltd. is registered in England and Wales number:2889117.
Registered office: Ember House, 35-37 Creek Road, East Molesey, KT8 9BE UK
For credits, copyright details and cookie policy, see here.

Search my Sites:

Share this page:

Share |

Indexes

Favourite/Major Articles
All Articles by Category
All Articles by Title
Review Index

Site Map:

Welcome / Home Page
Contact Me
Search the Site
Thoughts on the World
Consultancy Services
An introduction
Key Skills
Career Summary
Case Studies
IT Knowledge/Education
Customer Profiles
Training Courses
Previous Experience
Download Full CV
Customers
National Grid Group Plc
British Energy Power and Energy Trading
Legal Marketing Services Ltd.
Addison-Wesley
Marks and Spencer Plc
Faith Footwear Ltd.
Barclays Sales Financing Ltd.
Oracle Corporation UK Ltd.
Livingston Rental Group Ltd.
National Power Plc.
Blog
Agile Development
Coding Projects & Thoughts
General Thoughts
Humour
Personal
Photography
Products and Projects
Publications
Reviews: Books, Music & Films
Website Announcements
Full Index
Publications and Papers
A Hacker's Guide to Project Management
Conference Papers
Agile Architecture
Practical Enterprise Integration
Modelling an Enterprise Data Architecture
Strategies for Flexibility
Getting Sizing Right
Muzzling the Alligators
Evolution of a Test Method
Photography
Photography Articles & Discussion
Photo Gallery
Projects and Products
RelQuest - Reliability Modelling Tool
ConQuest - Container Yard Management System
Reviews
Full Index
Architecture
Biography and Personal Endeavour
Construction & Civil Engineering
Cryptography
Fiction
Human-Computer Interaction
Mathematics & Statistics
Military & 20th Century History
Modelling & Analysis
Photography & Photographers
Physics & Cosmology
Project & People Management
Psychology & Human Behaviour
Science, General
Links

Contact Me

Email me
@TweetAndrewJ
Others

Feeds and Tweets

Follow me on Twitter

@TweetAndrewJ

Thoughts on the World
(main feed)

Feedburner XML
RSS Version XML (direct)

How many subscribers?

Other Feeds

Professional Blog
Photo Blog
Photo Album
Review Pages

About my feeds

Google Blog Search

References to www.andrewj.com
References to www.agilearchitect.org

Sister Sites:

www.agilearchitect.org