Triangular Distribution
Parameters
(most likely value) - continuous mode parameter
()
, - continuous boundary parameters
( < )
Domain
Probability Density Function
Cumulative Distribution Function
Worksheet and VBA Functions
The following worksheet
and VBA functions are available for
this distribution:
Description |
VBA Functions |
Worksheet Functions |
Distribution Fitting |
- |
=DistFit("Triangular";Data;[Options] 1)
|
Probability Density Function |
TriangularPdf(x,m,a,b) |
=TriangularPdf(m;a;b)
=DistPdf("Triangular(m;a;b)";x)
|
Cumulative Distribution Function |
TriangularCdf(x,m,a,b) |
=TriangularCdf(m;a;b)
=DistCdf("Triangular(m;a;b)";x)
|
Survival Function |
TriangularSurv(x,m,a,b) |
=DistSurv("Triangular(m;a;b)";x)
|
Hazard Function |
TriangularHaz(x,m,a,b) |
=TriangularHaz(m;a;b)
=DistHaz("Triangular(m;a;b)";x)
|
Cumulative Hazard Function |
TriangularCumHaz(x,m,a,b) |
=DistCumHaz("Triangular(m;a;b)";x)
|
Inverse CDF (Quantile Function) |
TriangularInv(P,m,a,b) |
=TriangularInv(m;a;b)
=DistInv("Triangular(m;a;b)";P)
|
Random Numbers |
TriangularRand(m,a,b) |
=TriangularRand(m;a;b)
=DistRand("Triangular(m;a;b)")
|
Mode |
TriangularMode(m,a,b) |
=DistMode("Triangular(m;a;b)")
|
Mean |
TriangularMean(m,a,b) |
=TriangularMean(m;a;b)
=DistMean("Triangular(m;a;b)")
|
Variance |
TriangularVar(m,a,b) |
=TriangularVar(m;a;b)
=DistVar("Triangular(m;a;b)")
|
Standard Deviation |
TriangularStdev(m,a,b) |
=TriangularStdev(m;a;b)
=DistStdev("Triangular(m;a;b)")
|
Skewness |
TriangularSkew(m,a,b) |
=DistSkew("Triangular(m;a;b)")
|
(Excess) Kurtosis |
TriangularKurt(m,a,b) |
=DistKurt("Triangular(m;a;b)")
|
-
The
Options parameter is optional. Possible options:
- "a=value" (example: "a=0")
- "b=value" (example: "b=10")
- "a=value1;b=value2" (example: "a=2;b=8")
|