The PROB function in Excel 2010


The following tutorial will describe to you the usage and syntax of the PROB function that is present in Microsoft Excel 2010 Application.


Description

The PROB function returns the probability that a particular value in a given range is between two limits, the lower limit and the upper limit.


Syntax

The PROB function has the following syntax and arguments

=PROB(y_range, prob_range, [lower_limit], [upper_limit])

Where

‘y-range’ is a required argument and it is the range of numeric values of y with which there are associated probabilities.

‘prob_range’ is also a required argument and it is the range of probability values that are associated with the y-range values.

‘lower_limit’ is an optional argument and it is considered as the lower bound on the value for which you wish to find the probability.

‘upper_limit’ is also an optional argument and it is considered as the upper bound on the value for which you wish to find the probability.


Constraints

If any of the values in the prob_range is less than or equal to `1’ or greater than ‘1’, the function returns the #NUM! error value.

If the summation of values in the prob_range is not equal to ‘1’, the function returns the #NUM! error value.

If y_range and prob_range contains unequal number of values, the function returns the #N/A error value.

If upper_limit is ignored, the function returns the probability as being equal to the probability of the lower_limit.


Example

Refer the figure below for examples on PROB function


Figure


So, this is how you can find the probability of a particular value between two limits in the given range of values.



Read Other Applications