Function Math Probability Class

BetaInverseExcel

Inverse Beta Cumulative Distribution Function (uses BetaCDFExcel )

Signature (Visual Basic / VBA)

Public Function BetaInverseExcel( _
      ByVal vProbability As Variant _
    , ByVal vAlpha As Variant _
    , ByVal vBeta As Variant _
    , Optional ByVal vLower As Variant = 0 _
    , Optional ByVal vUpper As Variant = 1 _
    ) As Variant

Parameters

Parameter Description
vProbability Function returns Null if vProbability is not between 0 and 1 inclusive.
vAlpha Function returns Null if vAlpha is less than or equal to zero (<=0).
vBeta Function returns Null if vBeta is less than or equal to zero (<=0).
vLower Function returns Null if vLower is greater than or equal to vUpper.
vUpper Function returns Null if vUpper is less than or equal to vLower.