BETADIST (PQL - xl)

This function calculates 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 plug-in: both as part of the objective function and constraint functions

Syntax

BETADIST(x, alpha, beta, OPTIONAL a, OPTIONAL b)

Function Arguments

Name

Description

Type

Optional

x

Value at which to evaluate the function, between the values of lower and upper

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 'BETADIST' function - using the same inputs, logic and outputs.