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

1.

Spreadsheet

	A	B	C
1	0	1	2
2	0.3	0.5	0.2

=PROB(A1:C1,A2:C2,1) = 0.5
=PROB(A1:C1,A2:C2,1,3) = 0.7

2.

Spreadsheet

	A	B	C	D
1	1	2	3	4
2	0.2	0.2	0.1	0.5

=PROB(A1:D1,A2:D2,2) = 0.2
=PROB(A1:D1,A2:D2,2,4) = 0.8

3.

Spreadsheet

	A	B	C
1	0	1	2
2	0.3	0.7	0.1

=PROB(A1:C1,A2:C2,2) = NAN

See Also

• BINOMDIST
• CRITBINOM

References

Probability