software

I noticed excel does not have a triangular distribution. Is there a way to
develop a triangular distribution since this is used quite a bit in
statistical analysis? I know there are commercial products available but can
I do this in the standard Excel?

Hi,

For an Excel formula for generating Probability Distribution Curve for
Triangular Distribution for a given set of minimum, maximum, and mode values,
see in

www.tech-archive.net/Archive/...4-08/3207.html

Regards,
B. R. Ramachandran

quot;TDquot; wrote:

gt; I noticed excel does not have a triangular distribution. Is there a way to
gt; develop a triangular distribution since this is used quite a bit in
gt; statistical analysis? I know there are commercial products available but can
gt; I do this in the standard Excel?

Hi,

If A1, B1, and C1 contain respectively, the minimum, mode, and maximum, of a
triangular distribution, and if A3 contains a value x, use the following
formulas:

For the Probability Density Function, P(x),

=MAX(0,IF(A3lt;$B$1,2*(A3-$A$1)/(($C$1-$A$1)*($B$1-$A$1)),2*($C$1-A3)/(($C$1-$B$1)*($C$1-$A$1))))

and for the Cumulative Distribution Function, D(x)

=IF(A3lt;$A$1,0,IF(A3lt;$B$1,(A3-$A$1)^2/(($C$1-$A$1)*($B$1-$A$1)),
IF(A3lt;=$C$1,1-($C$1-A3)^2/(($C$1-$B$1)*($C$1-$A$1)),1)))Regards,
B. R. Ramachandran

quot;TDquot; wrote:

gt; I noticed excel does not have a triangular distribution. Is there a way to
gt; develop a triangular distribution since this is used quite a bit in
gt; statistical analysis? I know there are commercial products available but can
gt; I do this in the standard Excel?

Thank you for your help.

quot;B. R.Ramachandranquot; wrote:

gt; Hi,
gt;
gt; If A1, B1, and C1 contain respectively, the minimum, mode, and maximum, of a
gt; triangular distribution, and if A3 contains a value x, use the following
gt; formulas:
gt;
gt; For the Probability Density Function, P(x),
gt;
gt; =MAX(0,IF(A3lt;$B$1,2*(A3-$A$1)/(($C$1-$A$1)*($B$1-$A$1)),2*($C$1-A3)/(($C$1-$B$1)*($C$1-$A$1))))
gt;
gt; and for the Cumulative Distribution Function, D(x)
gt;
gt; =IF(A3lt;$A$1,0,IF(A3lt;$B$1,(A3-$A$1)^2/(($C$1-$A$1)*($B$1-$A$1)),
gt; IF(A3lt;=$C$1,1-($C$1-A3)^2/(($C$1-$B$1)*($C$1-$A$1)),1)))
gt;
gt;
gt; Regards,
gt; B. R. Ramachandran
gt;
gt; quot;TDquot; wrote:
gt;
gt; gt; I noticed excel does not have a triangular distribution. Is there a way to
gt; gt; develop a triangular distribution since this is used quite a bit in
gt; gt; statistical analysis? I know there are commercial products available but can
gt; gt; I do this in the standard Excel?