summaryrefslogtreecommitdiffstats
path: root/source/text/scalc/01/statistics_sampling.xhp
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2020-03-20 16:32:20 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2020-03-20 20:35:16 +0100
commite1032e5082161441a37473e22582f6eb6938c102 (patch)
tree2afbd43fd8e160a7b7096646924453c46f8361c9 /source/text/scalc/01/statistics_sampling.xhp
parentReview, refactor Calc Data Menu Help pages (diff)
downloadhelp-e1032e5082161441a37473e22582f6eb6938c102.tar.gz
help-e1032e5082161441a37473e22582f6eb6938c102.zip
Refactor Data analysis Calc help page
Comply with menu Data > Statistics Change-Id: I06a5ed00ef162064ea2768f3040511e599993c3f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90837 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/statistics_sampling.xhp')
-rw-r--r--source/text/scalc/01/statistics_sampling.xhp234
1 files changed, 234 insertions, 0 deletions
diff --git a/source/text/scalc/01/statistics_sampling.xhp b/source/text/scalc/01/statistics_sampling.xhp
new file mode 100644
index 0000000000..219efe1844
--- /dev/null
+++ b/source/text/scalc/01/statistics_sampling.xhp
@@ -0,0 +1,234 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ -->
+
+<meta>
+<topic id="datasampligtopic" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Data Sampling in Calc</title>
+<filename>/text/scalc/01/statistics_sampling.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id2764278">
+<bookmark_value>Analysis toolpack;sampling</bookmark_value>
+<bookmark_value>sampling;Analysis toolpack</bookmark_value>
+<bookmark_value>Data statistics;sampling</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/SamplingDialog" id="bm_id2745673" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/@@nowidget@@" id="bm_id2745673" localize="false"/>
+<section id="datasampling">
+<h1 id="hd_id1000020"><variable id="datasamplingh1"><link href="text/scalc/01/statistics_sampling.xhp" name="Sampling">Sampling</link></variable></h1>
+<paragraph id="par_id1000030" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/samplingdialog/SamplingDialog">Create a table with data sampled from another table.</ahelp></paragraph>
+</section>
+<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>
+<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>
+<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">
+<tablerow>
+<tablecell>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000120" role="tablehead" xml-lang="en-US" localize="false">A</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000130" role="tablehead" xml-lang="en-US" localize="false">B</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000140" role="tablehead" xml-lang="en-US" localize="false">C</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000150" role="tablehead" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000160" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000170" role="tablecontent" xml-lang="en-US" localize="false">21</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000180" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000190" role="tablehead" xml-lang="en-US" localize="false">2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000200" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000210" role="tablecontent" xml-lang="en-US" localize="false">22</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000220" role="tablecontent" xml-lang="en-US" localize="false">32</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000230" role="tablehead" xml-lang="en-US" localize="false">3</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000240" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000250" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000260" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000270" role="tablehead" xml-lang="en-US" localize="false">4</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000280" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000290" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000300" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000310" role="tablehead" xml-lang="en-US" localize="false">5</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000320" role="tablecontent" xml-lang="en-US" localize="false">15</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000330" role="tablecontent" xml-lang="en-US" localize="false">25</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000340" role="tablecontent" xml-lang="en-US" localize="false">35</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000350" role="tablehead" xml-lang="en-US" localize="false">6</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000360" role="tablecontent" xml-lang="en-US" localize="false">16</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000370" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000380" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000390" role="tablehead" xml-lang="en-US" localize="false">7</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000400" role="tablecontent" xml-lang="en-US" localize="false">17</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000410" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000420" role="tablecontent" xml-lang="en-US" localize="false">37</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000430" role="tablehead" xml-lang="en-US" localize="false">8</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000440" role="tablecontent" xml-lang="en-US" localize="false">18</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000450" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000460" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000470" role="tablehead" xml-lang="en-US" localize="false">9</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000480" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000490" role="tablecontent" xml-lang="en-US" localize="false">29</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000500" role="tablecontent" xml-lang="en-US" localize="false">39</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+<paragraph id="par_id1000510" role="paragraph" xml-lang="en-US">Sampling with a period of 2 will result in the following table:</paragraph>
+<table id="Tabela2">
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000520" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000530" role="tablecontent" xml-lang="en-US" localize="false">22</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000540" role="tablecontent" xml-lang="en-US" localize="false">32</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000550" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000560" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000570" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000580" role="tablecontent" xml-lang="en-US" localize="false">16</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000590" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000600" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000610" role="tablecontent" xml-lang="en-US" localize="false">18</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000620" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000630" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph>
+</tablecell>
+</tablerow>
+</table>
+<section id="relatedtopics">
+<embed href="text/scalc/01/stat_data.xhp#otherstat"/>
+</section>
+</body>
+</helpdocument>