BETA.INV function

BETA.INV(probability, alpha, beta, a?, b?) BETA.INV(probability; alpha; beta; a?; b?)

probability

Number or { Number }

The probability associated with the distribution.

alpha

Number or { Number }

A parameter to the distribution.

beta

Number or { Number }

A parameter to the distribution.

a

Number or { Number } (optional)

A lower bound for the probability parameter.

b

Number or { Number } (optional)

An upper bound for the probability parameter.

Returns

Number or { Number }

The inverse of the BETA.DIST function.

Returns the inverse of the BETA.DIST function.

Example

BETAINV(0.96, 3, 4)BETAINV(0,96; 3; 4)

Returns roughly 0.75.