Manuals/calci/SAMPLING
Samples a population randomly or periodically.
In Random Sampling method, each element has an equal chance of being chosen at each draw.
In Periodic Sampling method, element has an chance of being chosen at particular period.
Lets see an example in (Column3Row1)
=SAMPLING(R1C1:R6C1, "Radom", 3, TRUE)
SAMPLING returns the result in new sheet(5Space).
=SAMPLING(R1C2:R6C2, "Periodic", 2, TRUE)
SAMPLING returns the result in new sheet(9Space).
SAMPLING
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 3 | 5Space | |
| Row2 | 7 | 8 | ||
| Row3 | 12 | 8 | ||
| Row4 | 17 | 18 | ||
| Row5 | 37 | 34 | 9Space | |
| Row6 | 6 | 5 |
If the Number < 0, SAMPLING returns the #ERROR.
SAMPLING returns the #ERROR, lengthof Array < Number.
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.
| Input | Output |
|---|---|
| 1 | 17 |
| 7 | 12 |
| 12 | 7 |
| 17 | |
| 37 | |
| 6 |
| Input | Output |
|---|---|
| 3 | 8 |
| 8 | 5 |
| 8 | |
| 18 | |
| 34 | |
| 5 |