Difference between revisions of "Manuals/calci/PROB"

From ZCubes Wiki
Jump to navigation Jump to search
Line 22: Line 22:
 
1      0.5
 
1      0.5
 
2      0.2
 
2      0.2
PROB(A2:A4,B2:B4,1)=0.5
+
=PROB(A2:A4,B2:B4,1) = 0.5
PROB(A2:A4,B2:B4,1,3)=0.7
+
=PROB(A2:A4,B2:B4,1,3) = 0.7
 
x        pr
 
x        pr
 
1        0.2
 
1        0.2
Line 29: Line 29:
 
3        0.1
 
3        0.1
 
4        0.5
 
4        0.5
PROB(C1:C4,D1:D4,2)=0.2
+
=PROB(C1:C4,D1:D4,2) = 0.2
PROB(C1:C4,D1:D4,2,4)=0.8
+
=PROB(C1:C4,D1:D4,2,4) = 0.8
 
x    pr
 
x    pr
 
0    0.3
 
0    0.3
 
1    0.7
 
1    0.7
 
2    0.1
 
2    0.1
PROB(A1:A3,B1:B3,2)=NAN
+
=PROB(A1:A3,B1:B3,2) = NAN
 
 
  
 
==See Also==
 
==See Also==

Revision as of 05:42, 7 January 2014

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 , 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

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

See Also

References