Data Sampling in Calc

Edukiak
Indizea 🔎︎

# Sampling

Create a table with data sampled from another table.

Komando hau erabiltzeko...

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.

### Datuak

Sarrera-barrutia: Analizatuko den datu-barrutiaren erreferentzia.

Emaitzak hemen:: Emaitzak bistaratzeko erabiliko den barrutiaren goi ezkerreko gelaxkaren erreferentzia.

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

#### Adibidea

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

Erlazionatutako gaiak

Sampling

Estatistika deskribatzailea

Bariantza-analisia (ANOVA)

Korrelazioa

Kobariantza

Exponential Smoothing

Batezbesteko higikorra

Regression Analysis

Paired t-test

F-test

Z-testa

Chi-square test

Fourier Analysis