PROB(xr,pr,ll,ul)
- is the array of x range is the value of the function.
- is the set of probabilities.
- is the lower limit and 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 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 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 nonnumeric. 2.Any value of <math> pr \le 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
x pr 0 0.3 1 0.5 2 0.2 PROB(A2:A4,B2:B4,1)=0.5 PROB(A2:A4,B2:B4,1,3)=0.7 x pr 1 0.2 2 0.2 3 0.1 4 0.5 PROB(C1:C4,D1:D4,2)=0.2 PROB(C1:C4,D1:D4,2,4)=0.8 x pr 0 0.3 1 0.7 2 0.1 PROB(A1:A3,B1:B3,2)=NAN