BETAINV (PQL  xl)
This function calculates the inverse of the cumulative beta distribution function
 Library: PQL \ Spreadsheet \ Compatibility
 Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
 Solve: This function can be used with the Solve plugin: both as part of the objective function and constraint functions
Syntax
BETAINV(probability, alpha, beta, OPTIONAL a, OPTIONAL b)
Function Arguments
Name  Description  Type  Optional 
probability  Probability of the distribution  Number 

alpha  Alpha parameter of the distribution  Number 

beta  Beta parameter of the distribution  Number 

a  Lower bound of the interval for x; 0 if omitted  Number  Y 
b  Upper bound of the interval for x; 1 if omitted  Number  Y 
Comments
This function is the same as the Microsoft Excel 'BETAINV' function  using the same inputs, logic and outputs.