Sampling

Create a table with data sampled from another table.

To access this command...

Choose Data - Statistics - Sampling


Sampling allows you to pick data from a source table to fill a target table. The sampling can be random or in a periodic basis.

note

Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table.


Data

Input Range: The reference of the range of the data to analyze.

Results to: The reference of the top left cell of the range where the results will be displayed.

Sampling Method

Random: Picks exactly Sample Size lines of the source table in a random way.

Sample size: Number of lines sampled from the source table.

Periodic: Picks lines in a pace defined by Period.

Period: the number of lines to skip periodically when sampling.

Example

The following data will be used as example of source data table for sampling:

A

B

C

1

11

21

31

2

12

22

32

3

13

23

33

4

14

24

34

5

15

25

35

6

16

26

36

7

17

27

37

8

18

28

38

9

19

29

39


Sampling with a period of 2 will result in the following table:

12

22

32

14

24

34

16

26

36

18

28

38


Please support us!