PROB function in Excel


This article describes the formula syntax and usage of the PROB function in Excel. This function returns the probability that values ​​in a range are between two limits. If upper_limit is not available, the function returns the probability that the values ​​in x_range are equal to lower_limit.


PROB is a calculation function that produces the probability that values ​​in a range fall between two limits. Jaw PROB is also one of the functions in the group of statistical functions that are very popular in Excel.

How to use the PROB function in MS Excel

PROB function in Excel

1. Prob function syntax

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

Inside:

X_range is the range of numerical values ​​of X with the probabilities associated with it.
Prob_range is a probability set associated with values ​​in X_range.
Lower_limit is the lower bound of the value you want to get the probability of.
Upper_limit is the upper bound of the value you want to get the probability of.

2. Some notes:

– If any value in prob_range ≤ 0 or any value in prob_range> 1, PROB returns the error value #NUM!

– If the sum of values ​​in prob_range is not equal to 1, PROB returns the error value #NUM!

– If upper_limit is omitted, PROB returns the probability equal to lower_limit.

– If x_range and prob_range contain a different number of data points, PROB returns the error value # N / A.

3. Illustrative example

Calculate the probability that values ​​in a range fall between two limits with specific information, such as the spreadsheet image below:

ham prob in excel 2

Step 1: Enter the syntax of the function calculated in the cell B7 as follows:

ham prob in excel 3

Step 2: You press the key Enter To get the result of the function:

ham prob in excel 4

Step 3: Next you calculate the probability that X is between 1 and 4 as follows:

Enter the syntax of the function calculated in the cell B8:

ham prob in excel 5

Step 4: You press the key Enter To get the result of the function:

ham prob in excel 6

If any value in prob_range ≤ 0 or any value in prob_range> 1, PROB returns the error value. #NUM! As the picture below:

ham prob in excel 7

If the sum of the values ​​in prob_range is not equal to 1, PROB returns the error value #NUM!

ham prob in excel 8

Here I have completed the tutorial how to use PROB function in Excel, use this function to help you calculate so that the result is the probability that the values ​​in a range are between the limits.

https://thuthuat.taimienphi.vn/ham-prob-rong-excel-44325n.aspx
In addition, you should learn and refer to the basic functions in Excel that Taimienphi.vn introduced, share to see and review formulas and how to use functions in Excel. Good luck!

.

Add a Comment

Your email address will not be published. Required fields are marked *