Data Sampling in Calc /text/scalc/01/statistics_sampling.xhp Analysis toolpack;sampling sampling;Analysis toolpack Data statistics;sampling

Sampling

Create a table with data sampled from another table.
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. 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.

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