Manuals/calci/PROB

PROB (Xs,Probabilities,lower_limit,upper_limit)

• is the array of x range of values in the function.
• is the set of probabilities.
• is the lower limit
• 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 , is the array of numeric values which there are associated probabilities, is a set of probabilities associated with , is the lower limit of the probability and is the upper limit of the probability.
• Here is optional. When we are omitting the value of , then the function simply returns the probability associated with the value of the given .
• This function will return the result as error when
1.Any one of the value is non-numeric.
2.Any value of or 3.The values in the given do not adding  up to 1
4. and is of different number of data points.

Examples

1.

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.

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.