Difference between revisions of "Manuals/calci/SAMPLING"
Jump to navigation
Jump to search
Line 91: | Line 91: | ||
==See Also== | ==See Also== | ||
+ | *[[Manuals/calci/HYPGEOMDIST| HYPGEOMDIST]] | ||
==References== | ==References== |
Revision as of 12:34, 11 May 2015
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 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), is the array of values which contains the population of values to find the sample.
- 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 at which we want sampling to take place. Sampling stops when the end of the input range is reached.
- 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.
- is logical value like TRUE or FALSE.
- TRUE is indicating the result will display in new worksheet. Suppose we are omitted the 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:K1,"PERIODIC",3)
SAMPLING
INPUT | OUTPUT |
---|---|
10 | 11 |
20 | 17 |
11 | 10 |
24 | |
19 | |
17 | |
23 | |
65 | |
10 | |
5 | |
14 |