Manuals/calci/PROB

PROB (Xs,Probabilities,lower_limit,upper_limit)

• $Xs$ is the array of x range of values in the function.
• $Probabilities$ is the set of probabilities.
• $lowerlimit$ is the lower limit
• $upperlimit$ is the upper limit value.
  • PROB(),returns the probability that values in a range are between two limits.

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(Xs,Probabilities,lowerlimit,upperlimit)$, $Xs$ is the array of numeric values which there are associated probabilities, $Probabilities$ is a set of probabilities associated with $Xs$, $lowerlimit$ is the lower limit of the probability and $upperlimit$ is the upper limit of the probability.
• Here $upperlimit$ is optional. When we are omitting the value of $upperlimit$, then the function simply returns the probability associated with the value of the given $lowerlimit$.
• This function will return the result as error when

1.Any one of the value is non-numeric.
2.Any value of $Probabilities\leq 0$ or $Probabilities>1$
3.The values in the given $Probabilities$  do not adding  up to 1
4.$Xs$ and $Probabilities$ 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

Related Videos

PROBABILITY

See Also

• BINOMDIST
• CRITBINOM

References

Probability

• List of Main Z Functions

• Z3 home