Difference between revisions of "Manuals/calci/SAMPLING"

From ZCubes Wiki
Jump to navigation Jump to search
 
(9 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div style="font-size:30px">'''SAMPLING(ar,ty,n,lv)'''</div><br/>
+
<div style="font-size:30px">'''SAMPLING (Array,Method,Number,NewTableFlag)'''</div><br/>
−
*<math>ar </math> is the array of values.
+
*<math>Array </math> is the array of values.
−
*<math>ty </math> is the type of sampling.
+
*<math>Method </math> is the type of sampling.
−
*<math>n </math> is the number of samples  
+
*<math>Number </math> is the number of samples.
−
*<math>lv </math> and  is the logical value.
+
*<math>NewTableFlag </math> and  is the logical value.
−
 
+
**SAMPLING(),Samples the data by Random or Periodic method
  
 
==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 <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.  
−
*ty 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 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>Number</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>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.  
−
*lv 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 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>NewTableFlag</math> value it will consider the value as FALSE.
  
 
==Examples==
 
==Examples==
Line 28: Line 28:
 
| 10 || 20 || 11 ||24 || 19 || 17 || 23 ||65 ||10 || 5 || 14 || 45 ||28   
 
| 10 || 20 || 11 ||24 || 19 || 17 || 23 ||65 ||10 || 5 || 14 || 45 ||28   
 
|}
 
|}
−
#SAMPLING(A1:M1,RANDOM,5)
+
#SAMPLING(A1:M1,"RANDOM",5)
 
'''SAMPLING'''
 
'''SAMPLING'''
 
{| class="wikitable"
 
{| class="wikitable"
Line 61: Line 61:
 
|}
 
|}
  
−
# SAMPLING(A1:M1,PERIODIC,5)=NULL
+
# SAMPLING(A1:K1,"PERIODIC",3)
 +
'''SAMPLING'''
 +
{| class="wikitable"
 +
|-
 +
! INPUT !! OUTPUT
 +
|-
 +
|10 || 11
 +
|-
 +
| 20 || 17
 +
|-
 +
| 11 || 10
 +
|-
 +
| 24 ||
 +
|-
 +
| 19 ||
 +
|-
 +
| 17 ||
 +
|-
 +
| 23 ||
 +
|-
 +
| 65 ||
 +
|-
 +
| 10 ||
 +
|-
 +
| 5 ||
 +
|-
 +
| 14 ||
 +
|}
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|zsMaVcLxDZs|280|center|SAMPLING}}
  
 
==See Also==
 
==See Also==
  
 +
*[[Manuals/calci/HYPGEOMDIST| HYPGEOMDIST]]
  
 
==References==
 
==References==
 +
*[http://en.wikipedia.org/wiki/Sampling_%28statistics%29 Sampling]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 13:35, 18 June 2018

SAMPLING (Array,Method,Number,NewTableFlag)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array } is the array of values.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Method } is the type of sampling.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number } is the number of samples.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag } and is the logical value.
    • SAMPLING(),Samples the data by Random or Periodic method

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 , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the array of values which contains the population of values to find the sample.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Method} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} at which we want sampling to take place. Sampling stops when the end of the input range is reached.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} 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.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} is logical value like TRUE or FALSE.
  • TRUE is indicating the result will display in new worksheet. Suppose we are omitted the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} 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:K1,"PERIODIC",3)

SAMPLING

INPUT OUTPUT
10 11
20 17
11 10
24
19
17
23
65
10
5
14

Related Videos

SAMPLING

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/SAMPLING&oldid=210339"