WorksheetFunction.Beta_Dist Method
Returns the beta cumulative distribution function.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Beta_Dist ( _
Arg1 As Double, _
Arg2 As Double, _
Arg3 As Double, _
Arg4 As Boolean, _
Arg5 As Object, _
Arg6 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Double
Dim Arg3 As Double
Dim Arg4 As Boolean
Dim Arg5 As Object
Dim Arg6 As Object
Dim returnValue As Double
returnValue = instance.Beta_Dist(Arg1, _
Arg2, Arg3, Arg4, Arg5, Arg6)
double Beta_Dist(
double Arg1,
double Arg2,
double Arg3,
bool Arg4,
Object Arg5,
Object Arg6
)
Parameters
Arg1
Type: System.DoubleThe value between A and B at which to evaluate the function.
Arg2
Type: System.DoubleThe Alpha parameter of the distribution.
Arg3
Type: System.DoubleThe Beta parameter of the distribution.
Arg4
Type: System.BooleanCumulative - a logical value that determines the form of the function. If cumulative is true, BETA.DIST returns the cumulative distribution function; if false, it returns the probability density function.
Arg5
Type: System.ObjectAn optional lower bound to the interval of x.
Arg6
Type: System.ObjectAn optional upper bound to the interval of x.
Return Value
Type: System.Double
Remarks
The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television:
If any argument is nonnumeric, Beta_Dist returns the #VALUE! error value.
If alpha ≤ 0 or beta ≤ 0, Beta_Dist generates an error value.
If x < A, x > B, or A = B, Beta_Dist generates an error value.
If you omit values for A and B (lower and upper bound), Beta_Dist uses the standard cumulative beta distribution, so that A = 0 and B = 1.