summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2015-03-01 23:21:48 -0300
committerDavid Tardon <dtardon@redhat.com>2015-03-02 09:24:53 +0000
commit4bbc71ec42073ade5e64e65acf8700d6041ebf49 (patch)
tree0ac23020fba2076fee9a557c3ca6ecbcd73c96a1
parenta79093aadb26bc133c5bb36b2129ba1a468d44cb (diff)
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@redhat.com> Reviewed-by: David Tardon <dtardon@redhat.com>
-rw-r--r--source/text/scalc/01/stat_data.xhp906
-rw-r--r--source/text/scalc/01/statistics.xhp3182
2 files changed, 2223 insertions, 1865 deletions
diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp
index 7bd2bf34d5..7b70738234 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 710ffacfa2..c6f6470c7b 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">
- <ahelp hid="modules/scalc/ui/movingaveragedialog/MovingAverageDialog">Calculates the moving average of a time series</ahelp>
- </paragraph>
- <section id="howtoget">
- <paragraph role="paragraph" id="par_id04005" xml-lang="en-US" l10n="U" oldref="26">
- <variable id="sam01">Menu <emph>Data - Statistics - Moving Average...</emph></variable>
- </paragraph>
- </section>
- <paragraph id="par_id2008201415533748861" role="paragraph" xml-lang="en-US">In statistics, a moving average (rolling average or running average) is a calculation to analyze data points by creating a series of averages of different subsets of the full data set. It is also called a moving mean or rolling mean and is a type of finite impulse response filter.</paragraph>
- <paragraph id="par_id2008201415533744678" role="note" xml-lang="en-US">You can get more details about moving average in the Wikipedia: <link href="http://en.wikipedia.org/wiki/Moving_average">http://en.wikipedia.org/wiki/Moving_average</link></paragraph>
- <embed href="text/scalc/01/stat_data.xhp#data"/>
- <embed href="text/scalc/01/stat_data.xhp#grouped"/>
- <paragraph id="hd_id2008201415533751077" role="heading" xml-lang="en-US" level="3">Parameters</paragraph>
- <paragraph id="par_id2008201415533787018" role="paragraph" xml-lang="en-US"><emph>Interval</emph>: The number of samples used in the moving average calculation.</paragraph>
- <embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
- <table id="Tabela10">
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533779483" role="tablehead" xml-lang="en-US">Column 1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533791711" role="tablehead" xml-lang="en-US">Column 2</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533764431" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533754380" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533837860" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533814014" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533881158" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533819987" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533853282" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533894892" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533835072" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533899010" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533893900" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533824007" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533887594" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553381652" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533855015" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533838861" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533862247" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533877968" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533858704" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533847663" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533820774" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533854013" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533830124" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553381845" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533847092" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533890018" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
- </tablecell>
- </tablerow>
- </table>
- </section>
- <section id="ttest">
- <bookmark xml-lang="en-US" branch="index" id="bm_id05001">
- <bookmark_value>Analysis toolpack;t-test</bookmark_value>
- <bookmark_value>t-test;Analysis toolpack</bookmark_value>
- <bookmark_value>Data statistics;t-test</bookmark_value>
- <bookmark_value>Analysis toolpack;F-test</bookmark_value>
- <bookmark_value>F-test;Analysis toolpack</bookmark_value>
- <bookmark_value>Data statistics;F-test</bookmark_value>
- </bookmark>
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05002" localize="false"/>
- <paragraph role="heading" id="hd_id05003" xml-lang="en-US" level="2" l10n="U" oldref="1">t-test and F-test</paragraph>
- <paragraph role="paragraph" id="par_id05004" xml-lang="en-US" l10n="U" oldref="2">
- <ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the t-Test or the F-Test of two data samples.</ahelp>
- </paragraph>
- <section id="howtoget">
- <paragraph role="paragraph" id="par_id05005" xml-lang="en-US" l10n="U" oldref="26">
- <variable id="sam01">Menu <emph>Data - Statistics - t-test...</emph></variable>
- </paragraph>
- <paragraph role="paragraph" id="par_id050051" xml-lang="en-US" l10n="U" oldref="26">
- <variable id="sam02">Menu <emph>Data - Statistics - F-test...</emph></variable>
- </paragraph>
- </section>
- <paragraph id="par_id2008201415533888599" role="paragraph" xml-lang="en-US">A <emph>t-test</emph> is any statistical hypothesis test in which the test statistic follows a Student's t distribution if the null hypothesis is supported. It can be used to determine if two sets of data are significantly different from each other, and is most commonly applied when the test statistic would follow a normal distribution if the value of a scaling term in the test statistic were known. When the scaling term is unknown and is replaced by an estimate based on the data, the test statistic (under certain conditions) follows a Student's t distribution.</paragraph>
- <paragraph id="par_id2008201415533819476" role="paragraph" xml-lang="en-US">A <emph>F-test</emph> is any statistical test in which the test statistic has an F-distribution under the null hypothesis. It is most often used when comparing statistical models that have been fitted to a data set, in order to identify the model that best fits the population from which the data were sampled. Exact "F-tests" mainly arise when the models have been fitted to the data using least squares.</paragraph>
- <paragraph id="par_id2008201415533844122" role="note" xml-lang="en-US">For more information on t-tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/T-test">http://en.wikipedia.org/wiki/T-test</link></paragraph>
- <paragraph id="par_id2008201415533423222" role="note" xml-lang="en-US">For more information on F-tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/F-test">http://en.wikipedia.org/wiki/F-test</link></paragraph>
- <paragraph id="hd_id2008201415533817070" role="heading" xml-lang="en-US" level="3">Data</paragraph>
- <paragraph id="par_id2008201415533823950" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph>
- <paragraph id="par_id2008201415533822766" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph>
- <paragraph id="par_id2008201415533879965" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph>
- <embed href="text/scalc/01/stat_data.xhp#grouped"/>
- <embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
- <paragraph id="hd_id2008201415533956416" role="heading" xml-lang="en-US" level="3">Example for t-Test:</paragraph>
- <paragraph id="par_id200820141553388982" role="paragraph" xml-lang="en-US">The following table shows the <emph>t-Test</emph> for the data series above:</paragraph>
- <table id="Tabela11">
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533892337" role="tablehead" xml-lang="en-US">t-test</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533864455" role="tablecontent" xml-lang="en-US">Alpha</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533843020" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
-</tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533863306" role="tablehead" xml-lang="en-US">Variable 1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533818481" role="tablehead" xml-lang="en-US">Variable 2</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533858438" role="tablecontent" xml-lang="en-US">Mean</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533890488" role="tablecontent" xml-lang="en-US" localize="false">0.0769230769</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533872665" role="tablecontent" xml-lang="en-US" localize="false">0.0769230769</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533897974" role="tablecontent" xml-lang="en-US">Variance</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533835463" role="tablecontent" xml-lang="en-US" localize="false">0.0769230769</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533843886" role="tablecontent" xml-lang="en-US" localize="false">0.0769230769</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533868040" role="tablecontent" xml-lang="en-US">Observations</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533811111" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533870732" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533825806" role="tablecontent" xml-lang="en-US">Pearson Correlation</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533816232" role="tablecontent" xml-lang="en-US" localize="false">-0.0833333333</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533840871" role="tablecontent" xml-lang="en-US">Hypothesized Mean Difference</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533813373" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533859489" role="tablecontent" xml-lang="en-US">Observed Mean Difference</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533844955" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533826221" role="tablecontent" xml-lang="en-US">Variance of the Differences</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553384205" role="tablecontent" xml-lang="en-US" localize="false">0.1666666667</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533860284" role="tablecontent" xml-lang="en-US">df</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533879736" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533871121" role="tablecontent" xml-lang="en-US">t Stat</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533816755" role="tablecontent" xml-lang="en-US" localize="false">-17.6635217327</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533822174" role="tablecontent" xml-lang="en-US">P (T&lt;=t) one-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533883121" role="tablecontent" xml-lang="en-US" localize="false">2.9587510767438E-010</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533811741" role="tablecontent" xml-lang="en-US">t Critical one-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533832496" role="tablecontent" xml-lang="en-US" localize="false">1.7822875556</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533829667" role="tablecontent" xml-lang="en-US">P (T&lt;=t) two-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533865577" role="tablecontent" xml-lang="en-US" localize="false">5.91750215348761E-010</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533931877" role="tablecontent" xml-lang="en-US">t Critical two-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533942018" role="tablecontent" xml-lang="en-US" localize="false">2.1788128297</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- </table>
- <paragraph id="hd_id2008201415533942416" role="heading" xml-lang="en-US" level="3">Example for F-Test:</paragraph>
- <paragraph id="par_id2008201415533978190" role="paragraph" xml-lang="en-US">The following table shows the <emph>F</emph><emph>-Test</emph> for the data series above:</paragraph>
- <table id="Tabela12">
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533950785" role="tablehead" xml-lang="en-US">F-test</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533911319" role="tablecontent" xml-lang="en-US">Alpha</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id200820141553398551" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
-</tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533999353" role="tablehead" xml-lang="en-US">Variable 1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533926248" role="tablehead" xml-lang="en-US">Variable 2</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533918157" role="tablecontent" xml-lang="en-US">Mean</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533980101" role="tablecontent" xml-lang="en-US" localize="false">0.0769230769</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533976293" role="tablecontent" xml-lang="en-US" localize="false">0.0769230769</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id200820141553392922" role="tablecontent" xml-lang="en-US">Variance</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533926592" role="tablecontent" xml-lang="en-US" localize="false">0.0769230769</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533992885" role="tablecontent" xml-lang="en-US" localize="false">0.0769230769</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533924413" role="tablecontent" xml-lang="en-US">Observations</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533973033" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533910073" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533948860" role="tablecontent" xml-lang="en-US">df</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533934432" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533957852" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533928162" role="tablecontent" xml-lang="en-US">F</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533923728" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533996864" role="tablecontent" xml-lang="en-US">P (F&lt;=f) right-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533945884" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533921377" role="tablecontent" xml-lang="en-US">F Critical right-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533996308" role="tablecontent" xml-lang="en-US" localize="false">2.6866371125</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533960592" role="tablecontent" xml-lang="en-US">P (F&lt;=f) left-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533954680" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533922655" role="tablecontent" xml-lang="en-US">F Critical left-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533952113" role="tablecontent" xml-lang="en-US" localize="false">0.3722125312</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533918990" role="tablecontent" xml-lang="en-US">P two-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533923159" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
-</tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id2008201415533940157" role="tablecontent" xml-lang="en-US">F Critical two-tail</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533948889" role="tablecontent" xml-lang="en-US" localize="false">0.3051313549</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id2008201415533941329" role="tablecontent" xml-lang="en-US" localize="false">3.277277094</paragraph>
- </tablecell>
- </tablerow>
- </table>
- </section>
- </body>
-</helpdocument>
+
+<meta>
+<topic id="ID" indexer="Indexer" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Data Statistics in Calc</title>
+<filename>/text/scalc/01/statistics.xhp</filename>
+</topic>
+</meta>
+<body>
+<paragraph id="hd_id1000010" role="heading" xml-lang="en-US" level="1">Data Statistics in Calc</paragraph>
+<paragraph id="par_id1000010" role="paragraph" xml-lang="en-US">Use the data statistics in Calc to perform complex data analysis</paragraph>
+<paragraph id="par_id1000020" 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_id1000020" role="heading" xml-lang="en-US" level="2">Sampling</paragraph>
+<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 id="howtoget">
+<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Sampling...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1000050" role="paragraph" xml-lang="en-US">Sampling allows you to pick data from a <emph>source</emph> table to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis.</paragraph>
+<paragraph id="par_id1000060" 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_id1000030" role="heading" xml-lang="en-US" level="3">Sampling Method</paragraph>
+<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>
+<paragraph id="hd_id1000040" role="heading" xml-lang="en-US" level="3">Example</paragraph>
+<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>
+<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 id="hd_id1000050" role="heading" xml-lang="en-US" level="2">Descriptive Statistics</paragraph>
+<paragraph id="par_id1000640" role="paragraph" xml-lang="en-US"><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 id="par_id1000650" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Descriptive Statistics...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1000660" 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_id1000670" 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_id1000680" 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>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000690" role="tablehead" xml-lang="en-US">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000700" role="tablehead" xml-lang="en-US">Column 2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000710" role="tablehead" xml-lang="en-US">Column 3</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000720" role="tablehead" xml-lang="en-US">Mean</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000730" role="tablecontent" xml-lang="en-US" localize="false">41.9090909091</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000740" role="tablecontent" xml-lang="en-US" localize="false">59.7</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000750" role="tablecontent" xml-lang="en-US" localize="false">44.7</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000760" role="tablehead" xml-lang="en-US">Standard Error</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000770" role="tablecontent" xml-lang="en-US" localize="false">3.5610380138</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000780" role="tablecontent" xml-lang="en-US" localize="false">5.3583786934</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000790" role="tablecontent" xml-lang="en-US" localize="false">4.7680650629</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000800" role="tablehead" xml-lang="en-US">Mode</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000810" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000820" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000830" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000840" role="tablehead" xml-lang="en-US">Median</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000850" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000860" role="tablecontent" xml-lang="en-US" localize="false">64.5</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000870" role="tablecontent" xml-lang="en-US" localize="false">43.5</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000880" role="tablehead" xml-lang="en-US">Variance</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000890" role="tablecontent" xml-lang="en-US" localize="false">139.4909090909</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000900" role="tablecontent" xml-lang="en-US" localize="false">287.1222222222</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000910" role="tablecontent" xml-lang="en-US" localize="false">227.3444444444</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000920" role="tablehead" xml-lang="en-US">Standard Deviation</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000930" role="tablecontent" xml-lang="en-US" localize="false">11.8106269559</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000940" role="tablecontent" xml-lang="en-US" localize="false">16.944681237</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000950" role="tablecontent" xml-lang="en-US" localize="false">15.0779456308</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1000960" role="tablehead" xml-lang="en-US">Kurtosis</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000970" role="tablecontent" xml-lang="en-US" localize="false">-1.4621677981</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000980" role="tablecontent" xml-lang="en-US" localize="false">-0.9415988746</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1000990" role="tablecontent" xml-lang="en-US" localize="false">1.418052719</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001000" role="tablehead" xml-lang="en-US">Skewness</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001010" role="tablecontent" xml-lang="en-US" localize="false">0.0152409533</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001020" role="tablecontent" xml-lang="en-US" localize="false">-0.2226426904</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001030" role="tablecontent" xml-lang="en-US" localize="false">-0.9766803373</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001040" role="tablehead" xml-lang="en-US">Range</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001050" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001060" role="tablecontent" xml-lang="en-US" localize="false">51</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001070" role="tablecontent" xml-lang="en-US" localize="false">50</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001080" role="tablehead" xml-lang="en-US">Minimum</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001090" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001100" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001110" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001120" role="tablehead" xml-lang="en-US">Maximum</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001130" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001140" role="tablecontent" xml-lang="en-US" localize="false">84</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001150" role="tablecontent" xml-lang="en-US" localize="false">62</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001160" role="tablehead" xml-lang="en-US">Sum</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001170" role="tablecontent" xml-lang="en-US" localize="false">461</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001180" role="tablecontent" xml-lang="en-US" localize="false">597</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001190" role="tablecontent" xml-lang="en-US" localize="false">447</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001200" role="tablehead" xml-lang="en-US">Count</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001210" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001220" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001230" 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 toolpack;ANOVA</bookmark_value>
+<bookmark_value>analysis of variance;Analysis toolpack</bookmark_value>
+<bookmark_value>ANOVA;Analysis toolpack</bookmark_value>
+<bookmark_value>Data statistics;analysis of variance</bookmark_value>
+<bookmark_value>Data statistics;ANOVA</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog" id="bm_id02002" localize="false"/>
+<paragraph id="hd_id1000060" role="heading" xml-lang="en-US" level="2">Analysis of Variance (ANOVA)</paragraph>
+<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog">Produces the analysis of variance (ANOVA) of a given data set</ahelp></paragraph>
+<section id="howtoget">
+<paragraph id="par_id1001250" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Analysis of Variance (ANOVA)...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1001260" role="paragraph" xml-lang="en-US">ANOVA is the acronym fir A<emph>N</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. Produces the analysis of variance (ANOVA) of a given data set</paragraph>
+<paragraph id="par_id1001270" 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_id1000070" role="heading" xml-lang="en-US" level="3">Type</paragraph>
+<paragraph id="par_id1001280" 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_id1000080" role="heading" xml-lang="en-US" level="3">Parameters</paragraph>
+<paragraph id="par_id1001290" role="paragraph" xml-lang="en-US"><emph>Alpha</emph>: the level of significance of the test.</paragraph>
+<paragraph id="par_id1001300" 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_id1001310" 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_id1001320" 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_id1001330" role="tablecontent" xml-lang="en-US">Alpha</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001340" 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_id1001350" role="tablecontent" xml-lang="en-US">Groups</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001360" role="tablecontent" xml-lang="en-US">Count</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001370" role="tablecontent" xml-lang="en-US">Sum</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001380" role="tablecontent" xml-lang="en-US">Mean</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001390" role="tablecontent" xml-lang="en-US">Variance</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001400" role="tablecontent" xml-lang="en-US">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001410" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001420" role="tablecontent" xml-lang="en-US" localize="false">461</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001430" role="tablecontent" xml-lang="en-US" localize="false">41.9090909091</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001440" role="tablecontent" xml-lang="en-US" localize="false">139.4909090909</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001450" role="tablecontent" xml-lang="en-US">Column 2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001460" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001470" role="tablecontent" xml-lang="en-US" localize="false">597</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001480" role="tablecontent" xml-lang="en-US" localize="false">59.7</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001490" role="tablecontent" xml-lang="en-US" localize="false">287.1222222222</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001500" role="tablecontent" xml-lang="en-US">Column 3</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001510" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001520" role="tablecontent" xml-lang="en-US" localize="false">447</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001530" role="tablecontent" xml-lang="en-US" localize="false">44.7</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001540" 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_id1001550" role="tablecontent" xml-lang="en-US">Source of Variation</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001560" role="tablecontent" xml-lang="en-US">SS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001570" role="tablecontent" xml-lang="en-US">df</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001580" role="tablecontent" xml-lang="en-US">MS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001590" role="tablecontent" xml-lang="en-US">F</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001600" role="tablecontent" xml-lang="en-US">P-value</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001610" role="tablecontent" xml-lang="en-US">Between Groups</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001620" role="tablecontent" xml-lang="en-US" localize="false">1876.5683284457</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001630" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001640" role="tablecontent" xml-lang="en-US" localize="false">938.2841642229</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001650" role="tablecontent" xml-lang="en-US" localize="false">4.3604117704</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001660" role="tablecontent" xml-lang="en-US" localize="false">0.0224614952</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001670" role="tablecontent" xml-lang="en-US">Within Groups</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001680" role="tablecontent" xml-lang="en-US" localize="false">6025.1090909091</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001690" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001700" role="tablecontent" xml-lang="en-US" localize="false">215.1824675325</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001710" role="tablecontent" xml-lang="en-US">Total</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001720" role="tablecontent" xml-lang="en-US" localize="false">7901.6774193548</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001730" 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 id="hd_id1000090" role="heading" xml-lang="en-US" level="2">Correlation</paragraph>
+<paragraph id="par_id1001740" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/correlationdialog/CorrelationDialog">Calculates the correlation of two sets of numeric data.</ahelp></paragraph>
+<section id="howtoget">
+<paragraph id="par_id1001750" role="paragraph" xml-lang="en-US"><variable id="corr01">Menu <emph>Data - Statistics - Correlation...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1001760" 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_id1001770" role="paragraph" xml-lang="en-US">A correlation coefficient of +1 indicates a perfect positive correlation. </paragraph>
+<paragraph id="par_id1001780" role="paragraph" xml-lang="en-US">A correlation coefficient of -1 indicates a perfect negative correlation</paragraph>
+<paragraph id="par_id1001790" 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_id1001800" 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_id1001810" role="tablehead" xml-lang="en-US">Correlations</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001820" role="tablehead" xml-lang="en-US">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001830" role="tablehead" xml-lang="en-US">Column 2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001840" role="tablehead" xml-lang="en-US">Column 3</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001850" role="tablehead" xml-lang="en-US">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001860" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001870" role="tablehead" xml-lang="en-US">Column 2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001880" role="tablecontent" xml-lang="en-US" localize="false">-0.4029254917</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001890" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1001900" role="tablehead" xml-lang="en-US">Column 3</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001910" role="tablecontent" xml-lang="en-US" localize="false">-0.2107642836</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001920" role="tablecontent" xml-lang="en-US" localize="false">0.2309714048</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1001930" 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 id="hd_id1000100" role="heading" xml-lang="en-US" level="2">Covariance</paragraph>
+<paragraph id="par_id1001940" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the covariance of two sets of numeric data.</ahelp></paragraph>
+<section id="howtoget">
+<paragraph id="par_id1001950" role="paragraph" xml-lang="en-US"><variable id="cov01">Menu <emph>Data - Statistics - Covariance...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1001960" role="paragraph" xml-lang="en-US">The covariance is a measure of how much two random variables change together.</paragraph>
+<paragraph id="par_id1001970" 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_id1001980" 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_id1001990" role="tablehead" xml-lang="en-US">Covariances</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002000" role="tablehead" xml-lang="en-US">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002010" role="tablehead" xml-lang="en-US">Column 2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002020" role="tablehead" xml-lang="en-US">Column 3</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002030" role="tablehead" xml-lang="en-US">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002040" role="tablecontent" xml-lang="en-US" localize="false">126.8099173554</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002050" role="tablehead" xml-lang="en-US">Column 2</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002060" role="tablecontent" xml-lang="en-US" localize="false">-61.4444444444</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002070" role="tablecontent" xml-lang="en-US" localize="false">258.41</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002080" role="tablehead" xml-lang="en-US">Column 3</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002090" role="tablecontent" xml-lang="en-US" localize="false">-32</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002100" role="tablecontent" xml-lang="en-US" localize="false">53.11</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002110" 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 id="hd_id1000110" role="heading" xml-lang="en-US" level="2">Exponential Smoothing</paragraph>
+<paragraph id="par_id1002120" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">Results in a smoothed data series</ahelp></paragraph>
+<section id="howtoget">
+<paragraph id="par_id1002130" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Exponential Smoothing...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1002140" role="paragraph" xml-lang="en-US">Exponential smoothing is a filtering technique that when applied to a data set, produces smoothed results. It is employed in many domains such as stock market, economics and in sampled measurements.</paragraph>
+<paragraph id="par_id1002150" 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_id1000120" role="heading" xml-lang="en-US" level="3">Parameters</paragraph>
+<paragraph id="par_id1002160" 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_id1002170" 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_id1002180" role="tablehead" xml-lang="en-US">Alpha</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002190" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002200" role="tablehead" xml-lang="en-US">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002210" role="tablehead" xml-lang="en-US">Column 2</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002220" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002230" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002240" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002250" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002260" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002270" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002280" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002290" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002300" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002310" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002320" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002330" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002340" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002350" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002360" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002370" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002380" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002390" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002400" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002410" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002420" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002430" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002440" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002450" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002460" role="tablecontent" xml-lang="en-US" localize="false">0.0004882813</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002470" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002480" role="tablecontent" xml-lang="en-US" localize="false">0.0002441406</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002490" 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 id="hd_id1000130" role="heading" xml-lang="en-US" level="2">Moving Average</paragraph>
+<paragraph id="par_id1002500" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/movingaveragedialog/MovingAverageDialog">Calculates the moving average of a time series</ahelp></paragraph>
+<section id="howtoget">
+<paragraph id="par_id1002510" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Moving Average...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1002520" role="note" xml-lang="en-US">You can get more details about moving average in the Wikipedia: <link href="http://en.wikipedia.org/wiki/Moving_average">http://en.wikipedia.org/wiki/Moving_average</link></paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/>
+<paragraph id="hd_id1000140" role="heading" xml-lang="en-US" level="3">Parameters</paragraph>
+<paragraph id="par_id1002530" role="paragraph" xml-lang="en-US"><emph>Interval</emph>: The number of samples used in the moving average calculation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
+<paragraph id="hd_id1000171" role="heading" xml-lang="en-US" level="3">Results of the moving average:</paragraph>
+<table id="Tabela10">
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002540" role="tablehead" xml-lang="en-US">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002550" role="tablehead" xml-lang="en-US">Column 2</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002560" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002570" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002580" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002590" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002600" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002610" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002620" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002630" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002640" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002650" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002660" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002670" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002680" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002690" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002700" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002710" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002720" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002730" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002740" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002750" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002760" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002770" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002780" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002790" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002800" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002810" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="ttest">
+<bookmark xml-lang="en-US" branch="index" id="bm_id05001">
+<bookmark_value>Analysis toolpack;t-test</bookmark_value>
+<bookmark_value>t-test;Analysis toolpack</bookmark_value>
+<bookmark_value>Data statistics;t-test</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05002" localize="false"/>
+<paragraph id="hd_id1000150" role="heading" xml-lang="en-US" level="2">t-test</paragraph>
+<paragraph id="par_id1002820" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the t-Test of two data samples.</ahelp></paragraph>
+<section id="howtoget">
+<paragraph id="par_id1002830" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - t-test...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1002840" role="paragraph" xml-lang="en-US">A <emph>t-test</emph> is any statistical hypothesis test that follows a Student's t distribution.</paragraph>
+<paragraph id="par_id1002850" role="note" xml-lang="en-US">For more information on t-tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/T-test">http://en.wikipedia.org/wiki/T-test</link></paragraph>
+<paragraph id="hd_id1000160" role="heading" xml-lang="en-US" level="3">Data</paragraph>
+<paragraph id="par_id1002860" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph>
+<paragraph id="par_id1002870" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph>
+<paragraph id="par_id1002880" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/>
+<paragraph id="hd_id1000170" role="heading" xml-lang="en-US" level="3">Results for t-Test:</paragraph>
+<paragraph id="par_id1002890" role="paragraph" xml-lang="en-US">The following table shows the <emph>t-Test</emph> for the data series above:</paragraph>
+<table id="Tabela11">
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002900" role="tablehead" xml-lang="en-US">t-test</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002910" role="tablecontent" xml-lang="en-US">Alpha</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002920" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002930" role="tablecontent" xml-lang="en-US">Hypothesized Mean Difference</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002940" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002950" role="tablecontent" xml-lang="en-US">Variable 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002960" role="tablecontent" xml-lang="en-US">Variable 2</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002970" role="tablecontent" xml-lang="en-US">Mean</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002980" role="tablecontent" xml-lang="en-US" localize="false">16.9230769231</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002990" role="tablecontent" xml-lang="en-US" localize="false">20.4615384615</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003000" role="tablecontent" xml-lang="en-US">Variance</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003010" role="tablecontent" xml-lang="en-US" localize="false">125.0769230769</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003020" role="tablecontent" xml-lang="en-US" localize="false">94.4358974359</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003030" role="tablecontent" xml-lang="en-US">Observations</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003040" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003050" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003060" role="tablecontent" xml-lang="en-US">Pearson Correlation</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003070" role="tablecontent" xml-lang="en-US" localize="false">-0.0617539772</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003080" role="tablecontent" xml-lang="en-US">Observed Mean Difference</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003090" role="tablecontent" xml-lang="en-US" localize="false">-3.5384615385</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003100" role="tablecontent" xml-lang="en-US">Variance of the Differences</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003110" role="tablecontent" xml-lang="en-US" localize="false">232.9358974359</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003120" role="tablecontent" xml-lang="en-US">df </paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003130" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003140" role="tablecontent" xml-lang="en-US">t Stat</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003150" role="tablecontent" xml-lang="en-US" localize="false">-0.8359262137</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003160" role="tablecontent" xml-lang="en-US">P (T&lt;=t) one-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003170" role="tablecontent" xml-lang="en-US" localize="false">0.2097651442</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003180" role="tablecontent" xml-lang="en-US">t Critical one-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003190" role="tablecontent" xml-lang="en-US" localize="false">1.7822875556</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003200" role="tablecontent" xml-lang="en-US">P (T&lt;=t) two-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003210" role="tablecontent" xml-lang="en-US" localize="false">0.4195302884</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003220" role="tablecontent" xml-lang="en-US">t Critical two-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003230" role="tablecontent" xml-lang="en-US" localize="false">2.1788128297</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="ftest">
+<bookmark xml-lang="en-US" branch="index" id="bm_id05002">
+<bookmark_value>Analysis toolpack;F-test</bookmark_value>
+<bookmark_value>F-test;Analysis toolpack</bookmark_value>
+<bookmark_value>Data statistics;F-test</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05003" localize="false"/>
+<paragraph id="hd_id1000180" role="heading" xml-lang="en-US" level="2">F-test</paragraph>
+<paragraph id="par_id1003240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the F-Test of two data samples.</ahelp></paragraph>
+<section id="howtoget">
+<paragraph id="par_id1003250" role="paragraph" xml-lang="en-US"><variable id="sam02">Menu <emph>Data - Statistics - F-test...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1003260" role="paragraph" xml-lang="en-US">A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis.</paragraph>
+<paragraph id="par_id1003270" role="note" xml-lang="en-US">For more information on F-tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/F-test">http://en.wikipedia.org/wiki/F-test</link></paragraph>
+<paragraph id="hd_id1000190" role="heading" xml-lang="en-US" level="3">Data</paragraph>
+<paragraph id="par_id1003280" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph>
+<paragraph id="par_id1003290" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph>
+<paragraph id="par_id1003300" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/>
+<paragraph id="hd_id1000200" role="heading" xml-lang="en-US" level="3">Results for F-Test:</paragraph>
+<paragraph id="par_id1003310" role="paragraph" xml-lang="en-US">The following table shows the <emph>F-Test</emph> for the data series above:</paragraph>
+<table id="Tabela12">
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003320" role="tablecontent" xml-lang="en-US">Ftest</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003330" role="tablecontent" xml-lang="en-US">Alpha</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003340" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003350" role="tablecontent" xml-lang="en-US">Variable 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003360" role="tablecontent" xml-lang="en-US">Variable 2</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003370" role="tablecontent" xml-lang="en-US">Mean</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003380" role="tablecontent" xml-lang="en-US" localize="false">16.9230769231</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003390" role="tablecontent" xml-lang="en-US" localize="false">20.4615384615</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003400" role="tablecontent" xml-lang="en-US">Variance</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003410" role="tablecontent" xml-lang="en-US" localize="false">125.0769230769</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003420" role="tablecontent" xml-lang="en-US" localize="false">94.4358974359</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003430" role="tablecontent" xml-lang="en-US">Observations</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003440" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003450" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003460" role="tablecontent" xml-lang="en-US">df</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003470" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003480" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003490" role="tablecontent" xml-lang="en-US">F</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003500" role="tablecontent" xml-lang="en-US" localize="false">1.3244637524</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003510" role="tablecontent" xml-lang="en-US">P (F&lt;=f) right-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003520" role="tablecontent" xml-lang="en-US" localize="false">0.3170614146</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003530" role="tablecontent" xml-lang="en-US">F Critical right-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003540" role="tablecontent" xml-lang="en-US" localize="false">2.6866371125</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003550" role="tablecontent" xml-lang="en-US">P (F&lt;=f) left-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003560" role="tablecontent" xml-lang="en-US" localize="false">0.6829385854</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003570" role="tablecontent" xml-lang="en-US">F Critical left-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003580" role="tablecontent" xml-lang="en-US" localize="false">0.3722125312</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003590" role="tablecontent" xml-lang="en-US">P two-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003600" role="tablecontent" xml-lang="en-US" localize="false">0.6341228293</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003610" role="tablecontent" xml-lang="en-US">F Critical two-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003620" role="tablecontent" xml-lang="en-US" localize="false">0.3051313549</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003630" role="tablecontent" xml-lang="en-US" localize="false">3.277277094</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="ztest">
+<bookmark xml-lang="en-US" branch="index" id="bm_id05003">
+<bookmark_value>Analysis toolpack;Z-test</bookmark_value>
+<bookmark_value>Z-test;Analysis toolpack</bookmark_value>
+<bookmark_value>Data statistics;Z-test</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ztestdialog/ZTestDialog" id="bm_id05004" localize="false"/>
+<paragraph id="hd_id1000210" role="heading" xml-lang="en-US" level="2">Z-test</paragraph>
+<paragraph id="par_id1003640" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the z-Test of two data samples.</ahelp></paragraph>
+<section id="howtoget">
+<paragraph id="par_id1003650" role="paragraph" xml-lang="en-US"><variable id="sam02">Menu <emph>Data - Statistics - Z-test...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1003660" role="note" xml-lang="en-US">For more information on Z-tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/Z-test">http://en.wikipedia.org/wiki/Z-test</link></paragraph>
+<paragraph id="hd_id1000220" role="heading" xml-lang="en-US" level="3">Data</paragraph>
+<paragraph id="par_id1003670" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph>
+<paragraph id="par_id1003680" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph>
+<paragraph id="par_id1003690" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/>
+<paragraph id="hd_id1000230" role="heading" xml-lang="en-US" level="3">Results for z-Test:</paragraph>
+<paragraph id="par_id1003700" role="paragraph" xml-lang="en-US">The following table shows the <emph>z-Test</emph> for the data series above:</paragraph>
+<table id="Tabela13">
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003710" role="tablecontent" xml-lang="en-US">z-test</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003720" role="tablecontent" xml-lang="en-US">Alpha</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003730" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003740" role="tablecontent" xml-lang="en-US">Hypothesized Mean Difference</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003750" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003760" role="tablecontent" xml-lang="en-US">Variable 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003770" role="tablecontent" xml-lang="en-US">Variable 2</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003780" role="tablecontent" xml-lang="en-US">Known Variance</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003790" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003800" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003810" role="tablecontent" xml-lang="en-US">Mean</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003820" role="tablecontent" xml-lang="en-US" localize="false">16.9230769231</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003830" role="tablecontent" xml-lang="en-US" localize="false">20.4615384615</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003840" role="tablecontent" xml-lang="en-US">Observations</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003850" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003860" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003870" role="tablecontent" xml-lang="en-US">Observed Mean Difference</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003880" role="tablecontent" xml-lang="en-US" localize="false">-3.5384615385</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003890" role="tablecontent" xml-lang="en-US">z</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003900" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003910" role="tablecontent" xml-lang="en-US">P (Z&lt;=z) one-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003920" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003930" role="tablecontent" xml-lang="en-US">z Critical one-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003940" role="tablecontent" xml-lang="en-US" localize="false">1.644853627</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003950" role="tablecontent" xml-lang="en-US">P (Z&lt;=z) two-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003960" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1003970" role="tablecontent" xml-lang="en-US">z Critical two-tail</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1003980" role="tablecontent" xml-lang="en-US" localize="false">1.9599639845</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<section id="chisqtest">
+<bookmark xml-lang="en-US" branch="index" id="bm_id05004">
+<bookmark_value>Analysis toolpack;Chi-square test</bookmark_value>
+<bookmark_value>Chi-square test;Analysis toolpack</bookmark_value>
+<bookmark_value>Data statistics;Chi-square test</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog" id="bm_id05005" localize="false"/>
+<paragraph id="hd_id1000240" role="heading" xml-lang="en-US" level="2">Chi-square test</paragraph>
+<paragraph id="par_id1003641" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog">Calculates the Chi-square test of a data sample.</ahelp></paragraph>
+<section id="howtoget">
+<paragraph id="par_id1003990" role="paragraph" xml-lang="en-US"><variable id="sam02">Menu <emph>Data - Statistics - Chi-square Test...</emph></variable></paragraph>
+</section>
+<paragraph id="par_id1004000" role="note" xml-lang="en-US">For more information on Chi-square tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/Chi-square_test">http://en.wikipedia.org/wiki/Chi-square_test</link></paragraph>
+<paragraph id="hd_id1000250" role="heading" xml-lang="en-US" level="3">Data</paragraph>
+<paragraph id="par_id1004010" role="paragraph" xml-lang="en-US"><emph>Input range</emph>: The reference of the range of the data series to analyze.</paragraph>
+<paragraph id="par_id1004020" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/>
+<paragraph id="hd_id1000231" role="heading" xml-lang="en-US" level="3">Results for Chi-square Test:</paragraph>
+<table id="tablechisq">
+<tablerow>
+<tablecell>
+<paragraph id="par_id1004030" role="tablehead" xml-lang="en-US">Test of Independence (Chi-Square)</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1004040" role="tablecontent" xml-lang="en-US">Alpha</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1004050" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1004060" role="tablecontent" xml-lang="en-US">df</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1004070" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1004080" role="tablecontent" xml-lang="en-US">P-value</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1004090" role="tablecontent" xml-lang="en-US" localize="false">2.32567054678584E-014</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1004100" role="tablecontent" xml-lang="en-US">Test Statistic</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1004110" role="tablecontent" xml-lang="en-US" localize="false">91.6870055842</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1004120" role="tablecontent" xml-lang="en-US">Critical Value</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1004130" role="tablecontent" xml-lang="en-US" localize="false">21.0260698175</paragraph>
+</tablecell>
+</tablerow>
+</table>
+</section>
+</body>
+</helpdocument> \ No newline at end of file