AllLangHelp_scalc.mk | 1
source/text/scalc/01/stat_data.xhp | 386 ++++++++
source/text/scalc/01/statistics.xhp | 1729 +++++++++++++++++++++++++++++++-----
3 files changed, 1879 insertions(+), 237 deletions(-)
New commits:
commit ba90edc72a3eedc95f2a2bd2c6923b860cc3e4d8
Author: Olivier Hallot <olivier.hal...@edx.srv.br>
Date: Wed Aug 20 21:36:38 2014 -0300
Fix fdo#80338 Help pages for Data Statistics
This is a text to get a mimnimum help for Calc Data Statistics.
It can be improved with better english and better maths.
Change-Id: I3771ed89c560df1e4e23835f5a15d8cfc47282cd
Reviewed-on: https://gerrit.libreoffice.org/11051
Reviewed-by: Caolán McNamara <caol...@redhat.com>
Tested-by: Caolán McNamara <caol...@redhat.com>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 07ca0ad..69ba36e 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -207,6 +207,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/solver \
helpcontent2/source/text/scalc/01/solver_options \
helpcontent2/source/text/scalc/01/statistics \
+ helpcontent2/source/text/scalc/01/stat_data \
helpcontent2/source/text/scalc/01/text2columns \
helpcontent2/source/text/scalc/02/02130000 \
helpcontent2/source/text/scalc/02/02140000 \
diff --git a/source/text/scalc/01/stat_data.xhp
b/source/text/scalc/01/stat_data.xhp
new file mode 100644
index 0000000..5263a70
--- /dev/null
+++ b/source/text/scalc/01/stat_data.xhp
@@ -0,0 +1,386 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * 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 colspan="" rowspan="">
+</tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533312589" role="tablehead"
xml-lang="en-US">A</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533338155" role="tablehead"
xml-lang="en-US">B</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533321020" role="tablehead"
xml-lang="en-US">C</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533376551" role="tablehead"
xml-lang="en-US">1</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id200820141553335121" role="tablehead"
xml-lang="en-US">Maths</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533379519" role="tablehead"
xml-lang="en-US">Physics</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id200820141553333644" role="tablehead"
xml-lang="en-US">Biology</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533318687" role="tablehead"
xml-lang="en-US">2</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533340873" role="tablecontent"
xml-lang="en-US">47</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533348976" role="tablecontent"
xml-lang="en-US">67</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533345798" role="tablecontent"
xml-lang="en-US">33</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533344558" role="tablehead"
xml-lang="en-US">3</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533348756" role="tablecontent"
xml-lang="en-US">36</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533364631" role="tablecontent"
xml-lang="en-US">68</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533379397" role="tablecontent"
xml-lang="en-US">42</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533370936" role="tablehead"
xml-lang="en-US">4</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533392087" role="tablecontent"
xml-lang="en-US">40</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533375468" role="tablecontent"
xml-lang="en-US">65</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533380753" role="tablecontent"
xml-lang="en-US">44</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533327602" role="tablehead"
xml-lang="en-US">5</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533370577" role="tablecontent"
xml-lang="en-US">39</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533367970" role="tablecontent"
xml-lang="en-US">64</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id20082014155334281" role="tablecontent"
xml-lang="en-US">60</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533465509" role="tablehead"
xml-lang="en-US">6</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+</tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533471070" role="tablecontent"
xml-lang="en-US">38</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533416261" role="tablecontent"
xml-lang="en-US">43</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533464396" role="tablehead"
xml-lang="en-US">7</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533411899" role="tablecontent"
xml-lang="en-US">47</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533445603" role="tablecontent"
xml-lang="en-US">84</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533449836" role="tablecontent"
xml-lang="en-US">62</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533477391" role="tablehead"
xml-lang="en-US">8</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533495974" role="tablecontent"
xml-lang="en-US">29</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533457375" role="tablecontent"
xml-lang="en-US">80</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533434038" role="tablecontent"
xml-lang="en-US">51</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533487675" role="tablehead"
xml-lang="en-US">9</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008101415533458526" role="tablecontent"
xml-lang="en-US">27</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533480817" role="tablecontent"
xml-lang="en-US">49</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533422381" role="tablecontent"
xml-lang="en-US">40</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id200820141553341777" role="tablehead"
xml-lang="en-US">10</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533475126" role="tablecontent"
xml-lang="en-US">57</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533482124" role="tablecontent"
xml-lang="en-US">49</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533425509" role="tablecontent"
xml-lang="en-US">12</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533482084" role="tablehead"
xml-lang="en-US">11</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533450595" role="tablecontent"
xml-lang="en-US">56</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533494007" role="tablecontent"
xml-lang="en-US">33</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533469907" role="tablecontent"
xml-lang="en-US">60</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533441266" role="tablehead"
xml-lang="en-US">12</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533489090" role="tablecontent"
xml-lang="en-US">57</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+</tablecell>
+ <tablecell colspan="" rowspan="">
+</tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533442316" role="tablehead"
xml-lang="en-US">13</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533495929" role="tablecontent"
xml-lang="en-US">26</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+</tablecell>
+ <tablecell colspan="" rowspan="">
+</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">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533690005" role="tablecontent"
xml-lang="en-US">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533634383" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533636924" role="tablehead"
xml-lang="en-US">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820141553363326" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533611120" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533616287" role="tablehead"
xml-lang="en-US">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533678025" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533687736" role="tablecontent"
xml-lang="en-US">1</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533638973" role="tablehead"
xml-lang="en-US">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533621030" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533624169" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533727275" role="tablehead"
xml-lang="en-US">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533740391" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533749244" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id200820141553379645" role="tablehead"
xml-lang="en-US">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533722341" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533713197" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533749030" role="tablehead"
xml-lang="en-US">7</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533794205" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533795494" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533795613" role="tablehead"
xml-lang="en-US">8</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533765196" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533757520" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533775750" role="tablehead"
xml-lang="en-US">9</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820141553375977" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533743524" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533723477" role="tablehead"
xml-lang="en-US">10</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533755288" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533735315" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id200820141553375315" role="tablehead"
xml-lang="en-US">11</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533782119" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533732251" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id200820141553371540" role="tablehead"
xml-lang="en-US">12</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533740498" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820141553374302" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533790843" role="tablehead"
xml-lang="en-US">13</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533716899" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533780913" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </body>
+</helpdocument>
diff --git a/source/text/scalc/01/statistics.xhp
b/source/text/scalc/01/statistics.xhp
index bb46695..a1acd51 100644
--- a/source/text/scalc/01/statistics.xhp
+++ b/source/text/scalc/01/statistics.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,240 +16,1497 @@
* 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</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</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 role="heading" id="hd_id2753032" xml-lang="en-US" level="2"
l10n="U" oldref="1">Sampling</paragraph>
-<paragraph role="paragraph" id="par_id2756327" xml-lang="en-US" l10n="U"
oldref="2">
- <ahelp
hid="modules/scalc/ui/samplingdialog/SamplingDialog">(to-do)</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 role="paragraph" id="par_id2756923" xml-lang="en-US" l10n="U"
oldref="4">
- (To do)
-</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/samplingdialog/input-range-label"
id="bm_id2748663" localize="false"/>
-<paragraph role="heading" id="hd_id2753895" xml-lang="en-US" level="3"
l10n="U" oldref="5">Input Range</paragraph>
-<paragraph role="paragraph" id="par_id2750400" xml-lang="en-US" l10n="U"
oldref="6"><ahelp
hid="modules/scalc/ui/samplingdialog/input-range-label">Select the input data
range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/samplingdialog/output-range-label"
id="bm_id263984" localize="false"/>
-<paragraph role="heading" id="hd_id2754704" xml-lang="en-US" level="3"
l10n="CHG" oldref="7">Results to</paragraph>
-<paragraph role="paragraph" id="par_id2753967" xml-lang="en-US" l10n="CHG"
oldref="8"><ahelp
hid="modules/scalc/ui/samplingdialog/output-range-label">Selects the upper left
cell where the samples will be displayed.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/samplingdialog/groupedby-columns-radio"
id="bm_id2739518" localize="false"/>
-</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">(to-do)</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 role="paragraph" id="par_id01006" xml-lang="en-US" l10n="U"
oldref="4">
- (To do)
-</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/descriptivestatisticsdialog/input-range-label"
id="bm_id01007" localize="false"/>
-<paragraph role="heading" id="hd_id01008" xml-lang="en-US" level="3" l10n="U"
oldref="5">Input Range</paragraph>
-<paragraph role="paragraph" id="par_id01009" xml-lang="en-US" l10n="U"
oldref="6"><ahelp
hid="modules/scalc/ui/descriptivestatisticsdialog/input-range-label">Select the
input data range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/descriptivestatisticsdialog/output-range-label"
id="bm_id01010" localize="false"/>
-<paragraph role="heading" id="hd_id01011" xml-lang="en-US" level="3"
l10n="CHG" oldref="7">Results to</paragraph>
-<paragraph role="paragraph" id="par_id01012" xml-lang="en-US" l10n="CHG"
oldref="8"><ahelp
hid="modules/scalc/ui/descriptivestatisticsdialog/output-range-label">Selects
the upper left cell where the samples will be displayed.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/descriptivestatisticsdialog/groupedby-columns-radio"
id="bm_id01013" localize="false"/>
-</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">(to-do)</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 role="paragraph" id="par_id02006" xml-lang="en-US" l10n="U"
oldref="4">
- (To do)
-</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/analysisofvariancedialog/input-range-label"
id="bm_id02007" localize="false"/>
-<paragraph role="heading" id="hd_id02008" xml-lang="en-US" level="3" l10n="U"
oldref="5">Input Range</paragraph>
-<paragraph role="paragraph" id="par_id02009" xml-lang="en-US" l10n="U"
oldref="6"><ahelp
hid="modules/scalc/ui/analysisofvariancedialog/input-range-label">Select the
input data range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/analysisofvariancedialog/output-range-label"
id="bm_id02010" localize="false"/>
-<paragraph role="heading" id="hd_id02011" xml-lang="en-US" level="3"
l10n="CHG" oldref="7">Results to</paragraph>
-<paragraph role="paragraph" id="par_id02012" xml-lang="en-US" l10n="CHG"
oldref="8"><ahelp
hid="modules/scalc/ui/analysisofvariancedialog/output-range-label">Selects the
upper left cell where the samples will be displayed.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/analysisofvariancedialog/groupedby-columns-radio"
id="bm_id02013" localize="false"/>
-</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 role="paragraph" id="par_id3155923" xml-lang="en-US" l10n="U"
oldref="4">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 role="paragraph" id="par_id2955923" xml-lang="en-US" l10n="U"
oldref="4">A correlation coefficient of +1 indicates a perfect positive
correlation. </paragraph>
-<paragraph role="paragraph" id="par_id2855923" xml-lang="en-US" l10n="U"
oldref="4">A correlation coefficient of -1 indicates a perfect negative
correlation</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/correlationdialog/input-range-label"
id="bm_id3148663" localize="false"/>
-<paragraph role="heading" id="hd_id3153896" xml-lang="en-US" level="3"
l10n="U" oldref="5">Input Range</paragraph>
-<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US" l10n="U"
oldref="6"><ahelp
hid="modules/scalc/ui/correlationdialog/input-range-label">Select the inout
data range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/correlationdialog/output-range-label"
id="bm_id263985" localize="false"/>
-<paragraph role="heading" id="hd_id3154704" xml-lang="en-US" level="3"
l10n="CHG" oldref="7">Results to</paragraph>
-<paragraph role="paragraph" id="par_id3153967" xml-lang="en-US" l10n="CHG"
oldref="8"><ahelp
hid="modules/scalc/ui/correlationdialog/output-range-label">Selects the upper
left cell where the correlation will be displayed.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/correlationdialog/groupedby-columns-radio"
id="bm_id5339518" localize="false"/>
-<paragraph role="heading" id="par_idN10709" xml-lang="en-US" level="3"
l10n="NEW">Columns</paragraph>
-<paragraph role="paragraph" id="par_idN1070D" xml-lang="en-US"
l10n="NEW"><ahelp
hid="modules/scalc/ui/correlationdialog/groupedby-columns-radio">The data
series ae in columns.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/correlationdialog/groupedby-columns-radio"
id="bm_id2339518" localize="false"/>
-<paragraph role="heading" id="par_idN11709" xml-lang="en-US" level="3"
l10n="NEW">Rows</paragraph>
-<paragraph role="paragraph" id="par_idN1270D" xml-lang="en-US"
l10n="NEW"><ahelp
hid="modules/scalc/ui/correlationdialog/groupedby-columns-radio">The data
series are in rows.</ahelp></paragraph>
-</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 role="paragraph" id="par_id2956923" xml-lang="en-US" l10n="U"
oldref="4">
- Covariance indicates how two variables are related. A positive covariance
means the variables are positively related,
- while a negative covariance means the variables are inversely related.
-</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/covariancedialog/input-range-label"
id="bm_id3148663" localize="false"/>
-<paragraph role="heading" id="hd_id2953895" xml-lang="en-US" level="3"
l10n="U" oldref="5">Input Range</paragraph>
-<paragraph role="paragraph" id="par_id2950400" xml-lang="en-US" l10n="U"
oldref="6"><ahelp
hid="modules/scalc/ui/covariancedialog/input-range-label">Select the input data
range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/covariancedialog/output-range-label"
id="bm_id263985" localize="false"/>
-<paragraph role="heading" id="hd_id2954704" xml-lang="en-US" level="3"
l10n="CHG" oldref="7">Results to</paragraph>
-<paragraph role="paragraph" id="par_id2953967" xml-lang="en-US" l10n="CHG"
oldref="8"><ahelp
hid="modules/scalc/ui/covariancedialog/output-range-label">Selects the upper
left cell where the correlation will be displayed.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/covariancedialog/groupedby-columns-radio"
id="bm_id5339518" localize="false"/>
-<paragraph role="heading" id="par_idN117091" xml-lang="en-US" level="3"
l10n="NEW">Columns</paragraph>
-<paragraph role="paragraph" id="par_idN1170D" xml-lang="en-US"
l10n="NEW"><ahelp
hid="modules/scalc/ui/covariancedialog/groupedby-columns-radio">The data series
are in columns.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/covariancedialog/groupedby-columns-radio"
id="bm_id2339518" localize="false"/>
-<paragraph role="heading" id="par_idN11710" xml-lang="en-US" level="3"
l10n="NEW">Rows</paragraph>
-<paragraph role="paragraph" id="par_idN1171D" xml-lang="en-US"
l10n="NEW"><ahelp
hid="modules/scalc/ui/covariancedialog/groupedby-columns-radio">The data series
are in rows.</ahelp></paragraph>
-</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">(to-do)</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 role="paragraph" id="par_id03006" xml-lang="en-US" l10n="U"
oldref="4">
- (To do)
-</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/exponentialsmoothingdialog/input-range-label"
id="bm_id03007" localize="false"/>
-<paragraph role="heading" id="hd_id03008" xml-lang="en-US" level="3" l10n="U"
oldref="5">Input Range</paragraph>
-<paragraph role="paragraph" id="par_id03009" xml-lang="en-US" l10n="U"
oldref="6"><ahelp
hid="modules/scalc/ui/exponentialsmoothingdialog/input-range-label">Select the
input data range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/exponentialsmoothingdialog/output-range-label"
id="bm_id03010" localize="false"/>
-<paragraph role="heading" id="hd_id03011" xml-lang="en-US" level="3"
l10n="CHG" oldref="7">Results to</paragraph>
-<paragraph role="paragraph" id="par_id03012" xml-lang="en-US" l10n="CHG"
oldref="8"><ahelp
hid="modules/scalc/ui/exponentialsmoothingdialog/output-range-label">Selects
the upper left cell where the samples will be displayed.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/exponentialsmoothingdialog/groupedby-columns-radio"
id="bm_id03013" localize="false"/>
-</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">(to-do)</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 role="paragraph" id="par_id04006" xml-lang="en-US" l10n="U"
oldref="4">
- (To do)
-</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/movingaveragedialog/input-range-label"
id="bm_id04007" localize="false"/>
-<paragraph role="heading" id="hd_id04008" xml-lang="en-US" level="3" l10n="U"
oldref="5">Input Range</paragraph>
-<paragraph role="paragraph" id="par_id04009" xml-lang="en-US" l10n="U"
oldref="6"><ahelp
hid="modules/scalc/ui/movingaveragedialog/input-range-label">Select the input
data range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/movingaveragedialog/output-range-label"
id="bm_id04010" localize="false"/>
-<paragraph role="heading" id="hd_id04011" xml-lang="en-US" level="3"
l10n="CHG" oldref="7">Results to</paragraph>
-<paragraph role="paragraph" id="par_id04012" xml-lang="en-US" l10n="CHG"
oldref="8"><ahelp
hid="modules/scalc/ui/movingaveragedialog/output-range-label">Selects the upper
left cell where the samples will be displayed.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/movingaveragedialog/groupedby-columns-radio"
id="bm_id04013" localize="false"/>
-</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">(to-do)</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 role="paragraph" id="par_id05006" xml-lang="en-US" l10n="U"
oldref="4">
- (To do)
-</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/ttestdialog/variable1-range-label" id="bm_id05007"
localize="false"/>
-<paragraph role="heading" id="hd_id05008" xml-lang="en-US" level="3" l10n="U"
oldref="5">Input Range</paragraph>
-<paragraph role="paragraph" id="par_id05009" xml-lang="en-US" l10n="U"
oldref="6"><ahelp
hid="modules/scalc/ui/ttestdialog/variable1-range-label">Select the input data
range.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/ttestdialog/output-range-label" id="bm_id05010"
localize="false"/>
-<paragraph role="heading" id="hd_id05011" xml-lang="en-US" level="3"
l10n="CHG" oldref="7">Results to</paragraph>
-<paragraph role="paragraph" id="par_id05012" xml-lang="en-US" l10n="CHG"
oldref="8"><ahelp hid="modules/scalc/ui/ttestdialog/output-range-label">Selects
the upper left cell where the samples will be displayed.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/ttestdialog/groupedby-columns-radio"
id="bm_id05013" localize="false"/>
-</section>
-
-</body>
-
+ <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" width="90">
+ <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" localize="false">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">41.9090909091</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533423015" role="tablecontent"
xml-lang="en-US">59.7</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533425750" role="tablecontent"
xml-lang="en-US">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">3.5610380138</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533498852" role="tablecontent"
xml-lang="en-US">5.3583786934</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533425428" role="tablecontent"
xml-lang="en-US">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">47</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533429983" role="tablecontent"
xml-lang="en-US">49</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533424352" role="tablecontent"
xml-lang="en-US">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">40</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533421723" role="tablecontent"
xml-lang="en-US">64.5</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533434998" role="tablecontent"
xml-lang="en-US">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">139.4909090909</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533484846" role="tablecontent"
xml-lang="en-US">287.1222222222</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533425108" role="tablecontent"
xml-lang="en-US">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">11.8106269559</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533477889" role="tablecontent"
xml-lang="en-US">16.944681237</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533447328" role="tablecontent"
xml-lang="en-US">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">-1.4621677981</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id200820141553346759" role="tablecontent"
xml-lang="en-US">-0.9415988746</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533483082" role="tablecontent"
xml-lang="en-US">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">0.0152409533</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533459450" role="tablecontent"
xml-lang="en-US">-0.2226426904</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533454972" role="tablecontent"
xml-lang="en-US">-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">31</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533469523" role="tablecontent"
xml-lang="en-US">51</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533428583" role="tablecontent"
xml-lang="en-US">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">26</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533439232" role="tablecontent"
xml-lang="en-US">33</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533475372" role="tablecontent"
xml-lang="en-US">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">57</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533420806" role="tablecontent"
xml-lang="en-US">84</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533456782" role="tablecontent"
xml-lang="en-US">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">461</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533440420" role="tablecontent"
xml-lang="en-US">597</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id200820141553345395" role="tablecontent"
xml-lang="en-US">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">11</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533559282" role="tablecontent"
xml-lang="en-US">10</paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph id="par_id2008201415533577916" role="tablecontent"
xml-lang="en-US">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">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">11</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533565407" role="tablecontent"
xml-lang="en-US">461</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533552984" role="tablecontent"
xml-lang="en-US">41.9090909091</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533568921" role="tablecontent"
xml-lang="en-US">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">10</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533598837" role="tablecontent"
xml-lang="en-US">597</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533545054" role="tablecontent"
xml-lang="en-US">59.7</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533572049" role="tablecontent"
xml-lang="en-US">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">10</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533522897" role="tablecontent"
xml-lang="en-US">447</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533550549" role="tablecontent"
xml-lang="en-US">44.7</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533591333" role="tablecontent"
xml-lang="en-US">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">1876.5683284457</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533544758" role="tablecontent"
xml-lang="en-US">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820141553357817" role="tablecontent"
xml-lang="en-US">938.2841642229</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533585445" role="tablecontent"
xml-lang="en-US">4.3604117704</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533544267" role="tablecontent"
xml-lang="en-US">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">6025.1090909091</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533549854" role="tablecontent"
xml-lang="en-US">28</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533596189" role="tablecontent"
xml-lang="en-US">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">7901.6774193548</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820141553353431" role="tablecontent"
xml-lang="en-US">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">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">-0.4029254917</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820141553369535" role="tablecontent"
xml-lang="en-US">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">-0.2107642836</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533613606" role="tablecontent"
xml-lang="en-US">0.2309714048</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533680211" role="tablecontent"
xml-lang="en-US">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">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">-61.4444444444</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533623991" role="tablecontent"
xml-lang="en-US">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">-32</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533625295" role="tablecontent"
xml-lang="en-US">53.11</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533618390" role="tablecontent"
xml-lang="en-US">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">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">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533745092" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533737850" role="tablecontent"
xml-lang="en-US">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533754700" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533771846" role="tablecontent"
xml-lang="en-US">0.5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533729632" role="tablecontent"
xml-lang="en-US">0</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533728780" role="tablecontent"
xml-lang="en-US">0.25</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533774469" role="tablecontent"
xml-lang="en-US">0.5</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533762343" role="tablecontent"
xml-lang="en-US">0.125</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533718895" role="tablecontent"
xml-lang="en-US">0.25</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533781187" role="tablecontent"
xml-lang="en-US">0.0625</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533768677" role="tablecontent"
xml-lang="en-US">0.125</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533731250" role="tablecontent"
xml-lang="en-US">0.03125</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533718351" role="tablecontent"
xml-lang="en-US">0.0625</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533738571" role="tablecontent"
xml-lang="en-US">0.015625</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533736848" role="tablecontent"
xml-lang="en-US">0.03125</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533734392" role="tablecontent"
xml-lang="en-US">0.0078125</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533762561" role="tablecontent"
xml-lang="en-US">0.015625</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533781576" role="tablecontent"
xml-lang="en-US">0.00390625</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533778022" role="tablecontent"
xml-lang="en-US">0.0078125</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533766928" role="tablecontent"
xml-lang="en-US">0.001953125</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820141553378112" role="tablecontent"
xml-lang="en-US">0.00390625</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533737941" role="tablecontent"
xml-lang="en-US">0.0009765625</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533792938" role="tablecontent"
xml-lang="en-US">0.001953125</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533745849" role="tablecontent"
xml-lang="en-US">0.0004882813</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533777571" role="tablecontent"
xml-lang="en-US">0.0009765625</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id2008201415533730361" role="tablecontent"
xml-lang="en-US">0.0002441406</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id2008201415533748679" role="tablecontent"
xml-lang="en-US">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">
... etc. - the rest is truncated
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
