BETAINV

Formulas / BETAINV
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

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?
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.
What are the new function names for the BETAINV function?
The new function names for the BETAINV function are BETA.INV.
What errors does the BETAINV function throw?
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.
What happens when A and B are omitted?
When A and B are omitted, BETAINV assumes that A=0 and B=1.
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV