Manuals/calci/SAMPLING
SAMPLING(ar,ty,n,lv)
- is the array of values.
- is the type of sampling.
- is the number of samples
- 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
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 |
- 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 |
- SAMPLING(A1:M1,PERIODIC,5)=NULL