PROB Function: Returns the probability of values within a range between 2 limits in Excel

Buzz

Ngày cập nhật gần nhất: 15/4/2026

This article introduces you to the PROB function, one of the commonly used statistical functions in Excel.

Description: Returns the probability of values within a range between 2 limits.

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

Here are the details:

- x_range: The range of numerical values of x associated with their probabilities, which is a required parameter.

- prob_range: A set of probabilities associated with the values in x_range, which is a required parameter.

- lower_limit: The lower bound of the value for which to calculate the probability.

- upper_limit: The optional upper bound of the value for which to calculate the probability.

Note:

- If any value in Prob_name is not equal to 1 or is greater than 1 or less than or equal to 0 -> the function returns an error value #NUM!

- If the upper_limit parameter is omitted -> the function returns the probability at the lower_limit

- If x_range and prob_range have different numbers of data points -> the function returns the error value #N/A

Example:

Calculate the probability Prob with the data described in the table below:

- In the cell where you want to calculate the probability, enter the formula: =PROB($B$6:$B$9,$C$6:$C$9,D6) (Here using absolute address)

- Press Enter -> copy the formula for the remaining values to get the results:

- If any value in prob_range is greater than 1 or less than 0 => the function returns the error value #NUM!

Above is the guide and some specific examples when using the Prob function - which returns the probability of values within a range between 2 limits in Excel.

Wishing you success!

Frequently Asked Questions

What is the purpose of the PROB function in Excel?

The PROB function in Excel calculates the probability of a range of values falling between two specified limits. It is commonly used in statistical analysis to understand data distributions and outcomes.

What parameters are required for the PROB function to work properly?

To use the PROB function correctly, you need two mandatory parameters: x_range, which contains the numerical values, and prob_range, which consists of their associated probabilities. Ensuring these parameters are correctly defined is essential for accurate calculations.

What happens if the upper limit is omitted in the PROB function?

If the upper_limit parameter is omitted in the PROB function, the function will return the probability at the specified lower_limit. This allows users to calculate probabilities based solely on one boundary.

How can errors occur when using the PROB function in Excel?

Errors in the PROB function can arise if any value in prob_range is greater than 1 or less than 0, leading to a #NUM! error. Additionally, if x_range and prob_range contain different numbers of data points, the function will return a #N/A error.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]