Manuals/calci/PROB

PROB (Xs,Probabilities,lower_limit,upper_limit)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Xs} is the array of x range of values in the function.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Probabilities} is the set of probabilities.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle lowerlimit} is the lower limit
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PROB(Xs,Probabilities,lowerlimit,upperlimit)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Xs} is the array of numeric values which there are associated probabilities, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Probabilities} is a set of probabilities associated with Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Xs} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle lowerlimit} is the lower limit of the probability and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle upperlimit} is the upper limit of the probability.
• Here Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle upperlimit} is optional. When we are omitting the value of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle upperlimit} , then the function simply returns the probability associated with the value of the given Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle lowerlimit} .
• This function will return the result as error when

1.Any one of the value is non-numeric.
2.Any value of Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle Probabilities\leq 0}
 or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Probabilities >1}

3.The values in the given Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Probabilities}
  do not adding  up to 1
4.Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Xs}
 and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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