Menu
EXCEL BETA.INV FUNCTION
Excel BETA.INV Function Introduction
For a given probability, the Excel BETA.INV function computes the inverse of the cumulative beta probability density function. Because the Beta.Inv function is new to Excel 2010, it is not available in previous versions of Excel. The function, however, is merely an upgraded version of the Betainv function, which was accessible in previous versions of Excel.
Description of Excel BETA.INV Function
Syntax :
=BETA.INV ( probability, alpha, beta, [A], [B] )
Parameters :
probability – The Beta distribution probability for which you wish to get the value of x.
alpha – A distribution parameter (must be greater than 0).
beta – A distribution parameter (must be greater than 0).
[A] – An optional number input that specifies the lower bound of the x interval. (If omitted, [A] is set to 0 by default.)
[B] – An optional number input that specifies the upper bound of the x interval (If omitted, [B] takes the default value 1).
It is worth noting that if the inputs [A] and [B] are set to 0 and 1, respectively, the Inverse Standard Cumulative Beta Distribution is defined.
Step By Step Guide of BETA.INV Function
Example :
The Cumulative Beta Distribution is depicted in the chart on the left, with the parameters alpha and beta set to 4 and 5, respectively. The x interval is set to [0, 1], resulting in the Standard Cumulative Beta Distribution.The Excel Beta.Inv function may be used to determine the value of the Inverse Cumulative Beta Distribution for any probability (for example, probability 0.2): BETA.INV ( 0.2, 4, 5, 0, 1 ) This yields the value 0.303225845. It should be noted that in the preceding example, the parameters [A] and [B] were specified as 0 and 1, respectively. However, because their default values are 0 and 1, these parameters might have been removed from the code.
Key Points
- #NUM! – Occurs if the provided probability is either 0 or 1; The given values for [A] and [B] are the same; The given alpha or beta is a value of 0.
- #VALUE! – This error occurs if any of the supplied parameters is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
