| 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== |