Jump to navigation Jump to search
- 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.
- 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.
=PROB(A1:C1,A2:C2,1) = 0.5 =PROB(A1:C1,A2:C2,1,3) = 0.7
=PROB(A1:D1,A2:D2,2) = 0.2 =PROB(A1:D1,A2:D2,2,4) = 0.8
=PROB(A1:C1,A2:C2,2) = NAN