Difference between revisions of "Manuals/calci/PROB"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''PROB(xr,pr,ll,ul)'''</div><br/> | <div style="font-size:30px">'''PROB(xr,pr,ll,ul)'''</div><br/> | ||
| − | *<math>xr</math> is the array of x range | + | *<math>xr</math> is the array of x range of values in the function. |
*<math>pr</math> is the set of probabilities. | *<math>pr</math> is the set of probabilities. | ||
| − | *<math>ll</math> is the lower limit | + | *<math>ll</math> is the lower limit |
| − | + | *<math>ul</math> is the upper limit value. | |
==Description== | ==Description== | ||
| Line 9: | Line 9: | ||
*Probability is the likelihood that an event will occur. | *Probability is the likelihood that an event will occur. | ||
*Probabilities can be used to describe frequencies of outcomes in random experiments. | *Probabilities can be used to describe frequencies of outcomes in random experiments. | ||
| − | *In <math>PROB(xr,pr,ll,ul)</math>, <math>xr</math> is the array of numeric values which there are associated probabilities,<math>pr</math> is a set of probabilities associated with <math> xr</math>, <math>ll</math> is the lower limit of the probability and <math>ul</math> is the upper limit of the probability. | + | *In <math>PROB(xr,pr,ll,ul)</math>, <math>xr</math> is the array of numeric values which there are associated probabilities, <math>pr</math> is a set of probabilities associated with <math> xr</math>, <math>ll</math> is the lower limit of the probability and <math>ul</math> is the upper limit of the probability. |
| − | *Here <math>ul</math> is optional.When we are omitting the value of <math>ul</math>, then the function simply returns the probability associated with the value of the given <math>ll</math>. | + | *Here <math>ul</math> is optional. When we are omitting the value of <math>ul</math>, then the function simply returns the probability associated with the value of the given <math>ll</math>. |
*This function will return the result as error when | *This function will return the result as error when | ||
1.Any one of the value is non-numeric. | 1.Any one of the value is non-numeric. | ||
Revision as of 04:23, 22 January 2014
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.
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.
or 
3.The values in the given 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