RiskTrigen

Description

RiskTrigen(bottom value,m.likely value,top value, bottom perc., top perc.) specifies a triangular distribution with three points: one at the most likely value and two at the specified bottom and top percentiles. The parameters bottom perc. and top perc. are values between 0 and 100. They represent the cumulative probabilities for the values top value and bottom value.  This is sometimes useful because it allows values below bottom value or above top value to be possible values for the distribution, that is, these two parameters don’t specify the “absolute” lowest and highest values for the distribution. Note that RiskTrigen is actually a shortcut for a special form of RiskTriangAlt.

For example:

RiskTrigen(0,1,2,10,90)

Is the same as

RiskTriangAlt(10%,0,“m. likely”,1,90%,2)

Examples

RiskTrigen(100,200,300,10,90) returns a triangular distribution with 10th percentile 100, most likely value 200, and 90th percentile 300.

RiskTrigen(A10/90,B10,500,30,70) returns a triangular distribution with 30th percentile equal to the value in cell A10 divided by 90, most likely value taken from cell B10, and 70th percentile 500.

Guidelines

bottom value must be less than or equal to m.likely value.

m.likely value must be less than or equal to top value.

bottom perc. must be less than top perc.