Signature (Visual Basic / VBA)
Public Function BetaCDFExcel( _
ByVal vX As Variant _
, ByVal vAlpha As Variant _
, ByVal vBeta As Variant _
, Optional ByVal vLower As Variant = 0 _
, Optional ByVal vUpper As Variant = 1 _
) As Variant
Code Example
BetaCDFExcel(1.0, 8, 10, 1, 3) = 0
BetaCDFExcel(1.5, 8, 10, 1, 3) = 4.02367801871164E-02
BetaCDFExcel(2.0, 8, 10, 1, 3) = 0.685470581054688
BetaCDFExcel(2.5, 8, 10, 1, 3) = 0.996899220859632
BetaCDFExcel(3.0, 8, 10, 1, 3) = 1
Parameters
| Parameter | Description |
|---|---|
| vX | Function returns Null if vX is less than vLower or greater than vUpper. |
| 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. |