Manuals/calci/PROB

PROB(xr,pr,ll,ul)

• $xr$ is the array of x range of values in the function.
• $pr$ is the set of probabilities.
• $ll$ is the lower limit
• $ul$ is the upper limit value.

Description

• This function gives the probability that values in a range of given limits.
• Probability is the likelihood that an event will occur.
• Probabilities can be used to describe frequencies of outcomes in random experiments.
• In $PROB(xr,pr,ll,ul)$, $xr$ is the array of numeric values which there are associated probabilities, $pr$ is a set of probabilities associated with $xr$, $ll$ is the lower limit of the probability and $ul$ is the upper limit of the probability.
• Here $ul$ is optional. When we are omitting the value of $ul$, then the function simply returns the probability associated with the value of the given $ll$.
• This function will return the result as error when

1.Any one of the value is non-numeric.
2.Any value of $pr\leq 0$ or $pr>1$
3.The values in the given $pr$  do not adding  up to 1
4.$xr$ and $pr$ is of different number of data points.

Examples

x pr 0 0.3 1 0.5 2 0.2 =PROB(A2:A4,B2:B4,1) = 0.5 =PROB(A2:A4,B2:B4,1,3) = 0.7 x pr 1 0.2 2 0.2 3 0.1 4 0.5 =PROB(C1:C4,D1:D4,2) = 0.2 =PROB(C1:C4,D1:D4,2,4) = 0.8 x pr 0 0.3 1 0.7 2 0.1 =PROB(A1:A3,B1:B3,2) = NAN

See Also

• BINOMDIST
• CRITBINOM

References

Probability