If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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? 
Ads 
#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? 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
draw random from normal distribution  gatosonreyendo  Excel Discussion (Misc queries)  3  December 12th 05 05:04 AM 
normal distribution curve  Chris Treanor  Charts and Charting in Excel  1  September 29th 05 03:33 AM 
autosend for excel worksheets for distribution list option  Nicole  Excel Worksheet Functions  0  August 26th 05 05:37 PM 
Binodal distribution  Ian  Excel Discussion (Misc queries)  0  July 21st 05 08:45 PM 
how do i draw a distribution chart in excel  travish19  Charts and Charting in Excel  3  January 15th 05 02:18 AM 