Manuals/calci/SAMPLING

From ZCubes Wiki
Revision as of 21:43, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="1SpaceContent" class="zcontent" align="left"> Samples a population randomly or periodically. In Random Sampling method, each element has an equal chance of bei...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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


Syntax

Remarks

Examples

Description

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.



Sampling
Input Output
1 17
7 12
12 7
17
37
6


Sampling
Input Output
3 8
8 5
8
18
34
5