BETAINV(probability,alpha,beta,[A],[B])
=BETAINV(A2,A3,A4,A5,A6)
For example, let’s say you are trying to find the inverse of the cumulative beta probability density function with parameters of A2 = 0.1, A3 = 0.2, A4 = 2, A5 = 0.5, A6 = 0.6. You can use the BETAINV function to do this. The BETAINV function will return the inverse of the cumulative beta probability density function for the parameters above.
=BETAINV(A2,A3,A4,A5,A6)
Let’s say you have the parameters A2 = 0.2, A3 = 0.3, A4 = 3, A5 = 0.7, A6 = 0.8 and you want to find the inverse of the cumulative beta probability density function with those parameters. You can use the BETAINV function in Sourcetable to accomplish this. The syntax for the BETAINV function is: .
=BETAINV(A2,A3,A4,A5,A6)
Suppose you have the parameters A2 = 0.3, A3 = 0.4, A4 = 4, A5 = 0.9, and A6 = 1.0. The BETAINV function in Sourcetable can help you find the inverse of the cumulative beta probability density function for these parameters.
The BETAINV function computes the inverse of the cumulative beta probability density function, which models project completion times from an expected completion time and variability.