writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + − '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, MinNum, MaxNum)+ + + + + + + + + + − where, − '''Number '''- represents the number of variables.+ + + + + − '''RandomNumber '''- represents the number of random number+ − '''Distribution '''- represents the distribution method(i.e uniform) to create random values. − '''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.+ − − '''MinNum '''- represents the lower bound. − − '''MaxNum '''- represents the upper bound. − − </div> − ---- − <div id="1SpaceContent" class="zcontent" align="left">In Uniform Distribution, elements has an equal probability of being chosen at each draw.</div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − Lets see an example in (Column3Row1) − − <nowiki>=RANDOMNUMBERGENERATION(3, 4, "Uniform", TRUE, 3, 4)</nowiki> − − RANDOMNUMBERGENERATION returns the result in new sheet(5Space). − − <nowiki>=RANDOMNUMBERGENERATION(-3, 4, "Uniform", TRUE, 3, 4)</nowiki> − − RANKANDPERCENTILE returns the #ERROR(Number < 0). − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − RANDOM NUMBER GENERATION : UNIFORM − − </div></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="8SpaceContent" class="zcontent" align="left"> − − If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR. − − </div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | Column2 − | class=" " | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f" | 5Space − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | class=" " | Row2 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="odd" − | Row3 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row4 − | class="sshl_f" | − | class=" " | − | class=" " | − | class=" " | − |- class="odd" − | class=" " | Row5 − | class=" SelectTD1 ChangeBGColor SelectTD1" | − <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=" " | − | class=" " | − |- class="even" − | Row6 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |} − − <div align="left">[[Image:calci1.gif]]</div></div> − ---- − <div id="5SpaceContent" class="zcontent" align="left"> − − {| class="SpreadSheet blue" − |+ Random Number Generation<br />Uniform Distribution − |- class="even" − | 3.9179240869362353 − | 1.9353770981878542 − | 3.1999177033935786 − |- class="odd" − | 2.6672694494628155 − | 2.304309051607576 − | 3.5802220587629203 − |- class="even" − | 3.463705677339731 − | 3.0560718547489056 − | 2.2494758116026307 − |- class="odd" − | 2.561365618826837 − | 2.456471014450667 − | 2.4974644940169765 − |} − − </div> − ----
no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''UNIFORMDISTRIBUTED(x,ll,ul)'''</div><br/>
*<math>x </math> and <math> ar2 </math> is the value of the function.
*<math>ll </math> is the lower limit.
*<math> ul </math> is the upper limit of the function.
==Description==
*This function gives the probability of the unifom distribution.
*Uniform distribution is a symmetric probability distribution.
*It is also called rectangular distribution.
*In UNIFORMDISTRIBUTED(x,ll,ul) ,x is the numeric value to find the probability of the distribution, ll is the lower limit value and ul is the upper limit value.
*The probability density function of the uniform distribution in the interval [a,b] are:
<math>P(x)=\begin{cases}
0 &for &x<a,\\
1/b-a &for &a<x<b \\
0 &for &x>b. \end{cases}
==Examples==
#UNIFORMDISTRIBUTED(4,2,3)=
4030484680552036 2.6280935418326408 2.2810050058178604 2.97846262995153679
#UNIFORMDISTRIBUTED(5,3,6) =
5.522187389200553 3.566177821950987 5.04674904467538 5.301322509767488 4.9094569575972855
==See Also==
==References==