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.
• $NewTableFlag$ 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.

Examples

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

1. SAMPLING(A1:M1,"RANDOM",5)

SAMPLING

INPUT	OUTPUT
10	24
20	20
11	11
24	19
19	17
17
23
65
10
5
14
45
28

1. SAMPLING(A1:K1,"PERIODIC",3)

SAMPLING

INPUT	OUTPUT
10	11
20	17
11	10
24
19
17
23
65
10
5
14

Related Videos

SAMPLING

See Also

• HYPGEOMDIST

References

• Sampling

• List of Main Z Functions

• Z3 home