RiskPert

Description

 

RiskPert(minimum, m.likely, maximum) specifies a PERT distribution with specified minimum, most likely, and maximum values. The PERT distribution (meaning Program Evaluation and Review Technique) is similar to a triangular distribution in that it has the same set of easily understandable parameters, but it might be preferred to the triangular distribution because of its curved density. Technically, it is a special case of the BetaGeneral) distribution.

 

Examples

 

RiskPert(0,2,10) returns a PERT distribution with minimum 0, maximum 10, and most likely value 2.

RiskPert(A1,A2,A3) specifies a PERT distribution with its three parameters taken from the cells A1, A2, and A3.

 

Guidelines

minimum must be less than maximum.

most likely must be greater than or equal to minimum and less than or equal to maximum.

Definitions

 

Parameters

min continuous boundary parameter min < max
m.likely continuous parameter min <= m.likely <= max
max continuous boundary parameter  

Domain

min ≤ x ≤ max continuous

Density and Cumulative Distribution Functions


with

 

Here, is the Beta Function and is the Incomplete Beta Function.

Mean

 

Variance

 

Skewness

 

Kurtosis

 

Mode

m.likely

Examples