percentile calculation in Excel 2011 for a Pert Distribution

[hansdecocq]

Hello


I have the next values for a PERT distribution in Excel 2010:

optimistic € 1,20 A1

most-likely € 1,35 A2

Pessimistic € 1,90 A3


I want to calculate in excel the percentile for € 1,50 of this PERT distribution.

 

[sachiku]

Hi hansdecocq,


Assuming that you have the values in the A1, A2 & A3 cells.


You can have the percentile of these from formula [=150/MAX(A1:A3)]


Hope this helps.


Thanks.