writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + − Samples a population randomly or periodically. − + + + + + + + + + + + + − In Periodic Sampling method, element has an chance of being chosen at particular period. − </div>+ − ----+ − <div id="7SpaceContent" class="zcontent" align="left">+ − + − Lets see an example in (Column3Row1)+ − + − <nowiki>=SAMPLING(R1C1:R6C1, "Radom", 3, TRUE)</nowiki>+ − + − SAMPLING returns the result in new sheet(5Space).+ − + − <nowiki>=SAMPLING(R1C2:R6C2, "Periodic", 2, TRUE)</nowiki>+ − + − SAMPLING returns the result in new sheet(9Space).+ − + − </div>+ − ----+ − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">+ − + − SAMPLING+ − + − </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="2SpaceContent" class="zcontent" align="left">+ − + − {| id="TABLE3" class="SpreadSheet blue"+ − + − + − + − + − + − + − + − + − − − − − − − − − − − − − − − − − − − − − − − − − − − − − − − − − − <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> − − <div align="left">[[Image:calci1.gif]]</div></div>+ − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − If the Number < 0, SAMPLING returns the #ERROR. − − − − </div> − ---- − <div id="6SpaceContent" class="zcontent" align="left"> − − '''SAMPLING'''(Array, Method, Number, NewTableFlag) − − where, − '''Array '''- Input range should be one block. − '''Method '''- Either Random or Periodic.By default set as Random.+ − '''Number '''- represents the number of samples. − − '''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE. − − </div> − ---- − <div id="5SpaceContent" class="zcontent" align="left"> − − {| class="SpreadSheet blue" − |+ <br />Sampling − |- class="even" − ! Input − ! Output − |- class="odd" − | 1 − | 17 − |- class="even" − | 7 − | 12 − |- class="odd" − | 12 − | 7 − |- class="even" − | 17 − | − |- class="odd" − | 37 − | − |- class="even" − | 6 − | − |} − − </div> − ---- − <div id="9SpaceContent" class="zcontent" align="left"> − − {| class="SpreadSheet blue" − |+ <br />Sampling − |- class="even" − ! Input − ! Output − |- class="odd" − | 3 − | 8 − |- class="even" − | 8 − | 5 − |- class="odd" − | 8 − | − |- class="even" − | 18 − | − |- class="odd" − | 34 − | − |- class="even" − | 5 − | − |} − </div>+ − ----
no edit summary
<div id="1SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''SAMPLING(ar,ty,n,lv)'''</div><br/>
*<math>ar </math> is the array of values.
*<math>ty </math> is the type of sampling.
*<math>n </math> is the number of samples
*<math>lv </math> and is the logical value.
In Random Sampling method, each element has an equal chance of being chosen at each draw.
==Description==
*This function gives the sample from a entire range of valus.
*Sampling is used in statistical analysis in which a predetermined number of observations will be taken from a larger population.
*The methodology used to sample from a larger population will depend on the type of analysis being performed.
*In SAMPLING(ar,ty,n,lv), ar is the array of values which contains the population of values to find the sample.
*ty is the Sampling type either Random or Periodic.
''RANDOM'':Here we have to mention the random Number of Samples. The number of values is taken from random positions in given array of values. A value can be selected more than once.
''PERIODIC'': Here we have to mention the Period n at which we want sampling to take place. Sampling stops when the end of the input range is reached.
*n is the number of random values that we want in the result.
*Each value is drawn from a random position in the given array, and any number can be selected more than once.
*lv is logical value like TRUE or FALSE.
*TRUE is indicating the result will display in new worksheet.Suppose we are omitted the lv value it will consider the value as FALSE.
==Examples==
#'''Example 1'''
{| class="wikitable"
|+Spreadsheet
|-
! !! A !! B !! C !! D!! E !! F !! G !! H !! I !! J !! K !! L !! M
|-
! 1
| 10 || 20 || 11 ||24 || 19 || 17 || 23 ||65 ||10 || 5 || 14 || 45 ||28
|}
#SAMPLING(A1:M1,RANDOM,5)
'''SAMPLING'''
{| class="wikitable"
|-
! !! INPUT !! OUTPUT
|-
|10 || 24
|-
| 20 || 20
|-
| 11 || 11
|-
| 24 || 19
|-
| 19 || 17
|-
| 17 ||
|-
| 23 ||
|-
| 65 ||
|-
| 10 ||
|- class="even"
|-
| class=" " |
| 5 ||
| Column1
|-
| Column2
| 14 ||
| class=" " | Column3
|-
| Column4
| 45 ||
|- class="odd"
|-
| class=" " | Row1
| 28 ||
| class=" " | 1
| class=" " | 3
| class="sshl_f" | 5Space
| class=" " |
|- class="even"
| class=" " | Row2
| class=" " | 7
| class=" " | 8
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class=" " | 12
| class=" " | 8
| class=" " |
| class=" " |
|- class="even"
| Row4
| class=" " | 17
| class=" " | 18
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class=" " | 37
| class=" " | 34
| class="sshl_f" | 9Space
| class=" " |
|- class="even"
| Row6
| class=" " | 6
| class=" " | 5
| class=" SelectTD1 ChangeBGColor SelectTD1" |
| class=" " |
|}
|}
# SAMPLING(A1:M1,PERIODIC,5)=NULL
SAMPLING returns the #ERROR, lengthof Array < Number.
==See Also==
==References==