RiskDoubleTriang

Description

 

RiskDoubleTriang(min,m.likely,max,p) specifies a double triangular distribution with minimum, most likely, and maximum values, along with the probability p of a value falling between min and m.likely. The double triangular distribution allows additional probability information to be specified as compared with the standard triangular distribution RiskTriang. Essentially, this distribution “splices” two triangular distributions, one from min to m.likely, the other from m.likely to max, and the parameter p is used to guarantee that the two parts of the distribution are normalized so that the total area under the density curve is 1.

 

Examples

 

RiskDoubleTriang(1,2,3,0.1) returns a double triangular distribution with a minimum possible value of 1, a most likely of 2, and a maximum of 3. The probability of a value in the range 1 to 2 is 0.1 or 10%.

RiskDoubleTriang(A10,B10,500,0.4) returns a triangular distribution with a minimum value taken from cell A10, a most likely value taken from cell B10 and a maximum value of 500. The probability of a value in the range with a minimum from cell A10 and a maximum from cell B10 is 0.4.

 

Guidelines

None.

Parameters

min            continuous boundary parameter      
                       min < max *

m.likely     continuous mode parameter      
                       min < m.likely < max

max            continuous boundary parameter

p                 probability of lower section      0 < p < 1

 

*min = max is supported but gives a degenerate distribution.

 

Domain

     continuous

 

Mass and Cumulative Distribution Functions

     

     

     

     

 

Mean

 

Variance

Complicated

Skewness

Complicated

 

Kurtosis

Complicated

 

Mode

m.likely

Examples