Manuals/calci/SAMPLING

SAMPLING(ar,ty,n,lv)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar } is the array of values.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ty } is the type of sampling.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n } is the number of samples
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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), Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar} is the array of values which contains the population of values to find the sample.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} at which we want sampling to take place. Sampling stops when the end of the input range is reached.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle lv} is logical value like TRUE or FALSE.
• TRUE is indicating the result will display in new worksheet. Suppose we are omitted the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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