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 valus.
• 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:M1,PERIODIC,5)=NULL