Manuals/calci/PROB

Revision as of 04:36, 22 January 2014 by Abin (talk | contribs) (→‎Examples)
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.

Spreadsheet
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.

Spreadsheet
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.

Spreadsheet
A B C
1 0 1 2
2 0.3 0.7 0.1
=PROB(A1:C1,A2:C2,2) = NAN

See Also

References

Probability