Buzz
Introduction to the BETA.INV function – one of the commonly used statistical functions in Excel
Description: The function returns the inverse value of the cumulative distribution function for a specified beta distribution. Supported since Excel 2010
Syntax: BETA.INV(probability,alpha,beta,[A],[B])
Where:
- probability: Probability associated with the beta distribution, is a mandatory parameter.
- alpha: Distribution parameter, is a mandatory parameter.
- beta: Distribution parameter, is a mandatory parameter.
- A: Lower bound of the x interval, is an optional parameter.
- B:
Note:
- If any parameter is not a number -> the function returns an error value #VALUE!
- If alpha ≤ 0 or beta ≤ 0 -> the function returns an error value #NUM!
- If probability ≤ 0 or probability > 1 -> the function returns an error value #NUM!
- If parameters A and B are omitted, the function uses the cumulative distribution to normalize, meaning A = 0 and B =1.
Example:
Calculate the inverse value of the cumulative beta distribution function with the data in the table below:
- In the cell where you want to calculate, enter the formula: =BETA.INV(C6,C7,C8,C9,C10)
- Press Enter -> the inverse value of the cumulative beta distribution function is:
- If the probability associated with the beta distribution is greater than 1 or less than 0 -> the function returns an error value #NUM!
- If the parameters or variables are less than 0 -> the function returns an error value #NUM!
Above is a specific guide and example on using the BETA.INV function in Excel.
