Buzz
PROB is a computational function that yields the probability of values within a range. The PROB function falls under the category of statistical functions and is widely favored in Excel applications.
How to use PROB function in MS Excel
Excel's PROB Function
1. Syntax of the Prob function
=PROB(x_range, prob_range, [lower_limit], [upper_limit])
Where:
- X_range represents the numerical range of X with associated probabilities.
- Prob_range is a set of probabilities linked to values within X_range.
2. Some considerations:
- If any value in prob_range ≤ 0 or any value in prob_range > 1, the PROB function returns an error value #NUM!
- If the sum of values in prob_range is not equal to 1, the PROB function returns an error value #NUM!
- If upper_limit is omitted, the PROB function returns the probability for the lower_limit.
- If x_range and prob_range contain different data points, the PROB function returns an error value #N/A.
3. Illustrative Example
Calculate the probability of values within a range with specific details from the example spreadsheet below:
Step 1: Enter the function syntax in cell B7 as follows:
Step 2: Press the Enter key to obtain the calculation result:
Step 3: Next, calculate the probability for X between 1 and 4 as follows:
Enter the function syntax in cell B8:
Step 4: Press the Enter key to obtain the calculation result:
If any value in prob_range is ≤ 0 or any value in prob_range is > 1, the PROB function returns the error value #NUM! as shown in the image below:
If the sum of values in prob_range is not equal to 1, the PROB function returns the error value #NUM!
At this point, I have completed the guide on how to use Excel's PROB Function. Utilizing this function allows you to calculate the probability of values within a range between two limits.
Additionally, it is advisable to explore and refer to other basic functions in Excel that Mytour has previously introduced, sharing insights into formulas and how to use functions in Excel. Wishing you success!
