Triangular Distribution

[ananthr]

Excel provides formulas for quite a few statistical distributions, but not the Triangular distribution. I was wondering whether anyone knows where VBA code can be found for this. In particular, I am looking for the equivalent of a module which provides the inverse of this distribution, given the cumulative probability and the shape parameters. I would be grateful for any assistance on this.

 

[goldfish]

It seems to me like this can be done without using any VBA code...

If I understand the traigular distribution correctly (just learned what it was a minute ago)

=if(D1>(C1-A1)/(B1-A1),SQRT(D1*(B1-A1)*(C1-A1))+A1,B1-SQRT((1-D1)*(B1-A1)*(B1-C1)))

Where A1, B1, and C1 are you a, b, and c parameters, and D1 is your cumulative distribution...

hope this helps (I hope this works for that matter...)