Changes

==Description==

==Description==

*This function gives the sample from a entire range of valus.  

*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.  

*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), ar is the array of values which contains the population of values to find the sample.  

*In SAMPLING(ar,ty,n,lv), <math>ar</math> is the array of values which contains the population of values to find the sample.  

*ty is the Sampling type either Random or Periodic.  

*<math>ty</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 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 <math>n</math> 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.  

*<math>n</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.  

*lv is logical value like TRUE or FALSE.  

*<math>lv</math> 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 <math>lv</math> value it will consider the value as FALSE.

==Examples==

==Examples==