[Libreoffice-commits] help.git: source/text
Olivier Hallot
olivier.hallot at edx.srv.br
Mon Mar 2 01:25:46 PST 2015
source/text/scalc/01/stat_data.xhp | 906 ++++++----
source/text/scalc/01/statistics.xhp | 3182 +++++++++++++++++++-----------------
2 files changed, 2223 insertions(+), 1865 deletions(-)
New commits:
commit 4bbc71ec42073ade5e64e65acf8700d6041ebf49
Author: Olivier Hallot <olivier.hallot at edx.srv.br>
Date: Sun Mar 1 23:21:48 2015 -0300
Help page for all statistics functions of Calc
* rewrite introduction of the the functions
* add Z-test and Chi-square test help text
Change-Id: I70d720c75fcaec896d8e2a86cca3689cc43763b6
Reviewed-on: https://gerrit.libreoffice.org/14701
Tested-by: David Tardon <dtardon at redhat.com>
Reviewed-by: David Tardon <dtardon at redhat.com>
diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp
index 7bd2bf3..7b70738 100644
--- a/source/text/scalc/01/stat_data.xhp
+++ b/source/text/scalc/01/stat_data.xhp
@@ -1,4 +1,5 @@
-<?xml version="1.0" encoding="UTF-8"?>
+<?xml version="1.0"?>
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -16,371 +17,538 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-<helpdocument version="1.0">
- <body>
- <section id="data">
- <paragraph id="hd_id200820141553364965" role="heading" xml-lang="en-US" level="3">Data</paragraph>
- <paragraph id="par_id2008201415533682345" role="paragraph" xml-lang="en-US"><emph>Input Range</emph>: The reference of the range of the data to analyze.</paragraph>
- <paragraph id="par_id2008201415533690271" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the results will be displayed.</paragraph>
- </section>
- <section id="grouped">
- <paragraph id="hd_id2008201415533630182" role="heading" xml-lang="en-US" level="3">Grouped By</paragraph>
- <paragraph id="par_id2008201415533694478" role="paragraph" xml-lang="en-US">Select whether the input data has <emph>columns</emph> or <emph>rows</emph> layout.</paragraph>
- </section>
- <section id="sampledata01">
- <paragraph id="hd_id2008201415533366360" role="heading" xml-lang="en-US" level="3">Example</paragraph>
- <paragraph id="par_id2008201415533343874" role="paragraph" xml-lang="en-US">The following data will be used as example </paragraph>
- <table id="Tabela3">
- <tablerow>
- <tablecell>
-</tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533312589" role="tablehead" xml-lang="en-US" localize="false">A</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533338155" role="tablehead" xml-lang="en-US" localize="false">B</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533321020" role="tablehead" xml-lang="en-US" localize="false">C</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533376551" role="tablehead" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553335121" role="tablehead" xml-lang="en-US">Maths</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533379519" role="tablehead" xml-lang="en-US">Physics</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553333644" role="tablehead" xml-lang="en-US">Biology</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533318687" role="tablehead" xml-lang="en-US" localize="false">2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533340873" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533348976" role="tablecontent" xml-lang="en-US" localize="false">67</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533345798" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533344558" role="tablehead" xml-lang="en-US" localize="false">3</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533348756" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533364631" role="tablecontent" xml-lang="en-US" localize="false">68</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533379397" role="tablecontent" xml-lang="en-US" localize="false">42</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533370936" role="tablehead" xml-lang="en-US" localize="false">4</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533392087" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533375468" role="tablecontent" xml-lang="en-US" localize="false">65</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533380753" role="tablecontent" xml-lang="en-US" localize="false">44</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533327602" role="tablehead" xml-lang="en-US" localize="false">5</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533370577" role="tablecontent" xml-lang="en-US" localize="false">39</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533367970" role="tablecontent" xml-lang="en-US" localize="false">64</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id20082014155334281" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533465509" role="tablehead" xml-lang="en-US" localize="false">6</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533471070" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533416261" role="tablecontent" xml-lang="en-US" localize="false">43</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533464396" role="tablehead" xml-lang="en-US" localize="false">7</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533411899" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533445603" role="tablecontent" xml-lang="en-US" localize="false">84</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533449836" role="tablecontent" xml-lang="en-US" localize="false">62</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533477391" role="tablehead" xml-lang="en-US" localize="false">8</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533495974" role="tablecontent" xml-lang="en-US" localize="false">29</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533457375" role="tablecontent" xml-lang="en-US" localize="false">80</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533434038" role="tablecontent" xml-lang="en-US" localize="false">51</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533487675" role="tablehead" xml-lang="en-US" localize="false">9</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008101415533458526" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533480817" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533422381" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id200820141553341777" role="tablehead" xml-lang="en-US" localize="false">10</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533475126" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533482124" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533425509" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533482084" role="tablehead" xml-lang="en-US" localize="false">11</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533450595" role="tablecontent" xml-lang="en-US" localize="false">56</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533494007" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533469907" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533441266" role="tablehead" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533489090" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533442316" role="tablehead" xml-lang="en-US" localize="false">13</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533495929" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- </table>
- </section>
- <section id="timeseries01">
- <paragraph id="hd_id2008201415533624784" role="heading" xml-lang="en-US" level="3">Example</paragraph>
- <paragraph id="par_id2008201415533648925" role="paragraph" xml-lang="en-US">The following table has two time series, one representing an impulse function at time t=0 and the other an impulse function at time t=2.</paragraph>
- <table id="Tabela8">
- <tablerow>
- <tablecell>
-</tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533654405" role="tablehead" xml-lang="en-US">A</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533633771" role="tablehead" xml-lang="en-US">B</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533688772" role="tablehead" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533690005" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533634383" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533636924" role="tablehead" xml-lang="en-US" localize="false">2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553363326" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533611120" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533616287" role="tablehead" xml-lang="en-US" localize="false">3</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533678025" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533687736" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533638973" role="tablehead" xml-lang="en-US" localize="false">4</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533621030" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533624169" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533727275" role="tablehead" xml-lang="en-US" localize="false">5</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533740391" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533749244" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id200820141553379645" role="tablehead" xml-lang="en-US" localize="false">6</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533722341" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533713197" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533749030" role="tablehead" xml-lang="en-US" localize="false">7</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533794205" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533795494" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533795613" role="tablehead" xml-lang="en-US" localize="false">8</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533765196" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533757520" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533775750" role="tablehead" xml-lang="en-US" localize="false">9</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553375977" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533743524" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533723477" role="tablehead" xml-lang="en-US" localize="false">10</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533755288" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533735315" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id200820141553375315" role="tablehead" xml-lang="en-US" localize="false">11</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533782119" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533732251" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id200820141553371540" role="tablehead" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533740498" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553374302" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533790843" role="tablehead" xml-lang="en-US" localize="false">13</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533716899" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533780913" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- </table>
- </section>
- </body>
-</helpdocument>
+
+<meta>
+<topic id="ID" indexer="Indexer">
+<title xml-lang="en-US" id="tit">Data</title>
+<filename>file:///home/tdf/git/core/helpcontent2/source/text/scalc/01/stat_data.xhp</filename>
+</topic>
+</meta>
+<body>
+<section id="data">
+<paragraph id="hd_id1000010" role="heading" xml-lang="en-US" level="3">Data</paragraph>
+<paragraph id="par_id1000010" role="paragraph" xml-lang="en-US"><emph>Input Range</emph>: The reference of the range of the data to analyze.</paragraph>
+<paragraph id="par_id1000020" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the results will be displayed.</paragraph>
+</section>
+<section id="grouped">
+<paragraph id="hd_id1000020" role="heading" xml-lang="en-US" level="3">Grouped By</paragraph>
+<paragraph id="par_id1000030" role="paragraph" xml-lang="en-US">Select whether the input data has <emph>columns</emph> or <emph>rows</emph> layout.</paragraph>
+</section>
+<section id="sampledata01">
+<paragraph id="hd_id1000030" role="heading" xml-lang="en-US" level="3">Example</paragraph>
+<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US">The following data will be used as example </paragraph>
+<table id="Tabela3">
+<tablerow>
+<tablecell>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000050" role="tablehead" xml-lang="en-US" localize="false">A</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000060" role="tablehead" xml-lang="en-US" localize="false">B</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000070" role="tablehead" xml-lang="en-US" localize="false">C</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000080" role="tablehead" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000090" role="tablehead" xml-lang="en-US">Maths</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000100" role="tablehead" xml-lang="en-US">Physics</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000110" role="tablehead" xml-lang="en-US">Biology</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000120" role="tablehead" xml-lang="en-US" localize="false">2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000130" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000140" role="tablecontent" xml-lang="en-US" localize="false">67</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000150" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000160" role="tablehead" xml-lang="en-US" localize="false">3</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000170" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000180" role="tablecontent" xml-lang="en-US" localize="false">68</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000190" role="tablecontent" xml-lang="en-US" localize="false">42</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000200" role="tablehead" xml-lang="en-US" localize="false">4</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000210" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000220" role="tablecontent" xml-lang="en-US" localize="false">65</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000230" role="tablecontent" xml-lang="en-US" localize="false">44</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000240" role="tablehead" xml-lang="en-US" localize="false">5</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000250" role="tablecontent" xml-lang="en-US" localize="false">39</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000260" role="tablecontent" xml-lang="en-US" localize="false">64</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000270" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000280" role="tablehead" xml-lang="en-US" localize="false">6</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000290" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000300" role="tablecontent" xml-lang="en-US" localize="false">43</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000310" role="tablehead" xml-lang="en-US" localize="false">7</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000320" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000330" role="tablecontent" xml-lang="en-US" localize="false">84</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000340" role="tablecontent" xml-lang="en-US" localize="false">62</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000350" role="tablehead" xml-lang="en-US" localize="false">8</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000360" role="tablecontent" xml-lang="en-US" localize="false">29</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000370" role="tablecontent" xml-lang="en-US" localize="false">80</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000380" role="tablecontent" xml-lang="en-US" localize="false">51</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000390" role="tablehead" xml-lang="en-US" localize="false">9</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000400" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000410" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000420" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000430" role="tablehead" xml-lang="en-US" localize="false">10</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000440" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000450" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000460" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000470" role="tablehead" xml-lang="en-US" localize="false">11</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000480" role="tablecontent" xml-lang="en-US" localize="false">56</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000490" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000500" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000510" role="tablehead" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000520" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000530" role="tablehead" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000540" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+</table>
+</section>
+<section id="timeseries01">
+<paragraph id="hd_id1000040" role="heading" xml-lang="en-US" level="3">Example</paragraph>
+<paragraph id="par_id1000550" role="paragraph" xml-lang="en-US">The following table has two time series, one representing an impulse function at time t=0 and the other an impulse function at time t=2.</paragraph>
+<table id="Tabela8">
+<tablerow>
+<tablecell>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000560" role="tablehead" xml-lang="en-US" localize="false">A</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000570" role="tablehead" xml-lang="en-US" localize="false">B</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000580" role="tablehead" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000590" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000600" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000610" role="tablehead" xml-lang="en-US" localize="false">2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000620" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000630" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000640" role="tablehead" xml-lang="en-US" localize="false">3</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000650" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000660" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000670" role="tablehead" xml-lang="en-US" localize="false">4</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000680" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000690" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000700" role="tablehead" xml-lang="en-US" localize="false">5</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000710" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000720" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000730" role="tablehead" xml-lang="en-US" localize="false">6</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000740" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000750" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000760" role="tablehead" xml-lang="en-US" localize="false">7</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000770" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000780" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000790" role="tablehead" xml-lang="en-US" localize="false">8</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000800" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000810" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000820" role="tablehead" xml-lang="en-US" localize="false">9</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000830" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000840" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000850" role="tablehead" xml-lang="en-US" localize="false">10</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000860" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000870" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000880" role="tablehead" xml-lang="en-US" localize="false">11</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000890" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000900" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000910" role="tablehead" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000920" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000930" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000940" role="tablehead" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000950" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000960" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="datafortests">
+<paragraph id="hd_id1000050" role="heading" xml-lang="en-US" level="3">Example</paragraph>
+<paragraph id="par_id1000970" role="paragraph" xml-lang="en-US">The following table has two data sets.</paragraph>
+<table id="Tabela9">
+<tablerow>
+<tablecell>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000980" role="tablehead" xml-lang="en-US" localize="false">A</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000990" role="tablehead" xml-lang="en-US" localize="false">B</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001000" role="tablehead" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001010" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001020" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001030" role="tablehead" xml-lang="en-US" localize="false">2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001040" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001050" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001060" role="tablehead" xml-lang="en-US" localize="false">3</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001070" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001080" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001090" role="tablehead" xml-lang="en-US" localize="false">4</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001100" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001110" role="tablecontent" xml-lang="en-US" localize="false">5</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001120" role="tablehead" xml-lang="en-US" localize="false">5</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001130" role="tablecontent" xml-lang="en-US" localize="false">20</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001140" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001150" role="tablehead" xml-lang="en-US" localize="false">6</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001160" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001170" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001180" role="tablehead" xml-lang="en-US" localize="false">7</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001190" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001200" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001210" role="tablehead" xml-lang="en-US" localize="false">8</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001220" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001230" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001240" role="tablehead" xml-lang="en-US" localize="false">9</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001250" role="tablecontent" xml-lang="en-US" localize="false">4</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001260" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001270" role="tablehead" xml-lang="en-US" localize="false">10</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001280" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001290" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001300" role="tablehead" xml-lang="en-US" localize="false">11</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001310" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001320" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001330" role="tablehead" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001340" role="tablecontent" xml-lang="en-US" localize="false">8</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001350" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001360" role="tablehead" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001370" role="tablecontent" xml-lang="en-US" localize="false">9</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001380" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+</body>
+</helpdocument>
\ No newline at end of file
diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp
index 710ffac..c6f6470 100644
--- a/source/text/scalc/01/statistics.xhp
+++ b/source/text/scalc/01/statistics.xhp
@@ -1,4 +1,5 @@
-<?xml version="1.0" encoding="UTF-8"?>
+<?xml version="1.0"?>
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -16,1498 +17,1687 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-<helpdocument version="1.0">
- <meta>
- <topic id="statistics" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Data Statistics in Calc</title>
- <filename>/text/scalc/01/statistics.xhp</filename>
- </topic>
- </meta>
- <body>
- <paragraph role="heading" id="hd_id1" xml-lang="en-US" level="1" l10n="U" oldref="1">Data Statistics in Calc</paragraph>
- <paragraph id="par_id2008201415533013547" role="paragraph" xml-lang="en-US">Use the data statistics in Calc to perform complex data analysis</paragraph>
- <paragraph id="par_id2008201415533090579" role="paragraph" xml-lang="en-US">To work on a complex statistical or engineering analysis,
- you can save steps and time by using Calc Data Statistics. You provide the data and parameters for each analysis, and the set of tools
- uses the appropriate statistical or engineering functions to calculate and display the results in an output table.</paragraph>
- <section id="datasampling">
- <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"/>
- <paragraph id="hd_id2008201415533083500" role="heading" xml-lang="en-US" level="2">Sampling</paragraph>
- <paragraph role="paragraph" id="par_id2756327" xml-lang="en-US" l10n="U" oldref="2">
- <ahelp hid="modules/scalc/ui/samplingdialog/SamplingDialog">Create a table with data sampled from another table.</ahelp>
- </paragraph>
- <section id="howtoget">
- <paragraph role="paragraph" id="par_id2752992" xml-lang="en-US" l10n="U" oldref="26">
- <variable id="sam01">Menu <emph>Data - Statistics - Sampling...</emph></variable>
- </paragraph>
- </section>
- <paragraph id="par_id2008201415533091337" 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_id2008201415533022103" role="note" xml-lang="en-US">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.</paragraph>
- <embed href="text/scalc/01/stat_data.xhp#data"/>
- <paragraph id="hd_id2008201415533154722" role="heading" xml-lang="en-US" level="3">Sampling Method</paragraph>
- <paragraph id="par_id2008201415533127849" 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_id2008201415533118838" role="paragraph" xml-lang="en-US"><emph>Sample size</emph>: Number of lines sampled from the source table.</paragraph>
- <paragraph id="par_id2008201415533154688" role="paragraph" xml-lang="en-US"><emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>.</paragraph>
- <paragraph id="par_id2008201415533199288" role="paragraph" xml-lang="en-US"><emph>Period</emph>: the number of lines to skip periodically when sampling.</paragraph>
- <paragraph id="hd_id2008201415533195750" role="heading" xml-lang="en-US" level="3">Example</paragraph>
- <paragraph id="par_id2008201415533199646" role="paragraph" xml-lang="en-US">The following data will be used as example of source data table for sampling:</paragraph>
- <table id="Tabela1" localize="false">
- <tablerow>
- <tablecell colspan="" rowspan="">
-</tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533296488" role="tablehead" xml-lang="en-US" localize="false">A</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533296769" role="tablehead" xml-lang="en-US" localize="false">B</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533215761" role="tablehead" xml-lang="en-US" localize="false">C</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533372583" role="tablehead" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533397059" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533398110" role="tablecontent" xml-lang="en-US" localize="false">21</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533395716" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533310986" role="tablehead" xml-lang="en-US" localize="false">2</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533348537" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533379810" role="tablecontent" xml-lang="en-US" localize="false">22</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533380028" role="tablecontent" xml-lang="en-US" localize="false">32</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533329702" role="tablehead" xml-lang="en-US" localize="false">3</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533314188" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id20082014155333478" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533342176" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533311246" role="tablehead" xml-lang="en-US" localize="false">4</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533391573" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533363976" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533379220" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533387843" role="tablehead" xml-lang="en-US" localize="false">5</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533395949" role="tablecontent" xml-lang="en-US" localize="false">15</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533350366" role="tablecontent" xml-lang="en-US" localize="false">25</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533365574" role="tablecontent" xml-lang="en-US" localize="false">35</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533379792" role="tablehead" xml-lang="en-US" localize="false">6</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id200820141553333571" role="tablecontent" xml-lang="en-US" localize="false">16</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533336129" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533384912" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533321192" role="tablehead" xml-lang="en-US" localize="false">7</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533393399" role="tablecontent" xml-lang="en-US" localize="false">17</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533368135" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533367873" role="tablecontent" xml-lang="en-US" localize="false">37</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533339873" role="tablehead" xml-lang="en-US" localize="false">8</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533375774" role="tablecontent" xml-lang="en-US" localize="false">18</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533374064" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533374313" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533347475" role="tablehead" xml-lang="en-US" localize="false">9</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533339222" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533342208" role="tablecontent" xml-lang="en-US" localize="false">29</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533365547" role="tablecontent" xml-lang="en-US" localize="false">39</paragraph>
- </tablecell>
- </tablerow>
- </table>
- <paragraph id="par_id2008201415533317386" role="paragraph" xml-lang="en-US">Sampling with a period of 2 will result in the following table:</paragraph>
- <table id="Tabela2">
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533317118" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533330191" role="tablecontent" xml-lang="en-US" localize="false">22</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533370604" role="tablecontent" xml-lang="en-US" localize="false">32</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533379727" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id200820141553333183" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533331655" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533327692" role="tablecontent" xml-lang="en-US" localize="false">16</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533387242" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id200820141553334617" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533314911" role="tablecontent" xml-lang="en-US" localize="false">18</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id200820141553339713" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533399406" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph>
- </tablecell>
- </tablerow>
- </table>
- </section>
- <section id="descriptivestatistics">
- <bookmark xml-lang="en-US" branch="index" id="bm_id01001">
- <bookmark_value>Analysis toolpack;descriptive statistics</bookmark_value>
- <bookmark_value>descriptive statistics;Analysis toolpack</bookmark_value>
- <bookmark_value>Data statistics;descriptive statistics</bookmark_value>
- </bookmark>
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog" id="bm_id01002" localize="false"/>
- <paragraph role="heading" id="hd_id01003" xml-lang="en-US" level="2" l10n="U" oldref="1">Descriptive Statistics</paragraph>
- <paragraph role="paragraph" id="par_id01004" xml-lang="en-US" l10n="U" oldref="2">
- <ahelp hid="modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog">Fill a table in the spreadsheet with the main statistical properties of the data set.</ahelp>
- </paragraph>
- <section id="howtoget">
- <paragraph role="paragraph" id="par_id01005" xml-lang="en-US" l10n="U" oldref="26">
- <variable id="sam01">Menu <emph>Data - Statistics - Descriptive Statistics...</emph></variable>
- </paragraph>
- </section>
- <paragraph id="par_id2008201415533312518" role="paragraph" xml-lang="en-US">The Descriptive Statistics analysis tool generates a report of univariate statistics for data in the input range, providing information about the central tendency and variability of your data.</paragraph>
- <paragraph id="par_id2008201423333515443" role="note" xml-lang="en-US">For more information, please visit the Wikipedia: <link href="http://en.wikipedia.org/wiki/Descriptive_statistics">http://en.wikipedia.org/wiki/Descriptive_statistics</link></paragraph>
- <embed href="text/scalc/01/stat_data.xhp#data"/>
- <embed href="text/scalc/01/stat_data.xhp#grouped"/>
- <embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
- <paragraph id="par_id2008201415533458095" role="paragraph" xml-lang="en-US">The following table displays the results of the descriptive statistics of the sample data above.</paragraph>
- <table id="Tabela4">
- <tablerow>
- <tablecell colspan="" rowspan="">
-</tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533454721" role="tablehead" xml-lang="en-US">Column 1</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533415805" role="tablehead" xml-lang="en-US">Column 2</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533413862" role="tablehead" xml-lang="en-US">Column 3</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533476173" role="tablehead" xml-lang="en-US">Mean</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533414929" role="tablecontent" xml-lang="en-US" localize="false">41.9090909091</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533423015" role="tablecontent" xml-lang="en-US" localize="false">59.7</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533425750" role="tablecontent" xml-lang="en-US" localize="false">44.7</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533480973" role="tablehead" xml-lang="en-US">Standard Error</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533484071" role="tablecontent" xml-lang="en-US" localize="false">3.5610380138</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533498852" role="tablecontent" xml-lang="en-US" localize="false">5.3583786934</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533425428" role="tablecontent" xml-lang="en-US" localize="false">4.7680650629</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533433244" role="tablehead" xml-lang="en-US">Mode</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533481428" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533429983" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533424352" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id200820141553341353" role="tablehead" xml-lang="en-US">Median</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533492926" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533421723" role="tablecontent" xml-lang="en-US" localize="false">64.5</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533434998" role="tablecontent" xml-lang="en-US" localize="false">43.5</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533490736" role="tablehead" xml-lang="en-US">Variance</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533419659" role="tablecontent" xml-lang="en-US" localize="false">139.4909090909</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533484846" role="tablecontent" xml-lang="en-US" localize="false">287.1222222222</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533425108" role="tablecontent" xml-lang="en-US" localize="false">227.3444444444</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533495501" role="tablehead" xml-lang="en-US">Standard Deviation</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533461604" role="tablecontent" xml-lang="en-US" localize="false">11.8106269559</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533477889" role="tablecontent" xml-lang="en-US" localize="false">16.944681237</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533447328" role="tablecontent" xml-lang="en-US" localize="false">15.0779456308</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533498745" role="tablehead" xml-lang="en-US">Kurtosis</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533435165" role="tablecontent" xml-lang="en-US" localize="false">-1.4621677981</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id200820141553346759" role="tablecontent" xml-lang="en-US" localize="false">-0.9415988746</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533483082" role="tablecontent" xml-lang="en-US" localize="false">1.418052719</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533479359" role="tablehead" xml-lang="en-US">Skewness</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533458526" role="tablecontent" xml-lang="en-US" localize="false">0.0152409533</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533459450" role="tablecontent" xml-lang="en-US" localize="false">-0.2226426904</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533454972" role="tablecontent" xml-lang="en-US" localize="false">-0.9766803373</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533473279" role="tablehead" xml-lang="en-US">Range</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533491719" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533469523" role="tablecontent" xml-lang="en-US" localize="false">51</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533428583" role="tablecontent" xml-lang="en-US" localize="false">50</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533467981" role="tablehead" xml-lang="en-US">Minimum</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533475720" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533439232" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533475372" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533456155" role="tablehead" xml-lang="en-US">Maximum</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533438044" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533420806" role="tablecontent" xml-lang="en-US" localize="false">84</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533456782" role="tablecontent" xml-lang="en-US" localize="false">62</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533452737" role="tablehead" xml-lang="en-US">Sum</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id200820141553347585" role="tablecontent" xml-lang="en-US" localize="false">461</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533440420" role="tablecontent" xml-lang="en-US" localize="false">597</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id200820141553345395" role="tablecontent" xml-lang="en-US" localize="false">447</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533535276" role="tablehead" xml-lang="en-US">Count</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533553079" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533559282" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
- </tablecell>
- <tablecell colspan="" rowspan="">
- <paragraph id="par_id2008201415533577916" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
- </tablecell>
- </tablerow>
- </table>
- </section>
- <section id="anova">
- <bookmark xml-lang="en-US" branch="index" id="bm_id02001">
- <bookmark_value>Analysis toolpack;analysis of variance</bookmark_value>
- <bookmark_value>analysis of variance;Analysis toolpack</bookmark_value>
- <bookmark_value>Data statistics;analysis of variance</bookmark_value>
- </bookmark>
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog" id="bm_id02002" localize="false"/>
- <paragraph role="heading" id="hd_id02003" xml-lang="en-US" level="2" l10n="U" oldref="1">Analysis of Variance (ANOVA)</paragraph>
- <paragraph role="paragraph" id="par_id02004" xml-lang="en-US" l10n="U" oldref="2">
- <ahelp hid="modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog">Produces the analysis of variance (ANOVA) of a given data set</ahelp>
- </paragraph>
- <section id="howtoget">
- <paragraph role="paragraph" id="par_id02005" xml-lang="en-US" l10n="U" oldref="26">
- <variable id="sam01">Menu <emph>Data - Statistics - Analysis of Variance (ANOVA)...</emph></variable>
- </paragraph>
- </section>
- <paragraph id="par_id2008201415533512990" role="paragraph" xml-lang="en-US">Analysis of variance (ANOVA) is a collection of statistical models used to analyze the differences between group means and their associated procedures (such as "variation" among and between groups). In the ANOVA setting, the observed variance in a particular variable is partitioned into components attributable to different sources of variation. In its simplest form, ANOVA provides a statistical test of whether or not the means of several groups are equal, and therefore generalizes the t-test to more than two groups. As doing multiple two-sample t-tests would result in an increased chance of committing a statistical type I error, ANOVAs are useful in comparing (testing) three or more means (groups or variables) for statistical significance.</paragraph>
- <paragraph id="par_id2008201415533515443" role="note" xml-lang="en-US">For more information, please visit the Wikipedia: <link href="http://en.wikipedia.org/wiki/ANOVA">http://en.wikipedia.org/wiki/ANOVA</link></paragraph>
- <embed href="text/scalc/01/stat_data.xhp#data"/>
- <embed href="text/scalc/01/stat_data.xhp#grouped"/>
- <paragraph id="hd_id2008201415533538729" role="heading" xml-lang="en-US" level="3">Type</paragraph>
- <paragraph id="par_id200820141553351190" role="paragraph" xml-lang="en-US">Select if the analysis is for a <emph>single factor</emph> or for <emph>two factor</emph> ANOVA.</paragraph>
- <paragraph id="hd_id2008201415533538856" role="heading" xml-lang="en-US" level="3">Parameters</paragraph>
- <paragraph id="par_id2008201415533516218" role="paragraph" xml-lang="en-US"><emph>Alpha</emph>: the level of significance of the test.</paragraph>
- <paragraph id="par_id2008201415533592749" role="paragraph" xml-lang="en-US"><emph>Rows per sample</emph>: Define how many rows a sample has.</paragraph>
- <embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
- <paragraph id="par_id2008201415533543611" role="paragraph" xml-lang="en-US">The following table displays the results of the <emph>analysis of variance (ANOVA)</emph> of the sample data above.</paragraph>
- <table id="Tabela5">
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533531121" role="tablehead" xml-lang="en-US">ANOVA - Single Factor</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533586267" role="tablecontent" xml-lang="en-US">Alpha</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533552853" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533562036" role="tablecontent" xml-lang="en-US">Groups</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533516564" role="tablecontent" xml-lang="en-US">Count</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533511954" role="tablecontent" xml-lang="en-US">Sum</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533560198" role="tablecontent" xml-lang="en-US">Mean</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533547195" role="tablecontent" xml-lang="en-US">Variance</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533526297" role="tablecontent" xml-lang="en-US">Column 1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533534021" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533565407" role="tablecontent" xml-lang="en-US" localize="false">461</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533552984" role="tablecontent" xml-lang="en-US" localize="false">41.9090909091</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533568921" role="tablecontent" xml-lang="en-US" localize="false">139.4909090909</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533571610" role="tablecontent" xml-lang="en-US">Column 2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533574815" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533598837" role="tablecontent" xml-lang="en-US" localize="false">597</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533545054" role="tablecontent" xml-lang="en-US" localize="false">59.7</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533572049" role="tablecontent" xml-lang="en-US" localize="false">287.1222222222</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id200820141553358382" role="tablecontent" xml-lang="en-US">Column 3</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533591257" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533522897" role="tablecontent" xml-lang="en-US" localize="false">447</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533550549" role="tablecontent" xml-lang="en-US" localize="false">44.7</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533591333" role="tablecontent" xml-lang="en-US" localize="false">227.3444444444</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533555826" role="tablecontent" xml-lang="en-US">Source of Variation</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533515237" role="tablecontent" xml-lang="en-US">SS</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533550319" role="tablecontent" xml-lang="en-US">df</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533582581" role="tablecontent" xml-lang="en-US">MS</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533546247" role="tablecontent" xml-lang="en-US">F</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533553834" role="tablecontent" xml-lang="en-US">P-value</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533554659" role="tablecontent" xml-lang="en-US">Between Groups</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533599613" role="tablecontent" xml-lang="en-US" localize="false">1876.5683284457</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533544758" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553357817" role="tablecontent" xml-lang="en-US" localize="false">938.2841642229</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533585445" role="tablecontent" xml-lang="en-US" localize="false">4.3604117704</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533544267" role="tablecontent" xml-lang="en-US" localize="false">0.0224614952</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533560423" role="tablecontent" xml-lang="en-US">Within Groups</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533510665" role="tablecontent" xml-lang="en-US" localize="false">6025.1090909091</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533549854" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533596189" role="tablecontent" xml-lang="en-US" localize="false">215.1824675325</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533597992" role="tablecontent" xml-lang="en-US">Total</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id20082014155335463" role="tablecontent" xml-lang="en-US" localize="false">7901.6774193548</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553353431" role="tablecontent" xml-lang="en-US" localize="false">30</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- </table>
- </section>
- <section id="correlation">
- <bookmark xml-lang="en-US" branch="index" id="bm_id1464278">
- <bookmark_value>Analysis toolpack;correlation</bookmark_value>
- <bookmark_value>correlation;Analysis toolpack</bookmark_value>
- <bookmark_value>Data statistics;correlation</bookmark_value>
- </bookmark>
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/CorrelationDialog" id="bm_id3145673" localize="false"/>
- <paragraph role="heading" id="hd_id3153032" xml-lang="en-US" level="2" l10n="U" oldref="1">Correlation</paragraph>
- <paragraph role="paragraph" id="par_id3156327" xml-lang="en-US" l10n="U" oldref="2">
- <ahelp hid="modules/scalc/ui/correlationdialog/CorrelationDialog">Calculates the correlation of two sets of numeric data.</ahelp>
- </paragraph>
- <section id="howtoget">
- <paragraph role="paragraph" id="par_id3152992" xml-lang="en-US" l10n="U" oldref="26">
- <variable id="corr01">Menu <emph>Data - Statistics - Correlation...</emph></variable>
- </paragraph>
- </section>
- <paragraph id="par_id2008201415533536318" role="paragraph" xml-lang="en-US">The correlation coefficient (a value between -1 and +1) means how strongly two variables are related to each other. You can use the CORREL function or the Data Statistics to find the correlation coefficient between two variables.</paragraph>
- <paragraph id="par_id2008201415533586869" role="paragraph" xml-lang="en-US">A correlation coefficient of +1 indicates a perfect positive correlation. </paragraph>
- <paragraph id="par_id2008201415533567951" role="paragraph" xml-lang="en-US">A correlation coefficient of -1 indicates a perfect negative correlation</paragraph>
- <paragraph id="par_id2008201415533654986" role="note" xml-lang="en-US">For more information on statistical correlation, refer to <link href="http://en.wikipedia.org/wiki/Correlation">http://en.wikipedia.org/wiki/Correlation</link></paragraph>
- <embed href="text/scalc/01/stat_data.xhp#data"/>
- <embed href="text/scalc/01/stat_data.xhp#grouped"/>
- <embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
- <paragraph id="par_id2008201415533680006" role="paragraph" xml-lang="en-US">The following table displays the results of the correlation of the sample data above.</paragraph>
- <table id="Tabela6">
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533666011" role="tablehead" xml-lang="en-US">Correlations</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533643141" role="tablehead" xml-lang="en-US">Column 1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533674994" role="tablehead" xml-lang="en-US">Column 2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533691064" role="tablehead" xml-lang="en-US">Column 3</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533613299" role="tablehead" xml-lang="en-US">Column 1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533618184" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533698236" role="tablehead" xml-lang="en-US">Column 2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533626380" role="tablecontent" xml-lang="en-US" localize="false">-0.4029254917</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553369535" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533614553" role="tablehead" xml-lang="en-US">Column 3</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533628267" role="tablecontent" xml-lang="en-US" localize="false">-0.2107642836</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533613606" role="tablecontent" xml-lang="en-US" localize="false">0.2309714048</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533680211" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- </tablerow>
- </table>
- </section>
- <section id="covariance">
- <bookmark xml-lang="en-US" branch="index" id="bm_id2964278">
- <bookmark_value>Analysis toolpack;covariance</bookmark_value>
- <bookmark_value>covariance;Analysis toolpack</bookmark_value>
- <bookmark_value>Data statistics;covariance</bookmark_value>
- </bookmark>
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/CovarianceDialog" id="bm_id2945673" localize="false"/>
- <paragraph role="heading" id="hd_id2953032" xml-lang="en-US" level="2" l10n="U" oldref="1">Covariance</paragraph>
- <paragraph role="paragraph" id="par_id2956327" xml-lang="en-US" l10n="U" oldref="2">
- <ahelp hid="modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the covariance of two sets of numeric data.</ahelp>
- </paragraph>
- <section id="howtoget">
- <paragraph role="paragraph" id="par_id2952992" xml-lang="en-US" l10n="U" oldref="26">
- <variable id="cov01">Menu <emph>Data - Statistics - Covariance...</emph></variable>
- </paragraph>
- </section>
- <paragraph id="par_id2008201415533662738" role="paragraph" xml-lang="en-US">In probability theory and statistics, covariance is a measure of how much two random variables change together. If the greater values of one variable mainly correspond with the greater values of the other variable, and the same holds for the smaller values, i.e., the variables tend to show similar behavior, the covariance is positive. In the opposite case, when the greater values of one variable mainly correspond to the smaller values of the other, i.e., the variables tend to show opposite behavior, the covariance is negative. The sign of the covariance therefore shows the tendency in the linear relationship between the variables. The magnitude of the covariance is not easy to interpret. The normalized version of the covariance, the correlation coefficient, however, shows by its magnitude the strength of the linear relation.</paragraph>
- <paragraph id="par_id2009201415533654986" role="note" xml-lang="en-US">For more information on statistical covariance, refer to <link href="http://en.wikipedia.org/wiki/Covariance">http://en.wikipedia.org/wiki/Covariance</link></paragraph>
- <embed href="text/scalc/01/stat_data.xhp#data"/>
- <embed href="text/scalc/01/stat_data.xhp#grouped"/>
- <embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
- <paragraph id="par_id2008201415533643866" role="paragraph" xml-lang="en-US">The following table displays the results of the covariance of the sample data above.</paragraph>
- <table id="Tabela7">
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533635095" role="tablehead" xml-lang="en-US">Covariances</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533619955" role="tablehead" xml-lang="en-US">Column 1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533651324" role="tablehead" xml-lang="en-US">Column 2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533613800" role="tablehead" xml-lang="en-US">Column 3</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533640180" role="tablehead" xml-lang="en-US">Column 1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533638233" role="tablecontent" xml-lang="en-US" localize="false">126.8099173554</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id200820141553367596" role="tablehead" xml-lang="en-US">Column 2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533676242" role="tablecontent" xml-lang="en-US" localize="false">-61.4444444444</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533623991" role="tablecontent" xml-lang="en-US" localize="false">258.41</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id200820141553364047" role="tablehead" xml-lang="en-US">Column 3</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533612331" role="tablecontent" xml-lang="en-US" localize="false">-32</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533625295" role="tablecontent" xml-lang="en-US" localize="false">53.11</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533618390" role="tablecontent" xml-lang="en-US" localize="false">204.61</paragraph>
- </tablecell>
- </tablerow>
- </table>
- </section>
- <section id="exponentialsmoothing">
- <bookmark xml-lang="en-US" branch="index" id="bm_id03001">
- <bookmark_value>Analysis toolpack;exponential smoothing</bookmark_value>
- <bookmark_value>exponential smoothing;Analysis toolpack</bookmark_value>
- <bookmark_value>Data statistics;exponential smoothing</bookmark_value>
- </bookmark>
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog" id="bm_id03002" localize="false"/>
- <paragraph role="heading" id="hd_id03003" xml-lang="en-US" level="2" l10n="U" oldref="1">Exponential Smoothing</paragraph>
- <paragraph role="paragraph" id="par_id03004" xml-lang="en-US" l10n="U" oldref="2">
- <ahelp hid="modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">Results in a smoothed data series</ahelp>
- </paragraph>
- <section id="howtoget">
- <paragraph role="paragraph" id="par_id03005" xml-lang="en-US" l10n="U" oldref="26">
- <variable id="sam01">Menu <emph>Data - Statistics - Exponential Smoothing...</emph></variable>
- </paragraph>
- </section>
- <paragraph id="par_id2008201415533682260" role="paragraph" xml-lang="en-US">Exponential smoothing is a technique that can be applied to time series data, either to produce smoothed data for presentation, or to make forecasts. The time series data themselves are a sequence of observations. The observed phenomenon may be an essentially random process, or it may be an orderly, but noisy, process. Whereas in the simple moving average the past observations are weighted equally, exponential smoothing assigns exponentially decreasing weights over time.</paragraph>
- <paragraph id="par_id2008201415533641726" role="paragraph" xml-lang="en-US">Exponential smoothing is commonly applied to financial market and economic data, but it can be used with any discrete set of repeated measurements. The simplest form of exponential smoothing should be used only for data without any systematic trend or seasonal components.</paragraph>
- <paragraph id="par_id2008201415533698172" role="note" xml-lang="en-US">For more information on <emph>exponential smoothing</emph>, refer to <link href="http://en.wikipedia.org/wiki/Exponential_smoothing">http://en.wikipedia.org/wiki/Exponential_smoothing</link></paragraph>
- <embed href="text/scalc/01/stat_data.xhp#data"/>
- <embed href="text/scalc/01/stat_data.xhp#grouped"/>
- <paragraph id="hd_id200820141553364794" role="heading" xml-lang="en-US" level="3">Parameters</paragraph>
- <paragraph id="par_id2008201415533649086" role="paragraph" xml-lang="en-US"><emph>Smoothing Factor</emph>: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation.</paragraph>
- <embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
- <paragraph id="par_id2008201415533764911" role="paragraph" xml-lang="en-US">The resulting smoothing is below with smoothing factor as 0.5:</paragraph>
- <table id="Tabela9">
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533725829" role="tablehead" xml-lang="en-US">Alpha</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533773172" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533712984" role="tablehead" xml-lang="en-US">Column 1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533764774" role="tablehead" xml-lang="en-US">Column 2</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533749332" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533745092" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533737850" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533754700" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533771846" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533729632" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533728780" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533774469" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533762343" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533718895" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533781187" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533768677" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533731250" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533718351" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533738571" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533736848" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533734392" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533762561" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533781576" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533778022" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533766928" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553378112" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533737941" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533792938" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533745849" role="tablecontent" xml-lang="en-US" localize="false">0.0004882813</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533777571" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533730361" role="tablecontent" xml-lang="en-US" localize="false">0.0002441406</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533748679" role="tablecontent" xml-lang="en-US" localize="false">0.0004882813</paragraph>
- </tablecell>
- </tablerow>
- </table>
- </section>
- <section id="movingaverage">
- <bookmark xml-lang="en-US" branch="index" id="bm_id04001">
- <bookmark_value>Analysis toolpack;moving average</bookmark_value>
- <bookmark_value>moving average;Analysis toolpack</bookmark_value>
- <bookmark_value>Data statistics;moving average</bookmark_value>
- </bookmark>
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movingaveragedialog/MovingAverageDialog" id="bm_id04002" localize="false"/>
- <paragraph role="heading" id="hd_id04003" xml-lang="en-US" level="2" l10n="U" oldref="1">Moving Average</paragraph>
- <paragraph role="paragraph" id="par_id04004" xml-lang="en-US" l10n="U" oldref="2">
... etc. - the rest is truncated
More information about the Libreoffice-commits
mailing list