From fded06f95f73fd0bfb27d861843c2f317db83d29 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Wed, 9 Jun 2021 11:47:25 -0300 Subject: tdf#132906 Update Sampling statistics dialog Change-Id: Ibe4132cfb80455dfc3338b17155bf449aad6e840 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116925 Tested-by: Jenkins Reviewed-by: Eike Rathke --- source/text/scalc/01/statistics_sampling.xhp | 18 +++++++++++++----- 1 file changed, 13 insertions(+), 5 deletions(-) diff --git a/source/text/scalc/01/statistics_sampling.xhp b/source/text/scalc/01/statistics_sampling.xhp index 219efe1844..753f70cb7c 100644 --- a/source/text/scalc/01/statistics_sampling.xhp +++ b/source/text/scalc/01/statistics_sampling.xhp @@ -29,13 +29,21 @@
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 allows you to pick data from a source table (population) to fill a target table. The sampling can be random or in a periodic basis, as well as with or without sample replacement in the source table. 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. +

Random

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

Sample size

+Number of lines sampled from the source table. The Sample size is limited to the population size for all sampling methods without replacement. +

With replacement

+When checked, put back samples in population (source table) after draw. A sample can be drawn more than once and therefore a larger sample size than population is possible. This option is mutually exclusive with Keep order. When unchecked, a sample drawn is not put back to the population and sample size is limited to population size. +

Keep order

+When checked, samples are drawn in order of population data. Samples are not put back to the population (exclusive with With replacement). This option is automatically checked for Periodic sampling. When unchecked, samples are drawn in random order. +

Periodic

+Picks lines in a pace defined by Period. +

Period

+The number of lines to skip periodically when sampling. The Period is limited to the population size. The following data will be used as example of source data table for sampling: -- cgit