Edit

Share via


WorksheetFunction.Prob(Object, Object, Double, Object) Method

Definition

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 Double

Parameters

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.

Applies to