Changes

no edit summary
Line 1: Line 1:  
<div style="font-size:30px">'''SAMPLING(ar,ty,n,lv)'''</div><br/>
 
<div style="font-size:30px">'''SAMPLING(ar,ty,n,lv)'''</div><br/>
*<math>ar </math> is the array of values.
+
SAMPLING (Array,Method,Number,NewTableFlag)
*<math>ty </math> is the type of sampling.
+
*<math>Array </math> is the array of values.
*<math>n </math> is the number of samples  
+
*<math>Method </math> is the type of sampling.
*<math>lv </math> and  is the logical value.
+
*<math>Number </math> is the number of samples  
 +
*<math>NewTableFlag </math> and  is the logical value.
    
==Description==
 
==Description==
Line 9: Line 10:  
*Sampling is used in statistical analysis in which a predetermined number of observations will be taken from a larger population.  
 
*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.
 
*The methodology used to sample from a larger population will depend on the type of analysis being performed.
*In SAMPLING(ar,ty,n,lv), <math>ar</math> is the array of values which contains the population of values to find the sample.  
+
*In <math>SAMPLING (Array,Method,Number,NewTableFlag)</math>, <math>Array</math> is the array of values which contains the population of values to find the sample.  
*<math>ty</math> is the Sampling type either Random or Periodic.  
+
*<math>Method</math> 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 <math>n</math> 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 <math>Number</math> at which we want sampling to take place.  Sampling stops when the end of the input range is reached.
*<math>n</math> is  the number of random values that we want in the result.  
+
*<math>Number</math> 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.  
*<math>lv</math> is logical value like TRUE or FALSE.  
+
*<math>NewTableFlag</math> is logical value like TRUE or FALSE.  
*TRUE is indicating the result will display in new worksheet. Suppose we are omitted the <math>lv</math> value it will consider the value as FALSE.
+
*TRUE is indicating the result will display in new worksheet. Suppose we are omitted the <math>NewTableFlag</math> value it will consider the value as FALSE.
    
==Examples==
 
==Examples==
writer
6,694

edits