WorksheetFunction.Prob Method
Returns the probability that values in a range are between two limits. If upper_limit is not supplied, returns the probability that values in x_range are equal to lower_limit.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Prob ( _
Arg1 As Object, _
Arg2 As Object, _
Arg3 As Double, _
Arg4 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Object
Dim Arg3 As Double
Dim Arg4 As Object
Dim returnValue As Double
returnValue = instance.Prob(Arg1, Arg2, _
Arg3, Arg4)
double Prob(
Object Arg1,
Object Arg2,
double Arg3,
Object Arg4
)
Parameters
Arg1
Type: System.ObjectX_range - the range of numeric values of x with which there are associated probabilities.
Arg2
Type: System.ObjectProb_range - a set of probabilities associated with values in x_range.
Arg3
Type: System.DoubleLower_limit - the lower bound on the value for which you want a probability.
Arg4
Type: System.ObjectUpper_limit - the optional upper bound on the value for which you want a probability.
Return Value
Type: System.Double
Remarks
If any value in prob_range ≤ 0 or if any value in prob_range > 1, Prob returns the #NUM! error value.
If the sum of the values in prob_range ¹ 1, Prob returns the #NUM! error value.
If upper_limit is omitted, Prob returns the probability of being equal to lower_limit.
If x_range and prob_range contain a different number of data points, Prob returns the #N/A error value.