Remember Me?

#1
December 17th 05, 09:20 PM posted to microsoft.public.excel.misc
 TD Posts: n/a
triangular distribution

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?

#2
December 17th 05, 10:40 PM posted to microsoft.public.excel.misc
 B. R.Ramachandran Posts: n/a
triangular distribution

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

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

Regards,
B. R. Ramachandran

"TD" wrote:

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?

#3
December 18th 05, 12:50 AM posted to microsoft.public.excel.misc
 B. R.Ramachandran Posts: n/a
triangular distribution

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(A3<\$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(A3<\$A\$1,0,IF(A3<\$B\$1,(A3-\$A\$1)^2/((\$C\$1-\$A\$1)*(\$B\$1-\$A\$1)),
IF(A3<=\$C\$1,1-(\$C\$1-A3)^2/((\$C\$1-\$B\$1)*(\$C\$1-\$A\$1)),1)))

Regards,
B. R. Ramachandran

"TD" wrote:

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?

#4
December 24th 05, 01:30 AM posted to microsoft.public.excel.misc
 TD Posts: n/a
triangular distribution

"B. R.Ramachandran" wrote:

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(A3<\$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(A3<\$A\$1,0,IF(A3<\$B\$1,(A3-\$A\$1)^2/((\$C\$1-\$A\$1)*(\$B\$1-\$A\$1)),
IF(A3<=\$C\$1,1-(\$C\$1-A3)^2/((\$C\$1-\$B\$1)*(\$C\$1-\$A\$1)),1)))

Regards,
B. R. Ramachandran

"TD" wrote:

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post gatosonreyendo Excel Discussion (Misc queries) 3 December 12th 05 05:04 AM Chris Treanor Charts and Charting in Excel 1 September 29th 05 03:33 AM Nicole Excel Worksheet Functions 0 August 26th 05 05:37 PM Ian Excel Discussion (Misc queries) 0 July 21st 05 08:45 PM travish19 Charts and Charting in Excel 3 January 15th 05 02:18 AM

All times are GMT +1. The time now is 07:32 PM.