Difference between revisions of "Manuals/calci/PROB"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''PROB'''(Xs, Probabiltiy, LowerLimit, UpperLimit) where, '''Xs''' - is the set of numeric values of X with a...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''PROB(xr,pr,ll,ul)'''</div><br/>
 +
*<math>xr</math> is the array of x range is the value of the function.
 +
*<math>pr</math> is the set of probabilities.
 +
*<math>ll</math> is the lower limit and <math>ul</math> is the upper limit value.
  
−
'''PROB'''(Xs, Probabiltiy, LowerLimit, UpperLimit)
 
  
−
where,
+
==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 <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.
 +
*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.
 +
*This function will return the result as error when
 +
1.Any one of the value is nonnumeric.
 +
2.Any value of <math> pr \le 0 or pr >1
 +
3.the values in the given pr  do not adding  up to 1
 +
4.xr and pr is of different number of data points.
  
−
'''Xs''' - is the set of numeric values of X with associated probabilties.
 
  
−
'''Probability''' - is a set of probability.
+
==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
  
−
'''LowerLimit''' - is the lower bound on the values for a probability.
 
  
−
'''UpperLimit '''- is the optional upper bound on the value for a probability.
+
==See Also==
 +
*[[Manuals/calci/BINOMDIST  | BINOMDIST ]]
 +
*[[Manuals/calci/CRITBINOM | CRITBINOM]]
  
−
</div>
+
==References==
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
−
 
 
−
It returns the probability that values ina range are between two limits.
 
−
 
 
−
</div>
 
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
−
 
 
−
If Probability &lt;= 0 or Probability &gt; 1, PROB returns the #ERROR.
 
−
 
 
−
If UpperLimit is omitted, then it returns the probability of being equal to LowerLimit.
 
−
 
 
−
If Xs and Probalbility have different number of data points, PROB returns the #ERROR.
 
−
 
 
−
</div>
 
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
−
 
 
−
PROB
 
−
 
 
−
<font size="6"></font>
 
−
 
 
−
</div></div>
 
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example in (Column1, Row4)
 
−
 
 
−
<nowiki>=PROB(R1C1:R4C1,R1C2:R4C2,1,3)</nowiki>
 
−
 
 
−
PROB returns 0.7.
 
−
 
 
−
consider an another example
 
−
 
 
−
<nowiki>=PROB(R1C1:R4C1,R1C2:R3C2,1,3)</nowiki>
 
−
 
 
−
PROB returns #ERROR(Length of Xs != Length of Probability) .
 
−
 
 
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| Column1
 
−
| class="  " | Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class=" " | 2
 
−
| class=" " | 0.2
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class=" " | 1
 
−
| class=" " | 0.4
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
−
| class=" " | 3
 
−
| class=" " | 0.1
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " | 4
 
−
| class=" " | 0.3
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="      " |
 
−
| class="sshl_f" | 0.7
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row6
 
−
| class=" " |
 
−
| class="                                SelectTD ChangeBGColor SelectTD" |
 
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
−
| class=" " |
 
−
| class=" " |
 
−
|}
 
−
 
 
−
<div align="left">[[Image:calci1.gif]]</div></div>
 
−
----
 

Revision as of 02:49, 6 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 ul, then the function simply returns the probability associated with the value of the given ll.
  • This function will return the result as error when
1.Any one of the value is nonnumeric.
2.Any value of <math> pr \le 0 or pr >1
3.the values in the given pr  do not adding  up to 1
4.xr and pr 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

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/PROB&oldid=197038"