Manuals/calci/SAMPLING

SAMPLING (Array,Method,Number,NewTableFlag)

$Array$ is the array of values.
$Method$ is the type of sampling.
$Number$ is the number of samples.
and is the logical value.
- SAMPLING(),Samples the data by Random or Periodic method

Description

This function gives the sample from a entire range of values.
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(Array,Method,Number,NewTableFlag)$ , $Array$ is the array of values which contains the population of values to find the sample.
$Method$ 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 $Number$ at which we want sampling to take place. Sampling stops when the end of the input range is reached.
$Number$ 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.
$NewTableFlag$ is logical value like TRUE or FALSE.
TRUE is indicating the result will display in new worksheet. Suppose we are omitted the $NewTableFlag$ value it will consider the value as FALSE.