Difference between revisions of "Manuals/calci/PROB"
Jump to navigation
Jump to search
Line 62: | Line 62: | ||
=PROB(A1:C1,A2:C2,2) = NAN | =PROB(A1:C1,A2:C2,2) = NAN | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|FICRd7Lp67s|280|center|PROBABILITY}} | ||
==See Also== | ==See Also== |
Revision as of 15:07, 20 June 2015
PROB(xr,pr,ll,ul)
- 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.
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.
A | B | C | |
---|---|---|---|
1 | 0 | 1 | 2 |
2 | 0.3 | 0.7 | 0.1 |
=PROB(A1:C1,A2:C2,2) = NAN