This is a discussion on The PROB function in Excel 2010 within the Applications forums, part of the Tutorials category; The PROB function in Excel 2010 The following tutorial will describe to you the usage and syntax of the PROB ...
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
Bookmarks