Difference between revisions of "Manuals/calci/PROB"

 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="font-size:30px">'''PROB(xr,pr,ll,ul)'''</div><br/>
+
<div style="font-size:30px">'''PROB (Xs,Probabilities,lower_limit,upper_limit)'''</div><br/>
*<math>xr</math> is the array of x range of values in the function.
+
*<math>Xs</math> is the array of x range of values in the function.
*<math>pr</math> is the set of probabilities.
+
*<math>Probabilities</math> is the set of probabilities.
*<math>ll</math> is the lower limit
+
*<math>lowerlimit</math> is the lower limit
*<math>ul</math> is the upper limit value.
+
*<math>upperlimit</math> is the upper limit value.
 +
**PROB(),returns the probability that values in a range are between two limits.
  
 
==Description==
 
==Description==
Line 9: Line 10:
 
*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(Xs,Probabilities,lowerlimit,upperlimit)</math>, <math>Xs</math> is the array of numeric values which there are associated probabilities, <math>Probabilities</math> is a set of probabilities associated with <math> Xs</math>, <math>lowerlimit</math> is the lower limit of the probability and <math>upperlimit</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>upperlimit</math> is optional. When we are omitting the value of <math>upperlimit</math>, then the function simply returns the probability associated with the value of the given <math>lowerlimit</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.
  2.Any value of <math> pr \le 0 </math> or <math>pr >1</math>
+
  2.Any value of <math> Probabilities \le 0 </math> or <math>Probabilities >1</math>
  3.The values in the given <math>pr</math>  do not adding  up to 1
+
  3.The values in the given <math>Probabilities</math>  do not adding  up to 1
  4.<math>xr</math> and <math>pr</math> is of different number of data points.
+
  4.<math>Xs</math> and <math>Probabilities</math> is of different number of data points.
  
 
==Examples==
 
==Examples==

Latest revision as of 16:59, 8 August 2018

PROB (Xs,Probabilities,lower_limit,upper_limit)


  • 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.
    • PROB(),returns the probability that values in a range are between two limits.

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

Related Videos

PROBABILITY

See Also

References

Probability