Excel BETAINV function
The Excel BETAINV function returns the inverse of the cumulative beta probability density function for a specified beta distribution. Which means that if probability = BETADIST(x,alpha,…), the BETAINV(probability,alpha,…) returns x.
Note: This function has been replaced with BETA.INV function that may provide improved accuracy after Excel 2010 version. This function is still can be available but considering it may be not available in the future, you should better study to use the new function from now.
Syntax and arguments
The BETAINV function returns a numeric value.
#VALUE! error value appears when any argument is nonnumeric.
#NUM! error value appears when one of below situations occurs:
- Argument alpha <= 0;
- Argument beta <= 0;
- Argument x < A;
- Argument x > B;
- Argument A = B.
If the argument A and B are omitted, the BETAINV function uses the standard cumulative beta distribution, A = 0, B = 1.
Excel 2010 and earliaer versions.
Usage and Examples
Example1 basic usage
To return the inverse of cumulative beta probability density function based on the provided parameters in table C2:C6, please use the BETAINV function as below:
Or you can directly type the arguments in the formula like:
Press Enter key.
Excel BETA.DIST Function
The Excel BETA.DIST function (Excel 2013) returns the beta distribution which is usually used to study the percentage variation of something across samples.
Excel BETADIST Function
The Excel BETADIST function (Excel 2010) returns the beta distribution which is usually used to study the percentage variation of something across samples.
Excel NORM.S.DIST Function
The NORM.S.DIST calculates and returns the standard normal cumulative distribution function or probability density function of a value for an arithmetic mean of 0 and standard deviation of 1
Excel NORM.S.INV Function
The NORM.S.INV calculates and returns the inverse of the standard normal cumulative distribution that has an arithmetic mean of 0 and standard deviation of 1 with a given probability.