*In SAMPLING(ar,ty,n,lv), ar is the array of values which contains the population of values to find the sample.
*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.
*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.
+
*'''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.
+
*'''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.
*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.
*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.
*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.
*TRUE is indicating the result will display in new worksheet.Suppose we are omitted the lv value it will consider the value as FALSE.