PROB
Returns the probability that values in a range are between two limits.
StatisticalStatistics & Analysis
What it does
Calculates probability that a value falls within a range, given a probability distribution.
Syntax
PROB(x_range, prob_range, lower_limit, [upper_limit])
Arguments
x_range(range) — Numeric values.prob_range(range) — Probabilities associated with values.lower_limit(number) — Lower bound.
Examples
Range Probability
Prob of getting 1 or 2.
FORMULA
=PROB(A1:A3, B1:B3, 1, 2)
RESULT
0.5
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | X | Prob |
| 2 | 1 | 0.2 |
| 3 | 2 | 0.3 |
| 4 | 3 | 0.5 |