BETAINV
Formulas / BETAINVCalculate 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
Examples
=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.
Summary
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.
Frequently Asked Questions
What is the BETAINV function?
What are the new function names for the BETAINV function?
What errors does the BETAINV function throw?
What happens when A and B are omitted?
