Manuals/calci/PROB
PROB(Xs, Probabiltiy, LowerLimit, UpperLimit)
where,
Xs - is the set of numeric values of X with associated probabilties.
Probability - is a set of probability.
LowerLimit - is the lower bound on the values for a probability.
UpperLimit - is the optional upper bound on the value for a probability.
It returns the probability that values ina range are between two limits.
If Probability <= 0 or Probability > 1, PROB returns the #ERROR.
If UpperLimit is omitted, then it returns the probability of being equal to LowerLimit.
If Xs and Probalbility have different number of data points, PROB returns the #ERROR.
PROB
Lets see an example in (Column1, Row4)
=PROB(R1C1:R4C1,R1C2:R4C2,1,3)
PROB returns 0.7.
consider an another example
=PROB(R1C1:R4C1,R1C2:R3C2,1,3)
PROB returns #ERROR(Length of Xs != Length of Probability) .
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 0.2 | ||
| Row2 | 1 | 0.4 | ||
| Row3 | 3 | 0.1 | ||
| Row4 | 4 | 0.3 | ||
| Row5 | 0.7 | |||
| Row6 |
