Difference between revisions of "Manuals/calci/PROB"

 
(12 intermediate revisions by 4 users 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 is the value of 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 and <math>ul</math> is the upper limit value.
+
*<math>lowerlimit</math> is the lower limit
 
+
*<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), 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,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 ul, then the function simply returns the probability associated with the value of the given ll.
+
*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 nonnumeric.
+
  1.Any one of the value is non-numeric.
  2.Any value of <math> pr \le 0 or pr >1
+
  2.Any value of <math> Probabilities \le 0 </math> or <math>Probabilities >1</math>
  3.the values in the given pr do not adding  up to 1
+
  3.The values in the given <math>Probabilities</math> do not adding  up to 1
  4.xr and pr is of different number of data points.
+
  4.<math>Xs</math> and <math>Probabilities</math> is of different number of data points.
 +
 
 +
==Examples==
 +
1.
 +
{| class="wikitable"
 +
|+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.
 +
{| class="wikitable"
 +
|+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.
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C
 +
|-
 +
! 1
 +
| 0 || 1 || 2
 +
|-
 +
! 2
 +
| 0.3 || 0.7 || 0.1
 +
|}
  
 +
=PROB(A1:C1,A2:C2,2) = NAN
  
==Examples==
+
==Related Videos==
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
 
  
 +
{{#ev:youtube|FICRd7Lp67s|280|center|PROBABILITY}}
  
 
==See Also==
 
==See Also==
Line 44: Line 73:
  
 
==References==
 
==References==
 +
[http://en.wikipedia.org/wiki/Probability Probability ]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

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