Manuals/calci/SAMPLING

SAMPLING(ar,ty,n,lv)

• $ar$ is the array of values.
• $ty$ is the type of sampling.
• $n$ is the number of samples
• $lv$ and is the logical value.

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(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

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

See Also

• HYPGEOMDIST