Excel functions / Statistics
BETA.INV function
The value below which a given share of a beta distribution falls.
Syntax
=BETA.INV(probability, alpha, beta, [A], [B])
Arguments
probability: A probability, between 0 and 1.alpha: The first shape parameter.beta: The second shape parameter.A(optional): The lower bound. Left out, it is 0.B(optional): The upper bound. Left out, it is 1.
When to use it
BETA.INV gives the value below which a share of a beta distribution falls.
Examples
Undo BETA.DIST
A B C D E 1 p alpha beta 2 0.685470581 8 10 2.000 In E2:
=BETA.INV(A2, B2, C2, 1, 3)→ 2.000
Common mistakes
- Bounds. Give the same bounds as were used with BETA.DIST.
BETA.INV in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: BETA.INV
- Danish: BETA.INV
- Dutch: BETA.INV
- Finnish: BEETA.KÄÄNT
- French: BETA.INVERSE.N
- German: BETA.INV
- Hungarian: BÉTA.INVERZ
- Italian: INV.BETA.N
- Norwegian: BETA.INV
- Polish: ROZKŁ.BETA.ODWR
- Portuguese (Brazil): INV.BETA
- Russian: БЕТА.ОБР
- Spanish: INV.BETA.N
- Swedish: BETA.INV
- Turkish: BETA.TERS
Also written as BETAINV.
Try BETA.INV in the playground
Related functions
- BETA.DIST: The beta distribution, for shares and percentages that vary between two bounds.