Home 
Search 
Today's Posts 
#1




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




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.techarchive.net/Archive/...408/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




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$1A3)/(($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$1A3)^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




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$1A3)/(($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$1A3)^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 