Functions
BETA.INV
Beta inverse CDF
Try it
When to use it
When should I use BETA.INV?
Use BETA.INV to find the value at which the beta CDF equals a given probability, which is the inverse operation of BETA.DIST and useful for computing credible intervals.
Used in
Syntax
BETA.INV(p,alpha,beta,lo,hi)Examples
=BETA.INV(0.13,5,1,-1,1) // => 0.32989902041949914
=BETA.INV(0.65,1.234,7,1,3) // => 1.3408840515601412
=BETA.INV(0.3,5,1) // => 0.7860030855966222