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

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

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 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

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.

Applies to