Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
triangular distribution
Thank you for your help.
"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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
draw random from normal distribution | Excel Discussion (Misc queries) | |||
normal distribution curve | Charts and Charting in Excel | |||
autosend for excel worksheets for distribution list option | Excel Worksheet Functions | |||
Binodal distribution | Excel Discussion (Misc queries) | |||
how do i draw a distribution chart in excel | Charts and Charting in Excel |