Manuals/calci/SAMPLING

From ZCubes Wiki
Revision as of 01:17, 5 February 2014 by Abin (talk | contribs) (→‎Description)
Jump to navigation Jump to search
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

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

See Also

References