WorksheetFunction.Prob (Excel)

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.

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.

Prob (Arg1, Arg2, ..., Arg4)


Dim dblArg3 As Double: dblArg3 = 
Dim dblProb As Double
dblProb = WorksheetFunction.Prob(Arg1:=, Arg2:=, Arg3:=dblArg3)

Arguments

Arg1, Arg2, ..., Arg4

Arg1 - X_range - the range of numeric values of x with which there are associated probabilities

Arg2 - 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 - Upper_limit - the optional upper bound on the value for which you want a probability