The Excel PROB Function

Basic Description

Given a list of values and a corresponding list of probabilities, the Excel PROB function calculates the probability associated with a given range.

The format of the Excel Prob function is:

PROB( x_range, prob_range, lower_limit, [upper_limit] )

where the arguments are as follows :

x_range - An array of values, which have associated probabilities
prob_range - The array of probabilities corresponding to the values in x_range

(This array must have the same length as the x_range array and the values in prob_range must add up to 1)

lower_limit - The lower bound of the range of values for which you want to calculate the probability
[upper_limit] - An optional value that denotes the upper bound of the range that you want to calculate the probability for.

(If the upper_bound is omitted the function simply returns the probability associated with the value of the supplied lower_bound)

Prob Function Examples

Columns A and B of the spreadsheet below contain a set of values and their associated probabilities. These values and probabilities are provided to the Excel Prob function, in cells C1-C3 of the spreadsheet.

Examples of use of the Excel Prob Function

Further examples of the Excel Prob function can be found on the Microsoft Office website.

Prob Function Errors

If you get an error returned from the Excel Prob Function, this is likely to be one of the following:

Common Errors
#NUM! - Occurs if either:
- any value in the supplied prob_range is <0 or >1
- the values in the supplied prob_range do not add up to 1
#N/A! - Occurs if the supplied x_range and prob_range arrays are of different lengths (i.e. contain different numbers of data points)
Return to the Excel Statistical Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2015