Statistical
All versions
◉ 26 views
=PROB()
Returns the probability that values in a range are between two limits. If upper_limit is not supplied, returns the probability that values in x_range are equal to lower_limit.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=PROB(x_range, prob_range, [lower_limit], [upper_limit])
Hover argument names in the table for details.
Output typeNumber
Popularity6 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =PROB() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
x_range |
Range | Required | The range of numeric values of x with which there are associated probabilities. |
prob_range |
Range | Required | A set of probabilities associated with values in x_range. |
lower_limit |
Number | Optional | The lower bound on the value for which you want a probability. |
upper_limit |
Number | Optional | The optional upper bound on the value for which you want a probability. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
Value of x |
B2 |
Probability |
A3 |
0 |
B3 |
0.2 |
A4 |
1 |
B4 |
0.3 |
A5 |
2 |
B5 |
0.1 |
A6 |
3 |
B6 |
0.4 |
A7 |
Value of x |
B7 |
Probability |
A8 |
0 |
B8 |
0.2 |
A9 |
1 |
B9 |
0.3 |
A10 |
2 |
B10 |
0.1 |
A11 |
3 |
B11 |
0.4 |
Probability that x is 2.
=PROB(A3:A6,B3:B6,2)
Result:
0.1
Probability that x is between 1 and 3.
=PROB(A3:A6,B3:B6,1,3)
Result:
0.8
§ Remarks
- If any value in prob_range ≤ 0 or if any value in prob_range > 1, PROB returns the #NUM! error value.
- If the sum of the values in prob_range is not equal to 1, PROB returns the #NUM! error value.
- If upper_limit is omitted, PROB returns the probability of being equal to lower_limit.
- If x_range and prob_range contain a different number of data points, PROB returns the #N/A error value.
✦ Tips
- If upper_limit is omitted, PROB returns the probability of being equal to lower_limit.
⚠ Common Errors
#NUM!
If any value in prob_range ≤ 0 or if any value in prob_range > 1, PROB returns the #NUM! error value. If the sum of the values in prob_range is not equal to 1, PROB returns the #NUM! error value.
Fix: Correct the probability column
#N/A
If x_range and prob_range contain a different number of data points, PROB returns the #N/A error value.
Fix: مطمئن شوید هر دو محدوده اندازه یکسان دارند و با هم متناظر هستند.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!