Spread 8.0 Documentation
BETAINV
Support Options
Formula Reference > Built-In Functions > BETAINV

Glossary Item Box

BETAINV


Name

Beta distribution

Description

Calculates the inverse of the cumulative beta distribution function.

Syntax

BETAINV(prob,alpha,beta,lower,upper)

Argument Description
prob Probability of the distribution
alpha Alpha parameter of the distribution
beta Beta parameter of the distribution
lower [Optional] Lower bound of the interval for x; 0 if omitted
upper [Optional] Upper bound of the interval for x; 1 if omitted

Remarks

If you omit values for upper and lower, the calculation uses the standard cumulative beta distribution, so that lower is zero and upper is one.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

BETAINV(0.75,B3,C3,2,4)
BETAINV(0.75,R3C2,R3C3,2,4)
BETAINV(0.75,9,12,2,4)=3.0011968805

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.