RiskTriang
|
Description |
RiskTriang(minimum,m.likely,maximum) specifies a triangular distribution defined by a minimum, a most likely value, and a maximum. It can be skewed in either direction, depending on the position of m.likely relative to minimum and maximum. This distribution is perhaps the most readily understandable distribution for basic risk models. Its possible drawback for real applications is that it allows no possible values outside the min-max range.
|
|
Examples |
RiskTriang(100,200,300) returns a triangular distribution with minimum value 100, most likely value 200 and maximum value 300. RiskTriang(A10/90,B10,500) specifies a triangular distribution with minimum value equal to the value in cell A10 divided by 90, most likely value taken from cell B10, and maximum value 500.
|
|
Guidelines |
minimum must be less than or equal to m.likely. m.likely must be less than or equal to maximum. minimum must be less than maximum. |
|
Parameters |
min continuous boundary parameter min < max * m.likely continuous mode parameter min ≤ m.likely ≤ max max continuous boundary parameter * min = max is supported but gives a degenerate distribution. |
|
Domain |
min ≤ x ≤ max continuous |
|
Density and Cumulative Distribution Functions |
|
|
Mean |
|
|
Variance |
|
|
Skewness |
|
|
Kurtosis |
2.4
|
|
Mode |
m.likely
|
|
Examples |
|
where 
