diff options
| author | Olivier Hallot <olivier.hallot@edx.srv.br> | 2014-08-20 21:36:38 -0300 |
|---|---|---|
| committer | Caolán McNamara <caolanm@redhat.com> | 2014-08-22 11:05:55 -0500 |
| commit | ba90edc72a3eedc95f2a2bd2c6923b860cc3e4d8 (patch) | |
| tree | 898d664fceef0d6c81052dcbbd3763e3ba18cf8d | |
| parent | 356a862f1cac3c528c53be0bc31ed4063444681c (diff) | |
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 <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>
| -rw-r--r-- | AllLangHelp_scalc.mk | 1 | ||||
| -rw-r--r-- | source/text/scalc/01/stat_data.xhp | 386 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics.xhp | 1729 |
3 files changed, 1879 insertions, 237 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 07ca0ad7b3..69ba36e4a3 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 0000000000..5263a70ea7 --- /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 bb46695637..a1acd510ec 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"> + <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">0.3333333333</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533814014" role="tablecontent" xml-lang="en-US">0.3333333333</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533881158" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533819987" role="tablecontent" xml-lang="en-US">0.3333333333</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533853282" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533894892" role="tablecontent" xml-lang="en-US">0.3333333333</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533835072" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533899010" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533893900" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533824007" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533887594" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id200820141553381652" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533855015" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533838861" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533862247" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533877968" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533858704" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533847663" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533820774" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533854013" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533830124" role="tablecontent" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id200820141553381845" role="tablecontent" xml-lang="en-US">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="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">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">0.0769230769</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533872665" role="tablecontent" xml-lang="en-US">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">0.0769230769</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533843886" role="tablecontent" xml-lang="en-US">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">13</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533870732" role="tablecontent" xml-lang="en-US">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">-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">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">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">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">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">-17.6635217327</paragraph> + </tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533822174" role="tablecontent" xml-lang="en-US">P (T<=t) one-tail</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533883121" role="tablecontent" xml-lang="en-US">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">1.7822875556</paragraph> + </tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533829667" role="tablecontent" xml-lang="en-US">P (T<=t) two-tail</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533865577" role="tablecontent" xml-lang="en-US">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">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">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">0.0769230769</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533976293" role="tablecontent" xml-lang="en-US">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">0.0769230769</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533992885" role="tablecontent" xml-lang="en-US">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">13</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533910073" role="tablecontent" xml-lang="en-US">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">12</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533957852" role="tablecontent" xml-lang="en-US">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">1</paragraph> + </tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533996864" role="tablecontent" xml-lang="en-US">P (F<=f) right-tail</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533945884" role="tablecontent" xml-lang="en-US">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">2.6866371125</paragraph> + </tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2008201415533960592" role="tablecontent" xml-lang="en-US">P (F<=f) left-tail</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533954680" role="tablecontent" xml-lang="en-US">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">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">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">0.3051313549</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2008201415533941329" role="tablecontent" xml-lang="en-US">3.277277094</paragraph> + </tablecell> + </tablerow> + </table> + </section> + </body> </helpdocument> |