writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + − '''PROB'''(Xs, Probabiltiy, LowerLimit, UpperLimit) − where,+ + + + + + + + + + + − '''Xs''' - is the set of numeric values of X with associated probabilties. − '''Probability''' - is a set of probability.+ + + + + + + + + + + + + + + + + + + − '''LowerLimit''' - is the lower bound on the values for a probability. − '''UpperLimit '''- is the optional upper bound on the value for a probability.+ + + − </div>+ − ---- − <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 <= 0 or Probability > 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> − ----
no edit summary
<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.
==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.
==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==
*[[Manuals/calci/BINOMDIST | BINOMDIST ]]
*[[Manuals/calci/CRITBINOM | CRITBINOM]]
==References==