Calculate the inverse of the cumulative beta probability density function.

`BETAINV(probability,alpha,beta,[A],[B])`

- x - required, the value to calculate the inverse of the beta function for
- degrees of freedom - required, the number of independent variables in the dataset

`=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.

- The BETAINV function computes the inverse of the cumulative beta probability density function and returns a #VALUE! error if any argument is not numeric.
- The beta distribution can be used in project planning for modeling probable completion times and is modeled with an expected completion time and variability.
- The BETAINV function uses the standard cumulative beta distribution if A = 0 and B = 1 if A and B are omitted.
- The BETADIST function determines the precision of BETAINV.

The BETAINV function computes the inverse of the cumulative beta probability density function. It is used for project planning and uses an expected completion time and variability to model probable completion times.

The new function names for the BETAINV function are BETA.INV.

The BETAINV function throws a #VALUE! error if any argument is not a number, and a #VALUE! error if alpha or beta is less than or equal to zero.

When A and B are omitted, BETAINV assumes that A=0 and B=1.

Drop CSV