Difference between revisions of "Manuals/calci/SAMPLING"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="1SpaceContent" class="zcontent" align="left"> Samples a population randomly or periodically. In Random Sampling method, each element has an equal chance of bei...")
 
 
(13 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="1SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''SAMPLING (Array,Method,Number,NewTableFlag)'''</div><br/>
 +
*<math>Array </math> is the array of values.
 +
*<math>Method </math> is the type of sampling.
 +
*<math>Number </math> is the number of samples.
 +
*<math>NewTableFlag </math> and  is the logical value.
 +
**SAMPLING(),Samples the data by Random or Periodic method
  
−
Samples a population randomly or periodically.
+
==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 <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>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.
 +
*'''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>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.
 +
*<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>NewTableFlag</math> value it will consider the value as FALSE.
  
−
In Random Sampling method, each element has an equal chance of being chosen at each draw.
+
==Examples==
−
 
+
{| class="wikitable"
−
In Periodic Sampling method, element has an chance of being chosen at particular period.
+
|+Spreadsheet
−
 
+
|-
−
</div>
+
! !! A !! B !! C !! D!! E !! F !! G !! H !! I !! J !! K !! L !! M
−
----
+
|-
−
<div id="7SpaceContent" class="zcontent" align="left">
+
! 1
−
 
+
| 10 || 20 || 11 ||24 || 19 || 17 || 23 ||65 ||10 || 5 || 14 || 45 ||28 
−
Lets see an example in (Column3Row1)
+
|}
−
 
+
#SAMPLING(A1:M1,"RANDOM",5)
−
<nowiki>=SAMPLING(R1C1:R6C1, "Radom", 3, TRUE)</nowiki>
+
'''SAMPLING'''
−
 
+
{| class="wikitable"
−
SAMPLING returns the result in new sheet(5Space).
+
|-
−
 
+
! INPUT !! OUTPUT
−
<nowiki>=SAMPLING(R1C2:R6C2, "Periodic", 2, TRUE)</nowiki>
+
|-
−
 
+
|10 || 24
−
SAMPLING returns the result in new sheet(9Space).
+
|-
−
 
+
| 20 || 20
−
</div>
+
|-
−
----
+
| 11 || 11
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
|-
−
 
+
| 24 || 19
−
SAMPLING
+
|-
 +
| 19 || 17
 +
|-
 +
| 17 ||
 +
|-
 +
| 23 ||
 +
|-
 +
| 65 ||
 +
|-
 +
| 10 ||
 +
|-
 +
| 5 ||
 +
|-
 +
| 14 ||
 +
|-
 +
| 45 ||
 +
|-
 +
| 28 ||
 +
|}
  
−
</div></div>
+
# SAMPLING(A1:K1,"PERIODIC",3)
−
----
+
'''SAMPLING'''
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
+
{| class="wikitable"
−
----
+
|-
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
+
! INPUT !! OUTPUT
−
----
+
|-
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
+
|10 || 11
−
----
+
|-
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
+
| 20 || 17
−
----
+
|-
−
<div id="2SpaceContent" class="zcontent" align="left">
+
| 11 || 10
−
 
+
|-
−
{| id="TABLE3" class="SpreadSheet blue"
+
| 24 ||  
−
|- class="even"
+
|-
−
| class=" " |
+
| 19 ||  
−
| Column1
+
|-
−
| Column2
+
| 17 ||
−
| class="  " | Column3
+
|-
−
| Column4
+
| 23 ||
−
|- class="odd"
+
|-
−
| class=" " | Row1
+
| 65 ||
−
| class=" " | 1
+
|-
−
| class=" " | 3
+
| 10 ||
−
| class="sshl_f" | 5Space
+
|-
−
| class=" " |
+
| 5 ||
−
|- class="even"
+
|-
−
| class="  " | Row2
+
| 14 ||
−
| class=" " | 7
 
−
| class=" " | 8
 
−
| class="              " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
−
| class=" " | 12
 
−
| class=" " | 8
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " | 17
 
−
| class=" " | 18
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class=" " | 37
 
−
| class=" " | 34
 
−
| class="sshl_f" | 9Space
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row6
 
−
| class=" " | 6
 
−
| class=" " | 5
 
−
| class="    SelectTD1 ChangeBGColor SelectTD1" |
 
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
−
| class=" " |
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
==Related Videos==
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
−
 
 
−
If the Number &lt; 0, SAMPLING returns the #ERROR.
 
−
 
 
−
SAMPLING returns the #ERROR, lengthof Array &lt; Number.
 
−
 
 
−
</div>
 
−
----
 
−
<div id="6SpaceContent" class="zcontent" align="left">
 
−
 
 
−
'''SAMPLING'''(Array, Method, Number, NewTableFlag)
 
  
−
where,
+
{{#ev:youtube|zsMaVcLxDZs|280|center|SAMPLING}}
  
−
'''Array '''- Input range should be one block.
+
==See Also==
  
−
'''Method '''- Either Random or Periodic.By default set as Random.
+
*[[Manuals/calci/HYPGEOMDIST| HYPGEOMDIST]]
  
−
'''Number '''- represents the number of samples.
+
==References==
 +
*[http://en.wikipedia.org/wiki/Sampling_%28statistics%29 Sampling]
  
−
'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
 
  
−
</div>
 
−
----
 
−
<div id="5SpaceContent" class="zcontent" align="left">
 
  
−
{| class="SpreadSheet blue"
+
*[[Z_API_Functions | List of Main Z Functions]]
−
|+ <br />Sampling
 
−
|- class="even"
 
−
! Input
 
−
! Output
 
−
|- class="odd"
 
−
| 1
 
−
| 17
 
−
|- class="even"
 
−
| 7
 
−
| 12
 
−
|- class="odd"
 
−
| 12
 
−
| 7
 
−
|- class="even"
 
−
| 17
 
−
|
 
−
|- class="odd"
 
−
| 37
 
−
|
 
−
|- class="even"
 
−
| 6
 
−
|
 
−
|}
 
−
 
 
−
</div>
 
−
----
 
−
<div id="9SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| class="SpreadSheet blue"
 
−
|+ <br />Sampling
 
−
|- class="even"
 
−
! Input
 
−
! Output
 
−
|- class="odd"
 
−
| 3
 
−
| 8
 
−
|- class="even"
 
−
| 8
 
−
| 5
 
−
|- class="odd"
 
−
| 8
 
−
|
 
−
|- class="even"
 
−
| 18
 
−
|
 
−
|- class="odd"
 
−
| 34
 
−
|
 
−
|- class="even"
 
−
| 5
 
−
|
 
−
|}
 
  
−
</div>
+
*[[ 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 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 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"