summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2021-06-09 11:47:25 -0300
committerEike Rathke <erack@redhat.com>2021-06-10 14:01:58 +0200
commitfded06f95f73fd0bfb27d861843c2f317db83d29 (patch)
tree7bfbe051dd41688cb64bf80b630d5bd6d627bdb6
parentThisDatabaseDocument new help page (diff)
downloadhelp-fded06f95f73fd0bfb27d861843c2f317db83d29.tar.gz
help-fded06f95f73fd0bfb27d861843c2f317db83d29.zip
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 <erack@redhat.com>
-rw-r--r--source/text/scalc/01/statistics_sampling.xhp18
1 files changed, 13 insertions, 5 deletions
diff --git a/source/text/scalc/01/statistics_sampling.xhp b/source/text/scalc/01/statistics_sampling.xhp
index 219efe184..753f70cb7 100644
--- a/source/text/scalc/01/statistics_sampling.xhp
+++ b/source/text/scalc/01/statistics_sampling.xhp
@@ -29,13 +29,21 @@
<section id="howtoget">
<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Sampling</menuitem></variable></paragraph>
</section>
-<paragraph id="par_id1000050" role="paragraph" xml-lang="en-US">Sampling allows you to pick data from a <emph>source</emph> table to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis.</paragraph>
+<paragraph id="par_id1000050" role="paragraph" xml-lang="en-US">Sampling allows you to pick data from a <emph>source</emph> table (population) to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis, as well as with or without sample replacement in the source table.</paragraph>
<note id="par_id1000060">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.</note><embed href="text/scalc/01/stat_data.xhp#data"/>
<h2 id="hd_id1000030">Sampling Method</h2>
-<paragraph id="par_id1000070" role="paragraph" xml-lang="en-US"><emph>Random</emph>: Picks exactly <emph>Sample Size</emph> lines of the source table in a random way.</paragraph>
-<paragraph id="par_id1000080" role="paragraph" xml-lang="en-US"><emph>Sample size</emph>: Number of lines sampled from the source table.</paragraph>
-<paragraph id="par_id1000090" role="paragraph" xml-lang="en-US"><emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>.</paragraph>
-<paragraph id="par_id1000100" role="paragraph" xml-lang="en-US"><emph>Period</emph>: the number of lines to skip periodically when sampling.</paragraph>
+<h3 id="hd_id611623249550632">Random</h3>
+<paragraph role="paragraph" id="par_id711623249563655">Picks exactly <emph>Sample Size</emph> lines of the source table in a random way.</paragraph>
+<h3 id="hd_id431623249579089">Sample size</h3>
+<paragraph role="paragraph" id="par_id461623249594879">Number of lines sampled from the source table. The Sample size is limited to the population size for all sampling methods without replacement.</paragraph>
+<h3 id="hd_id931623249610097">With replacement</h3>
+<paragraph role="paragraph" id="par_id191623249619384">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 <emph>Keep order</emph>. When unchecked, a sample drawn is not put back to the population and sample size is limited to population size.</paragraph>
+<h3 id="hd_id791623249632175">Keep order</h3>
+<paragraph role="paragraph" id="par_id741623249641180">When checked, samples are drawn in order of population data. Samples are not put back to the population (exclusive with <emph>With replacement</emph>). This option is automatically checked for <emph>Periodic</emph> sampling. When unchecked, samples are drawn in random order.</paragraph>
+<h3 id="hd_id461623249656476">Periodic</h3>
+<paragraph role="paragraph" id="par_id481623249667345">Picks lines in a pace defined by <emph>Period</emph>.</paragraph>
+<h3 id="hd_id101623249682605">Period</h3>
+<paragraph role="paragraph" id="par_id621623249692296">The number of lines to skip periodically when sampling. The <emph>Period</emph> is limited to the population size.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id1000110" role="paragraph" xml-lang="en-US">The following data will be used as example of source data table for sampling:</paragraph>
<table id="Tabela1">