WorksheetFunction.Prob(Object, Object, Double, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.
public double Prob (object Arg1, object Arg2, double Arg3, object Arg4);Public Function Prob (Arg1 As Object, Arg2 As Object, Arg3 As Double, Optional Arg4 As Object) As DoubleParameters
- Arg1
- Object
X_range - the range of numeric values of x with which there are associated probabilities.
- Arg2
- Object
Prob_range - a set of probabilities associated with values in x_range.
- Arg3
- Double
Lower_limit - the lower bound on the value for which you want a probability.
- Arg4
- Object
Upper_limit - the optional upper bound on the value for which you want a probability.
Returns
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.