diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-20 16:32:20 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-20 20:35:16 +0100 |
| commit | e1032e5082161441a37473e22582f6eb6938c102 (patch) | |
| tree | 2afbd43fd8e160a7b7096646924453c46f8361c9 /source | |
| parent | Review, refactor Calc Data Menu Help pages (diff) | |
| download | help-e1032e5082161441a37473e22582f6eb6938c102.tar.gz help-e1032e5082161441a37473e22582f6eb6938c102.zip | |
Refactor Data analysis Calc help page
Comply with menu Data > Statistics
Change-Id: I06a5ed00ef162064ea2768f3040511e599993c3f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90837
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/stat_data.xhp | 18 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics.xhp | 1712 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_anova.xhp | 271 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_correlation.xhp | 101 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_covariance.xhp | 97 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_descriptive.xhp | 240 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_exposmooth.xhp | 177 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_fourier.xhp | 22 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_movingavg.xhp | 155 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_regression.xhp | 19 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_sampling.xhp | 234 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_test_chisqr.xhp | 91 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_test_f.xhp | 191 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_test_t.xhp | 211 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_test_z.xhp | 188 | ||||
| -rw-r--r-- | source/text/scalc/main0112.xhp | 1 |
16 files changed, 2009 insertions, 1719 deletions
diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp index 4c88b0d0b4..c47cccf20c 100644 --- a/source/text/scalc/01/stat_data.xhp +++ b/source/text/scalc/01/stat_data.xhp @@ -28,7 +28,23 @@ <paragraph id="par_id1000030" role="paragraph" xml-lang="en-US">Select whether the input data has <emph>columns</emph> or <emph>rows</emph> layout.</paragraph> </section> - <section id="sampledata01"> +<section id="otherstat"> +<embed href="text/scalc/01/statistics_sampling.xhp#datasamplingh1"/> +<embed href="text/scalc/01/statistics_descriptive.xhp#descriptivestatisticsh1"/> +<embed href="text/scalc/01/statistics_anova.xhp#anovah1"/> +<embed href="text/scalc/01/statistics_correlation.xhp#correlationh1"/> +<embed href="text/scalc/01/statistics_covariance.xhp#covarianceh1"/> +<embed href="text/scalc/01/statistics_exposmooth.xhp#exponentialsmoothingh1"/> +<embed href="text/scalc/01/statistics_movingavg.xhp#movingaverageh1"/> +<embed href="text/scalc/01/statistics_regression.xhp#regressionanalysish1"/> +<embed href="text/scalc/01/statistics_test_t.xhp#ttesth1"/> +<embed href="text/scalc/01/statistics_test_f.xhp#ftesth1"/> +<embed href="text/scalc/01/statistics_test_z.xhp#ztesth1"/> +<embed href="text/scalc/01/statistics_test_chisqr.xhp#chisqtesth1"/> +<embed href="text/scalc/01/statistics_fourier.xhp#fourieranalysysh1"/> +</section> + +<section id="sampledata01"> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id1000040" role="paragraph" xml-lang="en-US">The following data will be used as example </paragraph> diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp index e48774db3e..a81feab1b9 100644 --- a/source/text/scalc/01/statistics.xhp +++ b/source/text/scalc/01/statistics.xhp @@ -19,1707 +19,31 @@ --> <meta> -<topic id="ID" indexer="include" status="PUBLISH"> +<topic id="statisticsmenu" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Data Statistics in Calc</title> <filename>/text/scalc/01/statistics.xhp</filename> </topic> </meta> <body> -<paragraph id="hd_id1000010" role="heading" xml-lang="en-US" level="1">Data Statistics in Calc</paragraph> -<paragraph id="par_id1000010" role="paragraph" xml-lang="en-US">Use the data statistics in Calc to perform complex data analysis</paragraph> -<paragraph id="par_id1000020" role="paragraph" xml-lang="en-US">To work on a complex statistical or engineering analysis, you can save steps and time by using Calc Data Statistics. You provide the data and parameters for each analysis, and the set of tools uses the appropriate statistical or engineering functions to calculate and display the results in an output table.</paragraph> -<section id="datasampling"> -<bookmark xml-lang="en-US" branch="index" id="bm_id2764278"> -<bookmark_value>Analysis toolpack;sampling</bookmark_value> -<bookmark_value>sampling;Analysis toolpack</bookmark_value> -<bookmark_value>Data statistics;sampling</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/SamplingDialog" id="bm_id2745673" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/@@nowidget@@" id="bm_id2745673" localize="false"/> -<paragraph id="hd_id1000020" role="heading" xml-lang="en-US" level="2">Sampling</paragraph> -<paragraph id="par_id1000030" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/samplingdialog/SamplingDialog">Create a table with data sampled from another table.</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Sampling</emph></variable></paragraph> -</section> -<paragraph id="par_id1000050" role="paragraph" xml-lang="en-US">Sampling allows you to pick data from a <emph>source</emph> table to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis.</paragraph> -<paragraph id="par_id1000060" role="note" xml-lang="en-US">Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/> -<paragraph id="hd_id1000030" role="heading" xml-lang="en-US" level="3">Sampling Method</paragraph> -<paragraph id="par_id1000070" role="paragraph" xml-lang="en-US"><emph>Random</emph>: Picks exactly <emph>Sample Size</emph> lines of the source table in a random way.</paragraph> -<paragraph id="par_id1000080" role="paragraph" xml-lang="en-US"><emph>Sample size</emph>: Number of lines sampled from the source table.</paragraph> -<paragraph id="par_id1000090" role="paragraph" xml-lang="en-US"><emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>.</paragraph> -<paragraph id="par_id1000100" role="paragraph" xml-lang="en-US"><emph>Period</emph>: the number of lines to skip periodically when sampling.</paragraph> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id1000110" role="paragraph" xml-lang="en-US">The following data will be used as example of source data table for sampling:</paragraph> -<table id="Tabela1"> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -<paragraph id="par_id1000120" role="tablehead" xml-lang="en-US" localize="false">A</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000130" role="tablehead" xml-lang="en-US" localize="false">B</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000140" role="tablehead" xml-lang="en-US" localize="false">C</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000150" role="tablehead" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000160" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000170" role="tablecontent" xml-lang="en-US" localize="false">21</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000180" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000190" role="tablehead" xml-lang="en-US" localize="false">2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000200" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000210" role="tablecontent" xml-lang="en-US" localize="false">22</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000220" role="tablecontent" xml-lang="en-US" localize="false">32</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000230" role="tablehead" xml-lang="en-US" localize="false">3</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000240" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000250" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000260" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000270" role="tablehead" xml-lang="en-US" localize="false">4</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000280" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000290" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000300" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000310" role="tablehead" xml-lang="en-US" localize="false">5</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000320" role="tablecontent" xml-lang="en-US" localize="false">15</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000330" role="tablecontent" xml-lang="en-US" localize="false">25</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000340" role="tablecontent" xml-lang="en-US" localize="false">35</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000350" role="tablehead" xml-lang="en-US" localize="false">6</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000360" role="tablecontent" xml-lang="en-US" localize="false">16</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000370" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000380" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000390" role="tablehead" xml-lang="en-US" localize="false">7</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000400" role="tablecontent" xml-lang="en-US" localize="false">17</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000410" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000420" role="tablecontent" xml-lang="en-US" localize="false">37</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000430" role="tablehead" xml-lang="en-US" localize="false">8</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000440" role="tablecontent" xml-lang="en-US" localize="false">18</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000450" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000460" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000470" role="tablehead" xml-lang="en-US" localize="false">9</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000480" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000490" role="tablecontent" xml-lang="en-US" localize="false">29</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000500" role="tablecontent" xml-lang="en-US" localize="false">39</paragraph> -</tablecell> -</tablerow> -</table> - -<paragraph id="par_id1000510" role="paragraph" xml-lang="en-US">Sampling with a period of 2 will result in the following table:</paragraph> -<table id="Tabela2"> -<tablerow> -<tablecell> -<paragraph id="par_id1000520" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000530" role="tablecontent" xml-lang="en-US" localize="false">22</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000540" role="tablecontent" xml-lang="en-US" localize="false">32</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000550" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000560" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000570" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000580" role="tablecontent" xml-lang="en-US" localize="false">16</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000590" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000600" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000610" role="tablecontent" xml-lang="en-US" localize="false">18</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000620" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000630" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph> -</tablecell> -</tablerow> -</table> - -</section> -<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"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/descriptivestatisticsdialog/@@nowidget@@" id="bm_id01002" localize="false"/> -<paragraph id="hd_id1000050" role="heading" xml-lang="en-US" level="2">Descriptive Statistics</paragraph> -<paragraph id="par_id1000640" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog">Fill a table in the spreadsheet with the main statistical properties of the data set.</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1000650" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Descriptive Statistics</emph></variable></paragraph> -</section> -<paragraph id="par_id1000660" role="paragraph" xml-lang="en-US">The Descriptive Statistics analysis tool generates a report of univariate statistics for data in the input range, providing information about the central tendency and variability of your data.</paragraph> -<paragraph id="par_id1000670" role="note" xml-lang="en-US">For more information on descriptive statistics, refer to the <link href="https://en.wikipedia.org/wiki/Descriptive_statistics" name="English Wikipedia: Descriptive statistics">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/> -<paragraph id="par_id1000680" role="paragraph" xml-lang="en-US">The following table displays the results of the descriptive statistics of the sample data above.</paragraph> -<table id="Tabela4"> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -<paragraph id="par_id1000690" role="tablehead" xml-lang="en-US">Column 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000700" role="tablehead" xml-lang="en-US">Column 2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000710" role="tablehead" xml-lang="en-US">Column 3</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000720" role="tablehead" xml-lang="en-US">Mean</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000730" role="tablecontent" xml-lang="en-US" localize="false">41.9090909091</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000740" role="tablecontent" xml-lang="en-US" localize="false">59.7</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000750" role="tablecontent" xml-lang="en-US" localize="false">44.7</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000760" role="tablehead" xml-lang="en-US">Standard Error</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000770" role="tablecontent" xml-lang="en-US" localize="false">3.5610380138</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000780" role="tablecontent" xml-lang="en-US" localize="false">5.3583786934</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000790" role="tablecontent" xml-lang="en-US" localize="false">4.7680650629</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000800" role="tablehead" xml-lang="en-US">Mode</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000810" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000820" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000830" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000840" role="tablehead" xml-lang="en-US">Median</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000850" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000860" role="tablecontent" xml-lang="en-US" localize="false">64.5</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000870" role="tablecontent" xml-lang="en-US" localize="false">43.5</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000880" role="tablehead" xml-lang="en-US">Variance</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000890" role="tablecontent" xml-lang="en-US" localize="false">139.4909090909</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000900" role="tablecontent" xml-lang="en-US" localize="false">287.1222222222</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000910" role="tablecontent" xml-lang="en-US" localize="false">227.3444444444</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000920" role="tablehead" xml-lang="en-US">Standard Deviation</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000930" role="tablecontent" xml-lang="en-US" localize="false">11.8106269559</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000940" role="tablecontent" xml-lang="en-US" localize="false">16.944681237</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000950" role="tablecontent" xml-lang="en-US" localize="false">15.0779456308</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000960" role="tablehead" xml-lang="en-US">Kurtosis</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000970" role="tablecontent" xml-lang="en-US" localize="false">-1.4621677981</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000980" role="tablecontent" xml-lang="en-US" localize="false">-0.9415988746</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000990" role="tablecontent" xml-lang="en-US" localize="false">1.418052719</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001000" role="tablehead" xml-lang="en-US">Skewness</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001010" role="tablecontent" xml-lang="en-US" localize="false">0.0152409533</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001020" role="tablecontent" xml-lang="en-US" localize="false">-0.2226426904</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001030" role="tablecontent" xml-lang="en-US" localize="false">-0.9766803373</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001040" role="tablehead" xml-lang="en-US">Range</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001050" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001060" role="tablecontent" xml-lang="en-US" localize="false">51</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001070" role="tablecontent" xml-lang="en-US" localize="false">50</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001080" role="tablehead" xml-lang="en-US">Minimum</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001090" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001100" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001110" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001120" role="tablehead" xml-lang="en-US">Maximum</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001130" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001140" role="tablecontent" xml-lang="en-US" localize="false">84</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001150" role="tablecontent" xml-lang="en-US" localize="false">62</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001160" role="tablehead" xml-lang="en-US">Sum</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001170" role="tablecontent" xml-lang="en-US" localize="false">461</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001180" role="tablecontent" xml-lang="en-US" localize="false">597</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001190" role="tablecontent" xml-lang="en-US" localize="false">447</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001200" role="tablehead" xml-lang="en-US">Count</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001210" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001220" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001230" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> -</tablecell> -</tablerow> -</table> -</section> -<section id="anova"> -<bookmark xml-lang="en-US" branch="index" id="bm_id02001"> -<bookmark_value>Analysis toolpack;analysis of variance</bookmark_value> -<bookmark_value>Analysis toolpack;ANOVA</bookmark_value> -<bookmark_value>analysis of variance;Analysis toolpack</bookmark_value> -<bookmark_value>ANOVA;Analysis toolpack</bookmark_value> -<bookmark_value>Data statistics;analysis of variance</bookmark_value> -<bookmark_value>Data statistics;ANOVA</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog" id="bm_id02002" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/@@nowidget@@" id="bm_id02002" localize="false"/> -<paragraph id="hd_id1000060" role="heading" xml-lang="en-US" level="2">Analysis of Variance (ANOVA)</paragraph> -<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog">Produces the analysis of variance (ANOVA) of a given data set</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1001250" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Analysis of Variance (ANOVA)</emph></variable></paragraph> -</section> -<paragraph id="par_id1001260" role="paragraph" xml-lang="en-US">ANOVA is the acronym for <emph>AN</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. This tool produces the analysis of variance of a given data set</paragraph> -<paragraph id="par_id1001270" role="note" xml-lang="en-US">For more information on ANOVA, refer to the <link href="https://en.wikipedia.org/wiki/ANOVA" name="English Wikipedia: ANOVA">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/> -<paragraph id="hd_id1000070" role="heading" xml-lang="en-US" level="3">Type</paragraph> -<paragraph id="par_id1001280" role="paragraph" xml-lang="en-US">Select if the analysis is for a <emph>single factor</emph> or for <emph>two factor</emph> ANOVA.</paragraph> -<paragraph id="hd_id1000080" role="heading" xml-lang="en-US" level="3">Parameters</paragraph> -<paragraph id="par_id1001290" role="paragraph" xml-lang="en-US"><emph>Alpha</emph>: the level of significance of the test.</paragraph> -<paragraph id="par_id1001300" role="paragraph" xml-lang="en-US"><emph>Rows per sample</emph>: Define how many rows a sample has.</paragraph><embed href="text/scalc/01/stat_data.xhp#sampledata01"/> -<paragraph id="par_id1001310" role="paragraph" xml-lang="en-US">The following table displays the results of the <emph>analysis of variance (ANOVA)</emph> of the sample data above.</paragraph> -<table id="Tabela5"> -<tablerow> -<tablecell> -<paragraph id="par_id1001320" role="tablehead" xml-lang="en-US">ANOVA - Single Factor</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001330" role="tablecontent" xml-lang="en-US">Alpha</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001340" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001350" role="tablecontent" xml-lang="en-US">Groups</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001360" role="tablecontent" xml-lang="en-US">Count</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001370" role="tablecontent" xml-lang="en-US">Sum</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001380" role="tablecontent" xml-lang="en-US">Mean</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001390" role="tablecontent" xml-lang="en-US">Variance</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001400" role="tablecontent" xml-lang="en-US">Column 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001410" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001420" role="tablecontent" xml-lang="en-US" localize="false">461</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001430" role="tablecontent" xml-lang="en-US" localize="false">41.9090909091</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001440" role="tablecontent" xml-lang="en-US" localize="false">139.4909090909</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001450" role="tablecontent" xml-lang="en-US">Column 2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001460" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001470" role="tablecontent" xml-lang="en-US" localize="false">597</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001480" role="tablecontent" xml-lang="en-US" localize="false">59.7</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001490" role="tablecontent" xml-lang="en-US" localize="false">287.1222222222</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001500" role="tablecontent" xml-lang="en-US">Column 3</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001510" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001520" role="tablecontent" xml-lang="en-US" localize="false">447</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001530" role="tablecontent" xml-lang="en-US" localize="false">44.7</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001540" role="tablecontent" xml-lang="en-US" localize="false">227.3444444444</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001550" role="tablecontent" xml-lang="en-US">Source of Variation</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001560" role="tablecontent" xml-lang="en-US">SS</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001570" role="tablecontent" xml-lang="en-US">df</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001580" role="tablecontent" xml-lang="en-US">MS</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001590" role="tablecontent" xml-lang="en-US">F</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001600" role="tablecontent" xml-lang="en-US">P-value</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id841554943563747" role="paragraph" xml-lang="en-US" >F-critical</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001610" role="tablecontent" xml-lang="en-US">Between Groups</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001620" role="tablecontent" xml-lang="en-US" localize="false">1876.5683284457</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001630" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001640" role="tablecontent" xml-lang="en-US" localize="false">938.2841642229</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001650" role="tablecontent" xml-lang="en-US" localize="false">4.3604117704</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001660" role="tablecontent" xml-lang="en-US" localize="false">0.0224614952</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id411554944014360" role="paragraph" xml-lang="en-US" >3.340385558</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001670" role="tablecontent" xml-lang="en-US">Within Groups</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001680" role="tablecontent" xml-lang="en-US" localize="false">6025.1090909091</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001690" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001700" role="tablecontent" xml-lang="en-US" localize="false">215.1824675325</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001710" role="tablecontent" xml-lang="en-US">Total</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001720" role="tablecontent" xml-lang="en-US" localize="false">7901.6774193548</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001730" role="tablecontent" xml-lang="en-US" localize="false">30</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -</table> - -</section> -<section id="correlation"> -<bookmark xml-lang="en-US" branch="index" id="bm_id1464278"> -<bookmark_value>Analysis toolpack;correlation</bookmark_value> -<bookmark_value>correlation;Analysis toolpack</bookmark_value> -<bookmark_value>Data statistics;correlation</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/CorrelationDialog" id="bm_id3145673" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/@@nowidget@@" id="bm_id3145673" localize="false"/> -<paragraph id="hd_id1000090" role="heading" xml-lang="en-US" level="2">Correlation</paragraph> -<paragraph id="par_id1001740" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/correlationdialog/CorrelationDialog">Calculates the correlation of two sets of numeric data.</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1001750" role="paragraph" xml-lang="en-US"><variable id="corr01">Choose <emph>Data - Statistics - Correlation</emph></variable></paragraph> -</section> -<paragraph id="par_id1001760" role="paragraph" xml-lang="en-US">The correlation coefficient (a value between -1 and +1) means how strongly two variables are related to each other. You can use the CORREL function or the Data Statistics to find the correlation coefficient between two variables.</paragraph> -<paragraph id="par_id1001770" role="paragraph" xml-lang="en-US">A correlation coefficient of +1 indicates a perfect positive correlation. </paragraph> -<paragraph id="par_id1001780" role="paragraph" xml-lang="en-US">A correlation coefficient of -1 indicates a perfect negative correlation</paragraph> -<paragraph id="par_id1001790" role="note" xml-lang="en-US">For more information on statistical correlation, refer to the <link href="https://en.wikipedia.org/wiki/Correlation" name="English Wikipedia: Correlation">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/> -<paragraph id="par_id1001800" role="paragraph" xml-lang="en-US">The following table displays the results of the correlation of the sample data above.</paragraph> -<table id="Tabela6"> -<tablerow> -<tablecell> -<paragraph id="par_id1001810" role="tablehead" xml-lang="en-US">Correlations</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001820" role="tablehead" xml-lang="en-US">Column 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001830" role="tablehead" xml-lang="en-US">Column 2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001840" role="tablehead" xml-lang="en-US">Column 3</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001850" role="tablehead" xml-lang="en-US">Column 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001860" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001870" role="tablehead" xml-lang="en-US">Column 2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001880" role="tablecontent" xml-lang="en-US" localize="false">-0.4029254917</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001890" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001900" role="tablehead" xml-lang="en-US">Column 3</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001910" role="tablecontent" xml-lang="en-US" localize="false">-0.2107642836</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001920" role="tablecontent" xml-lang="en-US" localize="false">0.2309714048</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001930" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -</tablerow> -</table> - -</section> -<section id="covariance"> -<bookmark xml-lang="en-US" branch="index" id="bm_id2964278"> -<bookmark_value>Analysis toolpack;covariance</bookmark_value> -<bookmark_value>covariance;Analysis toolpack</bookmark_value> -<bookmark_value>Data statistics;covariance</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/CovarianceDialog" id="bm_id2945673" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/@@nowidget@@" id="bm_id2945673" localize="false"/> -<paragraph id="hd_id1000100" role="heading" xml-lang="en-US" level="2">Covariance</paragraph> -<paragraph id="par_id1001940" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the covariance of two sets of numeric data.</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1001950" role="paragraph" xml-lang="en-US"><variable id="cov01">Choose <emph>Data - Statistics - Covariance</emph></variable></paragraph> -</section> -<paragraph id="par_id1001960" role="paragraph" xml-lang="en-US">The covariance is a measure of how much two random variables change together.</paragraph> -<paragraph id="par_id1001970" role="note" xml-lang="en-US">For more information on statistical covariance, refer to the <link href="https://en.wikipedia.org/wiki/Covariance" name="English Wikipedia: Covariance">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/> -<paragraph id="par_id1001980" role="paragraph" xml-lang="en-US">The following table displays the results of the covariance of the sample data above.</paragraph> -<table id="Tabela7"> -<tablerow> -<tablecell> -<paragraph id="par_id1001990" role="tablehead" xml-lang="en-US">Covariances</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002000" role="tablehead" xml-lang="en-US">Column 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002010" role="tablehead" xml-lang="en-US">Column 2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002020" role="tablehead" xml-lang="en-US">Column 3</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002030" role="tablehead" xml-lang="en-US">Column 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002040" role="tablecontent" xml-lang="en-US" localize="false">126.8099173554</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002050" role="tablehead" xml-lang="en-US">Column 2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002060" role="tablecontent" xml-lang="en-US" localize="false">-61.4444444444</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002070" role="tablecontent" xml-lang="en-US" localize="false">258.41</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002080" role="tablehead" xml-lang="en-US">Column 3</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002090" role="tablecontent" xml-lang="en-US" localize="false">-32</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002100" role="tablecontent" xml-lang="en-US" localize="false">53.11</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002110" role="tablecontent" xml-lang="en-US" localize="false">204.61</paragraph> -</tablecell> -</tablerow> -</table> - -</section> -<section id="exponentialsmoothing"> -<bookmark xml-lang="en-US" branch="index" id="bm_id03001"> -<bookmark_value>Analysis toolpack;exponential smoothing</bookmark_value> -<bookmark_value>exponential smoothing;Analysis toolpack</bookmark_value> -<bookmark_value>Data statistics;exponential smoothing</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog" id="bm_id03002" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/@@nowidget@@" id="bm_id03002" localize="false"/> -<paragraph id="hd_id1000110" role="heading" xml-lang="en-US" level="2">Exponential Smoothing</paragraph> -<paragraph id="par_id1002120" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">Results in a smoothed data series</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1002130" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Exponential Smoothing</emph></variable></paragraph> -</section> -<paragraph id="par_id1002140" role="paragraph" xml-lang="en-US">Exponential smoothing is a filtering technique that when applied to a data set, produces smoothed results. It is employed in many domains such as stock market, economics and in sampled measurements.</paragraph> -<paragraph id="par_id1002150" role="note" xml-lang="en-US">For more information on exponential smoothing, refer to the <link href="https://en.wikipedia.org/wiki/Exponential_smoothing" name="English Wikipedia: Exponential smoothing">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/> -<paragraph id="hd_id1000120" role="heading" xml-lang="en-US" level="3">Parameters</paragraph> -<paragraph id="par_id1002160" role="paragraph" xml-lang="en-US"><emph>Smoothing Factor</emph>: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/> -<paragraph id="par_id1002170" role="paragraph" xml-lang="en-US">The resulting smoothing is below with smoothing factor as 0.5:</paragraph> -<table id="Tabela9"> -<tablerow> -<tablecell> -<paragraph id="par_id1002180" role="tablehead" xml-lang="en-US">Alpha</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002190" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002200" role="tablehead" xml-lang="en-US">Column 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002210" role="tablehead" xml-lang="en-US">Column 2</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002220" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002230" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002240" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002250" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002260" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002270" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002280" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002290" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002300" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002310" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002320" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002330" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002340" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002350" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002360" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002370" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002380" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002390" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002400" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002410" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002420" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002430" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002440" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002450" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002460" role="tablecontent" xml-lang="en-US" localize="false">0.0004882813</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002470" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002480" role="tablecontent" xml-lang="en-US" localize="false">0.0002441406</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002490" role="tablecontent" xml-lang="en-US" localize="false">0.0004882813</paragraph> -</tablecell> -</tablerow> -</table> +<section id="analysistoolpack"> +<h1 id="hd_id1000010"><link href="text/scalc/01/statistics.xhp" name="Data Statistics in Calc">Statistics</link></h1> +<paragraph id="par_id1000010" role="paragraph" xml-lang="en-US">Use the data statistics in Calc to perform complex data analysis</paragraph> </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"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movingaveragedialog/@@nowidget@@" id="bm_id04002" localize="false"/> -<paragraph id="hd_id1000130" role="heading" xml-lang="en-US" level="2">Moving Average</paragraph> -<paragraph id="par_id1002500" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/movingaveragedialog/MovingAverageDialog">Calculates the moving average of a time series</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1002510" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Moving Average</emph></variable></paragraph> -</section> -<paragraph id="par_id1002520" role="note" xml-lang="en-US">For more information on the moving average, refer to the <link href="https://en.wikipedia.org/wiki/Moving_average" name="English Wikipedia: Moving average">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/> -<paragraph id="hd_id1000140" role="heading" xml-lang="en-US" level="3">Parameters</paragraph> -<paragraph id="par_id1002530" role="paragraph" xml-lang="en-US"><emph>Interval</emph>: The number of samples used in the moving average calculation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/> -<paragraph id="hd_id1000171" role="heading" xml-lang="en-US" level="3">Results of the moving average:</paragraph> -<table id="Tabela10"> -<tablerow> -<tablecell> -<paragraph id="par_id1002540" role="tablehead" xml-lang="en-US">Column 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002550" role="tablehead" xml-lang="en-US">Column 2</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002560" role="tablecontent" xml-lang="en-US">#N/A</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002570" role="tablecontent" xml-lang="en-US">#N/A</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002580" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002590" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002600" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002610" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002620" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002630" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002640" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002650" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002660" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002670" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002680" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002690" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002700" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002710" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002720" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002730" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002740" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002750" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002760" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002770" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002780" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002790" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002800" role="tablecontent" xml-lang="en-US">#N/A</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002810" role="tablecontent" xml-lang="en-US">#N/A</paragraph> -</tablecell> -</tablerow> -</table> - -</section> -<section id="ttest"> -<bookmark xml-lang="en-US" branch="index" id="bm_id05001"> -<bookmark_value>Analysis toolpack;t-test</bookmark_value> -<bookmark_value>Analysis toolpack;paired t-test</bookmark_value> -<bookmark_value>t-test;Analysis toolpack</bookmark_value> -<bookmark_value>paired t-test;Analysis toolpack</bookmark_value> -<bookmark_value>Data statistics;paired t-test</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05002" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/@@nowidget@@" id="bm_id05002" localize="false"/> -<paragraph id="hd_id1000150" role="heading" xml-lang="en-US" level="2">Paired t-test</paragraph> -<paragraph id="par_id1002820" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the paired t-Test of two data samples.</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1002830" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Paired t-test</emph></variable></paragraph> -</section> -<paragraph id="par_id1002840" role="paragraph" xml-lang="en-US">A <emph>paired t-test</emph> is any statistical hypothesis test that follows a Student's t distribution.</paragraph> -<paragraph id="par_id1002850" role="note" xml-lang="en-US">For more information on paired t-tests, refer to the <link href="https://en.wikipedia.org/wiki/T-test" name="English Wikipedia: T-test">corresponding Wikipedia article</link>.</paragraph> -<paragraph id="hd_id1000160" role="heading" xml-lang="en-US" level="3">Data</paragraph> -<paragraph id="par_id1002860" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph> -<paragraph id="par_id1002870" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph> -<paragraph id="par_id1002880" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/> -<paragraph id="hd_id1000170" role="heading" xml-lang="en-US" level="3">Results for paired t-test:</paragraph> -<paragraph id="par_id1002890" role="paragraph" xml-lang="en-US">The following table shows the <emph>paired t-test</emph> for the data series above:</paragraph> -<table id="Tabela11"> -<tablerow> -<tablecell> -<paragraph id="par_id1002900" role="tablehead" xml-lang="en-US">paired t-test</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002910" role="tablecontent" xml-lang="en-US">Alpha</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002920" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002930" role="tablecontent" xml-lang="en-US">Hypothesized Mean Difference</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002940" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -<paragraph id="par_id1002950" role="tablecontent" xml-lang="en-US">Variable 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002960" role="tablecontent" xml-lang="en-US">Variable 2</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1002970" role="tablecontent" xml-lang="en-US">Mean</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002980" role="tablecontent" xml-lang="en-US" localize="false">16.9230769231</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1002990" role="tablecontent" xml-lang="en-US" localize="false">20.4615384615</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003000" role="tablecontent" xml-lang="en-US">Variance</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003010" role="tablecontent" xml-lang="en-US" localize="false">125.0769230769</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003020" role="tablecontent" xml-lang="en-US" localize="false">94.4358974359</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003030" role="tablecontent" xml-lang="en-US">Observations</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003040" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003050" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003060" role="tablecontent" xml-lang="en-US">Pearson Correlation</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003070" role="tablecontent" xml-lang="en-US" localize="false">-0.0617539772</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003080" role="tablecontent" xml-lang="en-US">Observed Mean Difference</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003090" role="tablecontent" xml-lang="en-US" localize="false">-3.5384615385</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003100" role="tablecontent" xml-lang="en-US">Variance of the Differences</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003110" role="tablecontent" xml-lang="en-US" localize="false">232.9358974359</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003120" role="tablecontent" xml-lang="en-US">df </paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003130" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003140" role="tablecontent" xml-lang="en-US">t Stat</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003150" role="tablecontent" xml-lang="en-US" localize="false">-0.8359262137</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003160" role="tablecontent" xml-lang="en-US">P (T<=t) one-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003170" role="tablecontent" xml-lang="en-US" localize="false">0.2097651442</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003180" role="tablecontent" xml-lang="en-US">t Critical one-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003190" role="tablecontent" xml-lang="en-US" localize="false">1.7822875556</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003200" role="tablecontent" xml-lang="en-US">P (T<=t) two-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003210" role="tablecontent" xml-lang="en-US" localize="false">0.4195302884</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003220" role="tablecontent" xml-lang="en-US">t Critical two-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003230" role="tablecontent" xml-lang="en-US" localize="false">2.1788128297</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -</table> - -</section> -<section id="ftest"> -<bookmark xml-lang="en-US" branch="index" id="bm_id05002"> -<bookmark_value>Analysis toolpack;F-test</bookmark_value> -<bookmark_value>F-test;Analysis toolpack</bookmark_value> -<bookmark_value>Data statistics;F-test</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05003" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/@@nowidget@@" id="@@nowidget@@" localize="false"/> -<paragraph id="hd_id1000180" role="heading" xml-lang="en-US" level="2">F-test</paragraph> -<paragraph id="par_id1003240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the F-Test of two data samples.</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1003250" role="paragraph" xml-lang="en-US"><variable id="sam02">Choose <emph>Data - Statistics - F-test</emph></variable></paragraph> -</section> -<paragraph id="par_id1003260" role="paragraph" xml-lang="en-US">A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis.</paragraph> -<paragraph id="par_id1003270" role="note" xml-lang="en-US">For more information on F-tests, refer to the <link href="https://en.wikipedia.org/wiki/F-test" name="English Wikipedia: F-test">corresponding Wikipedia article</link>.</paragraph> -<paragraph id="hd_id1000190" role="heading" xml-lang="en-US" level="3">Data</paragraph> -<paragraph id="par_id1003280" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph> -<paragraph id="par_id1003290" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph> -<paragraph id="par_id1003300" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/> -<paragraph id="hd_id1000200" role="heading" xml-lang="en-US" level="3">Results for F-Test:</paragraph> -<paragraph id="par_id1003310" role="paragraph" xml-lang="en-US">The following table shows the <emph>F-Test</emph> for the data series above:</paragraph> -<table id="Tabela12"> -<tablerow> -<tablecell> -<paragraph id="par_id1003320" role="tablecontent" xml-lang="en-US">Ftest</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003330" role="tablecontent" xml-lang="en-US">Alpha</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003340" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -<paragraph id="par_id1003350" role="tablecontent" xml-lang="en-US">Variable 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003360" role="tablecontent" xml-lang="en-US">Variable 2</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003370" role="tablecontent" xml-lang="en-US">Mean</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003380" role="tablecontent" xml-lang="en-US" localize="false">16.9230769231</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003390" role="tablecontent" xml-lang="en-US" localize="false">20.4615384615</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003400" role="tablecontent" xml-lang="en-US">Variance</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003410" role="tablecontent" xml-lang="en-US" localize="false">125.0769230769</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003420" role="tablecontent" xml-lang="en-US" localize="false">94.4358974359</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003430" role="tablecontent" xml-lang="en-US">Observations</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003440" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003450" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003460" role="tablecontent" xml-lang="en-US">df</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003470" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003480" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003490" role="tablecontent" xml-lang="en-US">F</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003500" role="tablecontent" xml-lang="en-US" localize="false">1.3244637524</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003510" role="tablecontent" xml-lang="en-US">P (F<=f) right-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003520" role="tablecontent" xml-lang="en-US" localize="false">0.3170614146</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003530" role="tablecontent" xml-lang="en-US">F Critical right-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003540" role="tablecontent" xml-lang="en-US" localize="false">2.6866371125</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003550" role="tablecontent" xml-lang="en-US">P (F<=f) left-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003560" role="tablecontent" xml-lang="en-US" localize="false">0.6829385854</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003570" role="tablecontent" xml-lang="en-US">F Critical left-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003580" role="tablecontent" xml-lang="en-US" localize="false">0.3722125312</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003590" role="tablecontent" xml-lang="en-US">P two-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003600" role="tablecontent" xml-lang="en-US" localize="false">0.6341228293</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003610" role="tablecontent" xml-lang="en-US">F Critical two-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003620" role="tablecontent" xml-lang="en-US" localize="false">0.3051313549</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003630" role="tablecontent" xml-lang="en-US" localize="false">3.277277094</paragraph> -</tablecell> -</tablerow> -</table> - -</section> -<section id="ztest"> -<bookmark xml-lang="en-US" branch="index" id="bm_id05003"> -<bookmark_value>Analysis toolpack;Z-test</bookmark_value> -<bookmark_value>Z-test;Analysis toolpack</bookmark_value> -<bookmark_value>Data statistics;Z-test</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ztestdialog/ZTestDialog" id="bm_id05004" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ztestdialog/@@nowidget@@" id="bm_id05004" localize="false"/> -<paragraph id="hd_id1000210" role="heading" xml-lang="en-US" level="2">Z-test</paragraph> -<paragraph id="par_id1003640" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ztestdialog/ZTestDialog">Calculates the z-Test of two data samples.</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1003650" role="paragraph" xml-lang="en-US"><variable id="sam02">Choose <emph>Data - Statistics - Z-test</emph></variable></paragraph> -</section> -<paragraph id="par_id1003660" role="note" xml-lang="en-US">For more information on Z-tests, refer to the <link href="https://en.wikipedia.org/wiki/Z-test" name="English Wikipedia: Z-test">corresponding Wikipedia article</link>.</paragraph> -<paragraph id="hd_id1000220" role="heading" xml-lang="en-US" level="3">Data</paragraph> -<paragraph id="par_id1003670" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph> -<paragraph id="par_id1003680" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph> -<paragraph id="par_id1003690" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/> -<paragraph id="hd_id1000230" role="heading" xml-lang="en-US" level="3">Results for z-Test:</paragraph> -<paragraph id="par_id1003700" role="paragraph" xml-lang="en-US">The following table shows the <emph>z-Test</emph> for the data series above:</paragraph> -<table id="Tabela13"> -<tablerow> -<tablecell> -<paragraph id="par_id1003710" role="tablecontent" xml-lang="en-US">z-test</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003720" role="tablecontent" xml-lang="en-US">Alpha</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003730" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003740" role="tablecontent" xml-lang="en-US">Hypothesized Mean Difference</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003750" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -<paragraph id="par_id1003760" role="tablecontent" xml-lang="en-US">Variable 1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003770" role="tablecontent" xml-lang="en-US">Variable 2</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003780" role="tablecontent" xml-lang="en-US">Known Variance</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003790" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003800" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003810" role="tablecontent" xml-lang="en-US">Mean</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003820" role="tablecontent" xml-lang="en-US" localize="false">16.9230769231</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003830" role="tablecontent" xml-lang="en-US" localize="false">20.4615384615</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003840" role="tablecontent" xml-lang="en-US">Observations</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003850" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003860" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003870" role="tablecontent" xml-lang="en-US">Observed Mean Difference</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003880" role="tablecontent" xml-lang="en-US" localize="false">-3.5384615385</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003890" role="tablecontent" xml-lang="en-US">z</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003900" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003910" role="tablecontent" xml-lang="en-US">P (Z<=z) one-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003920" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003930" role="tablecontent" xml-lang="en-US">z Critical one-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003940" role="tablecontent" xml-lang="en-US" localize="false">1.644853627</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003950" role="tablecontent" xml-lang="en-US">P (Z<=z) two-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003960" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1003970" role="tablecontent" xml-lang="en-US">z Critical two-tail</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1003980" role="tablecontent" xml-lang="en-US" localize="false">1.9599639845</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -</table> -</section> -<section id="chisqtest"> -<bookmark xml-lang="en-US" branch="index" id="bm_id05004"> -<bookmark_value>Analysis toolpack;Chi-square test</bookmark_value> -<bookmark_value>Chi-square test;Analysis toolpack</bookmark_value> -<bookmark_value>Data statistics;Chi-square test</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog" id="bm_id05005" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/chisquaretestdialog/@@nowidget@@" id="bm_id05005" localize="false"/> -<h2 id="hd_id1000240">Chi-square test</h2> -<paragraph id="par_id1003641" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog">Calculates the Chi-square test of a data sample.</ahelp></paragraph> -<section id="howtoget"> -<paragraph id="par_id1003990" role="paragraph" xml-lang="en-US"><variable id="sam02">Choose <emph>Data - Statistics - Chi-square Test</emph></variable></paragraph> -</section> -<paragraph id="par_id1004000" role="note" xml-lang="en-US">For more information on chi-square tests, refer to the <link href="https://en.wikipedia.org/wiki/Chi-square_test" name="English Wikipedia: Chi-square_test">corresponding Wikipedia article</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#datafortests"/> -<paragraph id="hd_id1000231" role="heading" xml-lang="en-US" level="3">Results for Chi-square Test:</paragraph> -<table id="tablechisq"> -<tablerow> -<tablecell> -<paragraph id="par_id1004030" role="tablehead" xml-lang="en-US">Test of Independence (Chi-Square)</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1004040" role="tablecontent" xml-lang="en-US">Alpha</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1004050" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1004060" role="tablecontent" xml-lang="en-US">df</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1004070" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1004080" role="tablecontent" xml-lang="en-US">P-value</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1004090" role="tablecontent" xml-lang="en-US" localize="false">2.32567054678584E-014</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1004100" role="tablecontent" xml-lang="en-US">Test Statistic</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1004110" role="tablecontent" xml-lang="en-US" localize="false">91.6870055842</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1004120" role="tablecontent" xml-lang="en-US">Critical Value</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1004130" role="tablecontent" xml-lang="en-US" localize="false">21.0260698175</paragraph> -</tablecell> -</tablerow> -</table> -</section> -<section id="relatedtopics"> -<paragraph id="par_id1004140" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/statistics_regression.xhp#regressionanalysis">Regression Analysis</link></paragraph> -</section> +<paragraph id="par_id1000020" role="paragraph" xml-lang="en-US">To work on a complex statistical or engineering analysis, you can save steps and time by using Calc Data Statistics. You provide the data and parameters for each analysis, and the set of tools uses the appropriate statistical or engineering functions to calculate and display the results in an output table.</paragraph> +<embed href="text/scalc/01/statistics_sampling.xhp#datasampling"/> +<embed href="text/scalc/01/statistics_descriptive.xhp#descriptivestatistics"/> +<embed href="text/scalc/01/statistics_anova.xhp#anova"/> +<embed href="text/scalc/01/statistics_correlation.xhp#correlation"/> +<embed href="text/scalc/01/statistics_covariance.xhp#covariance"/> +<embed href="text/scalc/01/statistics_exposmooth.xhp#exponentialsmoothing"/> +<embed href="text/scalc/01/statistics_movingavg.xhp#movingaverage"/> +<embed href="text/scalc/01/statistics_regression.xhp#regression"/> +<embed href="text/scalc/01/statistics_test_t.xhp#ttest"/> +<embed href="text/scalc/01/statistics_test_f.xhp#ftest"/> +<embed href="text/scalc/01/statistics_test_z.xhp#ztest"/> +<embed href="text/scalc/01/statistics_test_chisqr.xhp#chisqtest"/> +<embed href="text/scalc/01/statistics_fourier.xhp#fourieranalysis"/> </body> </helpdocument> diff --git a/source/text/scalc/01/statistics_anova.xhp b/source/text/scalc/01/statistics_anova.xhp new file mode 100644 index 0000000000..7f135330f7 --- /dev/null +++ b/source/text/scalc/01/statistics_anova.xhp @@ -0,0 +1,271 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + +<meta> +<topic id="anovatopic" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">ANOVA</title> +<filename>/text/scalc/01/statistics_anova.xhp</filename> +</topic> +</meta> +<body> +<bookmark xml-lang="en-US" branch="index" id="bm_id02001"> +<bookmark_value>Analysis toolpack;analysis of variance</bookmark_value> +<bookmark_value>Analysis toolpack;ANOVA</bookmark_value> +<bookmark_value>analysis of variance;Analysis toolpack</bookmark_value> +<bookmark_value>ANOVA;Analysis toolpack</bookmark_value> +<bookmark_value>Data statistics;analysis of variance</bookmark_value> +<bookmark_value>Data statistics;ANOVA</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog" id="bm_id02002" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/@@nowidget@@" id="bm_id02002" localize="false"/> +<section id="anova"> +<h1 id="hd_id1000060"><variable id="anovah1"><link href="text/scalc/01/statistics_anova.xhp" name="Analysis of Variance (ANOVA)">Analysis of Variance (ANOVA)</link></variable></h1> +<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog">Produces the analysis of variance (ANOVA) of a given data set</ahelp></paragraph> + </section> +<section id="howtoget"> +<paragraph id="par_id1001250" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Analysis of Variance (ANOVA)</menuitem></variable></paragraph> +</section> +<paragraph id="par_id1001260" role="paragraph" xml-lang="en-US">ANOVA is the acronym for <emph>AN</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. This tool produces the analysis of variance of a given data set</paragraph> +<note id="par_id1001270">For more information on ANOVA, refer to the <link href="https://en.wikipedia.org/wiki/ANOVA" name="English Wikipedia: ANOVA">corresponding Wikipedia article</link>.</note> +<embed href="text/scalc/01/stat_data.xhp#data"/> +<embed href="text/scalc/01/stat_data.xhp#grouped"/> +<h2 id="hd_id1000070">Type</h2> +<paragraph id="par_id1001280" role="paragraph" xml-lang="en-US">Select if the analysis is for a <emph>single factor</emph> or for <emph>two factor</emph> ANOVA.</paragraph> +<h2 id="hd_id1000080">Parameters</h2> +<paragraph id="par_id1001290" role="paragraph" xml-lang="en-US"><emph>Alpha</emph>: the level of significance of the test.</paragraph> +<paragraph id="par_id1001300" role="paragraph" xml-lang="en-US"><emph>Rows per sample</emph>: Define how many rows a sample has.</paragraph> + +<embed href="text/scalc/01/stat_data.xhp#sampledata01"/> + +<paragraph id="par_id1001310" role="paragraph" xml-lang="en-US">The following table displays the results of the <emph>analysis of variance (ANOVA)</emph> of the sample data above.</paragraph> +<table id="Tabela5"> +<tablerow> +<tablecell> +<paragraph id="par_id1001320" role="tablehead" xml-lang="en-US">ANOVA - Single Factor</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001330" role="tablecontent" xml-lang="en-US">Alpha</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001340" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001350" role="tablecontent" xml-lang="en-US">Groups</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001360" role="tablecontent" xml-lang="en-US">Count</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001370" role="tablecontent" xml-lang="en-US">Sum</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001380" role="tablecontent" xml-lang="en-US">Mean</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001390" role="tablecontent" xml-lang="en-US">Variance</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001400" role="tablecontent" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001410" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001420" role="tablecontent" xml-lang="en-US" localize="false">461</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001430" role="tablecontent" xml-lang="en-US" localize="false">41.9090909091</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001440" role="tablecontent" xml-lang="en-US" localize="false">139.4909090909</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001450" role="tablecontent" xml-lang="en-US">Column 2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001460" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001470" role="tablecontent" xml-lang="en-US" localize="false">597</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001480" role="tablecontent" xml-lang="en-US" localize="false">59.7</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001490" role="tablecontent" xml-lang="en-US" localize="false">287.1222222222</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001500" role="tablecontent" xml-lang="en-US">Column 3</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001510" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001520" role="tablecontent" xml-lang="en-US" localize="false">447</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001530" role="tablecontent" xml-lang="en-US" localize="false">44.7</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001540" role="tablecontent" xml-lang="en-US" localize="false">227.3444444444</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001550" role="tablecontent" xml-lang="en-US">Source of Variation</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001560" role="tablecontent" xml-lang="en-US">SS</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001570" role="tablecontent" xml-lang="en-US">df</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001580" role="tablecontent" xml-lang="en-US">MS</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001590" role="tablecontent" xml-lang="en-US">F</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001600" role="tablecontent" xml-lang="en-US">P-value</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id841554943563747" role="paragraph" xml-lang="en-US">F-critical</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001610" role="tablecontent" xml-lang="en-US">Between Groups</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001620" role="tablecontent" xml-lang="en-US" localize="false">1876.5683284457</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001630" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001640" role="tablecontent" xml-lang="en-US" localize="false">938.2841642229</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001650" role="tablecontent" xml-lang="en-US" localize="false">4.3604117704</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001660" role="tablecontent" xml-lang="en-US" localize="false">0.0224614952</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id411554944014360" role="paragraph" xml-lang="en-US">3.340385558</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001670" role="tablecontent" xml-lang="en-US">Within Groups</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001680" role="tablecontent" xml-lang="en-US" localize="false">6025.1090909091</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001690" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001700" role="tablecontent" xml-lang="en-US" localize="false">215.1824675325</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001710" role="tablecontent" xml-lang="en-US">Total</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001720" role="tablecontent" xml-lang="en-US" localize="false">7901.6774193548</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001730" role="tablecontent" xml-lang="en-US" localize="false">30</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_correlation.xhp b/source/text/scalc/01/statistics_correlation.xhp new file mode 100644 index 0000000000..43b1b5d5d1 --- /dev/null +++ b/source/text/scalc/01/statistics_correlation.xhp @@ -0,0 +1,101 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + +<meta> +<topic id="ID" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Data Correlation in Calc</title> +<filename>/text/scalc/01/statistics_correlation.xhp</filename> +</topic> +</meta> +<body> + +<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"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/@@nowidget@@" id="bm_id3145673" localize="false"/> +<section id="correlation"> +<h1 id="hd_id1000090"><variable id="correlationh1"><link href="text/scalc/01/statistics_correlation.xhp" name="Correlation">Correlation</link></variable></h1> +<paragraph id="par_id1001740" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/correlationdialog/CorrelationDialog">Calculates the correlation of two sets of numeric data.</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1001750" role="paragraph" xml-lang="en-US"><variable id="corr01">Choose <menuitem>Data - Statistics - Correlation</menuitem></variable></paragraph> +</section> +<paragraph id="par_id1001760" role="paragraph" xml-lang="en-US">The correlation coefficient (a value between -1 and +1) means how strongly two variables are related to each other. You can use the CORREL function or the Data Statistics to find the correlation coefficient between two variables.</paragraph> +<paragraph id="par_id1001770" role="paragraph" xml-lang="en-US">A correlation coefficient of +1 indicates a perfect positive correlation. </paragraph> +<paragraph id="par_id1001780" role="paragraph" xml-lang="en-US">A correlation coefficient of -1 indicates a perfect negative correlation</paragraph> +<note id="par_id1001790">For more information on statistical correlation, refer to the <link href="https://en.wikipedia.org/wiki/Correlation" name="English Wikipedia: Correlation">corresponding Wikipedia article</link>.</note> +<embed href="text/scalc/01/stat_data.xhp#data"/> +<embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/01/stat_data.xhp#sampledata01"/> +<paragraph id="par_id1001800" role="paragraph" xml-lang="en-US">The following table displays the results of the correlation of the sample data above.</paragraph> +<table id="Tabela6"> +<tablerow> +<tablecell> +<paragraph id="par_id1001810" role="tablehead" xml-lang="en-US">Correlations</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001820" role="tablehead" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001830" role="tablehead" xml-lang="en-US">Column 2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001840" role="tablehead" xml-lang="en-US">Column 3</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001850" role="tablehead" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001860" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001870" role="tablehead" xml-lang="en-US">Column 2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001880" role="tablecontent" xml-lang="en-US" localize="false">-0.4029254917</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001890" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001900" role="tablehead" xml-lang="en-US">Column 3</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001910" role="tablecontent" xml-lang="en-US" localize="false">-0.2107642836</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001920" role="tablecontent" xml-lang="en-US" localize="false">0.2309714048</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001930" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_covariance.xhp b/source/text/scalc/01/statistics_covariance.xhp new file mode 100644 index 0000000000..b2b4d1d96c --- /dev/null +++ b/source/text/scalc/01/statistics_covariance.xhp @@ -0,0 +1,97 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + +<meta> +<topic id="ID" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Data Covariance in Calc</title> +<filename>/text/scalc/01/statistics_covariance.xhp</filename> +</topic> +</meta> +<body> +<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"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/@@nowidget@@" id="bm_id2945673" localize="false"/> +<section id="covariance"> + <h1 id="hd_id1000100"><variable id="covarianceh1"><link href="text/scalc/01/statistics_covariance.xhp" name="Covariance">Covariance</link></variable></h1> +<paragraph id="par_id1001940" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the covariance of two sets of numeric data.</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1001950" role="paragraph" xml-lang="en-US"><variable id="cov01">Choose <menuitem>Data - Statistics - Covariance</menuitem></variable></paragraph> +</section> +<paragraph id="par_id1001960" role="paragraph" xml-lang="en-US">The covariance is a measure of how much two random variables change together.</paragraph> +<note id="par_id1001970">For more information on statistical covariance, refer to the <link href="https://en.wikipedia.org/wiki/Covariance" name="English Wikipedia: Covariance">corresponding Wikipedia article</link>.</note> +<embed href="text/scalc/01/stat_data.xhp#data"/> +<embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/> +<paragraph id="par_id1001980" role="paragraph" xml-lang="en-US">The following table displays the results of the covariance of the sample data above.</paragraph> +<table id="Tabela7"> +<tablerow> +<tablecell> +<paragraph id="par_id1001990" role="tablehead" xml-lang="en-US">Covariances</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002000" role="tablehead" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002010" role="tablehead" xml-lang="en-US">Column 2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002020" role="tablehead" xml-lang="en-US">Column 3</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002030" role="tablehead" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002040" role="tablecontent" xml-lang="en-US" localize="false">126.8099173554</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002050" role="tablehead" xml-lang="en-US">Column 2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002060" role="tablecontent" xml-lang="en-US" localize="false">-61.4444444444</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002070" role="tablecontent" xml-lang="en-US" localize="false">258.41</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002080" role="tablehead" xml-lang="en-US">Column 3</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002090" role="tablecontent" xml-lang="en-US" localize="false">-32</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002100" role="tablecontent" xml-lang="en-US" localize="false">53.11</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002110" role="tablecontent" xml-lang="en-US" localize="false">204.61</paragraph> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_descriptive.xhp b/source/text/scalc/01/statistics_descriptive.xhp new file mode 100644 index 0000000000..ac0c94da04 --- /dev/null +++ b/source/text/scalc/01/statistics_descriptive.xhp @@ -0,0 +1,240 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. +--> + +<meta> +<topic id="ID" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Descriptive Statistics in Calc</title> +<filename>/text/scalc/01/statistics_descriptive.xhp</filename> +</topic> +</meta> +<body> + +<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"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/descriptivestatisticsdialog/@@nowidget@@" id="bm_id01002" localize="false"/> +<section id="descriptivestatistics"> + <h1 id="hd_id1000050"><variable id="descriptivestatisticsh1"><link href="text/scalc/01/statistics_descriptive.xhp" name="Descriptive Statistics">Descriptive Statistics</link></variable></h1> +<paragraph id="par_id1000640" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog">Fill a table in the spreadsheet with the main statistical properties of the data set.</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1000650" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Descriptive Statistics</menuitem></variable></paragraph> +</section> +<paragraph id="par_id1000660" role="paragraph" xml-lang="en-US">The Descriptive Statistics analysis tool generates a report of univariate statistics for data in the input range, providing information about the central tendency and variability of your data.</paragraph> +<note id="par_id1000670">For more information on descriptive statistics, refer to the <link href="https://en.wikipedia.org/wiki/Descriptive_statistics" name="English Wikipedia: Descriptive statistics">corresponding Wikipedia article</link>.</note> +<embed href="text/scalc/01/stat_data.xhp#data"/> +<embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/01/stat_data.xhp#sampledata01"/> +<paragraph id="par_id1000680" role="paragraph" xml-lang="en-US">The following table displays the results of the descriptive statistics of the sample data above.</paragraph> +<table id="Tabela4"> +<tablerow> +<tablecell> +</tablecell> +<tablecell> +<paragraph id="par_id1000690" role="tablehead" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000700" role="tablehead" xml-lang="en-US">Column 2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000710" role="tablehead" xml-lang="en-US">Column 3</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000720" role="tablehead" xml-lang="en-US">Mean</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000730" role="tablecontent" xml-lang="en-US" localize="false">41.9090909091</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000740" role="tablecontent" xml-lang="en-US" localize="false">59.7</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000750" role="tablecontent" xml-lang="en-US" localize="false">44.7</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000760" role="tablehead" xml-lang="en-US">Standard Error</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000770" role="tablecontent" xml-lang="en-US" localize="false">3.5610380138</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000780" role="tablecontent" xml-lang="en-US" localize="false">5.3583786934</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000790" role="tablecontent" xml-lang="en-US" localize="false">4.7680650629</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000800" role="tablehead" xml-lang="en-US">Mode</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000810" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000820" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000830" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000840" role="tablehead" xml-lang="en-US">Median</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000850" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000860" role="tablecontent" xml-lang="en-US" localize="false">64.5</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000870" role="tablecontent" xml-lang="en-US" localize="false">43.5</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000880" role="tablehead" xml-lang="en-US">Variance</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000890" role="tablecontent" xml-lang="en-US" localize="false">139.4909090909</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000900" role="tablecontent" xml-lang="en-US" localize="false">287.1222222222</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000910" role="tablecontent" xml-lang="en-US" localize="false">227.3444444444</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000920" role="tablehead" xml-lang="en-US">Standard Deviation</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000930" role="tablecontent" xml-lang="en-US" localize="false">11.8106269559</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000940" role="tablecontent" xml-lang="en-US" localize="false">16.944681237</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000950" role="tablecontent" xml-lang="en-US" localize="false">15.0779456308</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000960" role="tablehead" xml-lang="en-US">Kurtosis</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000970" role="tablecontent" xml-lang="en-US" localize="false">-1.4621677981</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000980" role="tablecontent" xml-lang="en-US" localize="false">-0.9415988746</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000990" role="tablecontent" xml-lang="en-US" localize="false">1.418052719</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001000" role="tablehead" xml-lang="en-US">Skewness</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001010" role="tablecontent" xml-lang="en-US" localize="false">0.0152409533</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001020" role="tablecontent" xml-lang="en-US" localize="false">-0.2226426904</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001030" role="tablecontent" xml-lang="en-US" localize="false">-0.9766803373</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001040" role="tablehead" xml-lang="en-US">Range</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001050" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001060" role="tablecontent" xml-lang="en-US" localize="false">51</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001070" role="tablecontent" xml-lang="en-US" localize="false">50</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001080" role="tablehead" xml-lang="en-US">Minimum</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001090" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001100" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001110" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001120" role="tablehead" xml-lang="en-US">Maximum</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001130" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001140" role="tablecontent" xml-lang="en-US" localize="false">84</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001150" role="tablecontent" xml-lang="en-US" localize="false">62</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001160" role="tablehead" xml-lang="en-US">Sum</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001170" role="tablecontent" xml-lang="en-US" localize="false">461</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001180" role="tablecontent" xml-lang="en-US" localize="false">597</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001190" role="tablecontent" xml-lang="en-US" localize="false">447</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001200" role="tablehead" xml-lang="en-US">Count</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001210" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001220" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001230" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_exposmooth.xhp b/source/text/scalc/01/statistics_exposmooth.xhp new file mode 100644 index 0000000000..4ff6a3e1fe --- /dev/null +++ b/source/text/scalc/01/statistics_exposmooth.xhp @@ -0,0 +1,177 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + --> + +<meta> +<topic id="exponentialsmooth" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Exponential Smoothing in Calc</title> +<filename>/text/scalc/01/statistics_exposmooth.xhp</filename> +</topic> +</meta> +<body> +<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"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/@@nowidget@@" id="bm_id03002" localize="false"/> +<section id="exponentialsmoothing"> + <h1 id="hd_id1000110"><variable id="exponentialsmoothingh1"><link href="text/scalc/01/statistics_exposmooth.xhp" name="Exponential Smoothing">Exponential Smoothing</link></variable></h1> +<paragraph id="par_id1002120" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">Results in a smoothed data series</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1002130" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Exponential Smoothing</menuitem></variable></paragraph> +</section> +<paragraph id="par_id1002140" role="paragraph" xml-lang="en-US">Exponential smoothing is a filtering technique that when applied to a data set, produces smoothed results. It is employed in many domains such as stock market, economics and in sampled measurements.</paragraph> +<note id="par_id1002150">For more information on exponential smoothing, refer to the <link href="https://en.wikipedia.org/wiki/Exponential_smoothing" name="English Wikipedia: Exponential smoothing">corresponding Wikipedia article</link>.</note><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/> +<h2 id="hd_id1000120">Parameters</h2> +<paragraph id="par_id1002160" role="paragraph" xml-lang="en-US"><emph>Smoothing Factor</emph>: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/> +<paragraph id="par_id1002170" role="paragraph" xml-lang="en-US">The resulting smoothing is below with smoothing factor as 0.5:</paragraph> +<table id="Tabela9"> +<tablerow> +<tablecell> +<paragraph id="par_id1002180" role="tablehead" xml-lang="en-US">Alpha</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002190" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002200" role="tablehead" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002210" role="tablehead" xml-lang="en-US">Column 2</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002220" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002230" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002240" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002250" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002260" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002270" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002280" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002290" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002300" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002310" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002320" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002330" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002340" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002350" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002360" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002370" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002380" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002390" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002400" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002410" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002420" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002430" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002440" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002450" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002460" role="tablecontent" xml-lang="en-US" localize="false">0.0004882813</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002470" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002480" role="tablecontent" xml-lang="en-US" localize="false">0.0002441406</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002490" role="tablecontent" xml-lang="en-US" localize="false">0.0004882813</paragraph> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_fourier.xhp b/source/text/scalc/01/statistics_fourier.xhp index 383cb88576..34d0b635d6 100644 --- a/source/text/scalc/01/statistics_fourier.xhp +++ b/source/text/scalc/01/statistics_fourier.xhp @@ -19,18 +19,18 @@ <body> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/fourieranalysisdialog/FourierAnalysisDialog" id="bm_id2345673" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/regressiondialog/@@nowidget@@" id="bm_id2745673" localize="false"/> - - <h1 id="hd_id431561808831965"><variable id="fourieranalysysh1"><link href="text/scalc/01/statistics_fourier.xhp" name="Fourier analysis">Fourier Analysis</link></variable></h1> - <paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/regressiondialog/RegressionDialog">Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp></paragraph> - - <section id="fourieranalysis"> <bookmark xml-lang="en-US" branch="index" id="bm_id2764278"> <bookmark_value>Analysis toolpack;Fourier analysis</bookmark_value> <bookmark_value>Fourier analysis;Analysis toolpack</bookmark_value> <bookmark_value>Data statistics;Fourier analysis</bookmark_value> </bookmark> + + <section id="fourieranalysis"> + <h1 id="hd_id431561808831965"><variable id="fourieranalysysh1"><link href="text/scalc/01/statistics_fourier.xhp" name="Fourier analysis">Fourier Analysis</link></variable></h1> + <paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/regressiondialog/RegressionDialog">Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp></paragraph> +</section> <section id="howtoget"> - <paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Fourier Analysis</emph></variable></paragraph> + <paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Fourier Analysis</menuitem></variable></paragraph> </section> <note id="par_id1001270">For more information on Fourier analysis, refer to the <link href="https://en.wikipedia.org/wiki/Fourier_analysis" name="English Wikipedia: Fourier analysis">corresponding Wikipedia article</link>.</note> @@ -645,12 +645,8 @@ </tablecell> </tablerow> </table> - - <section id="relatedtopics"> - <embed href="text/scalc/01/func_fourier.xhp#fourierfunct"/> - <embed href="text/scalc/01/statistics_regression.xhp#regressionanalysish1"/> - <paragraph id="par_id14337286612130" role="paragraph" xml-lang="en-US"> <link href="text/scalc/01/statistics.xhp#datasampling">Sampling</link>, <link href="text/scalc/01/statistics.xhp#descriptivestatistics">Descriptive Statistics</link>, <link href="text/scalc/01/statistics.xhp#anova">Analysis of Variance (ANOVA)</link>, <link href="text/scalc/01/statistics.xhp#correlation">Correlation</link>, <link href="text/scalc/01/statistics.xhp#covariance">Covariance</link>, <link href="text/scalc/01/statistics.xhp#exponentialsmoothing">Exponential Smoothing</link>, <link href="text/scalc/01/statistics.xhp#movingaverage">Moving Average</link>, <link href="text/scalc/01/statistics.xhp#ttest">Paired t-test</link>, <link href="text/scalc/01/statistics.xhp#ftest">F-test</link>, <link href="text/scalc/01/statistics.xhp#ztest">Z-test</link>, <link href="text/scalc/01/statistics.xhp#chisqtest">Chi-square test</link>.</paragraph> - </section> - </section> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/statistics_movingavg.xhp b/source/text/scalc/01/statistics_movingavg.xhp new file mode 100644 index 0000000000..1a9faf27e3 --- /dev/null +++ b/source/text/scalc/01/statistics_movingavg.xhp @@ -0,0 +1,155 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + --> + +<meta> +<topic id="movingavgtopic" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Moving Average in Calc</title> +<filename>/text/scalc/01/statistics_movingavg.xhp</filename> +</topic> +</meta> +<body> + +<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"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movingaveragedialog/@@nowidget@@" id="bm_id04002" localize="false"/> +<section id="movingaverage"> +<h1 id="hd_id1000130"><variable id="movingaverageh1"><link href="text/scalc/01/statistics_movingavg.xhp" name="Moving Average">Moving Average</link></variable></h1> +<paragraph id="par_id1002500" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/movingaveragedialog/MovingAverageDialog">Calculates the moving average of a time series</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1002510" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Moving Average</menuitem></variable></paragraph> +</section> +<note id="par_id1002520">For more information on the moving average, refer to the <link href="https://en.wikipedia.org/wiki/Moving_average" name="English Wikipedia: Moving average">corresponding Wikipedia article</link>.</note><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/> +<h2 id="hd_id1000140">Parameters</h2> +<paragraph id="par_id1002530" role="paragraph" xml-lang="en-US"><emph>Interval</emph>: The number of samples used in the moving average calculation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/> +<h2 id="hd_id1000171">Results of the moving average:</h2> +<table id="Tabela10"> +<tablerow> +<tablecell> +<paragraph id="par_id1002540" role="tablehead" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002550" role="tablehead" xml-lang="en-US">Column 2</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002560" role="tablecontent" xml-lang="en-US">#N/A</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002570" role="tablecontent" xml-lang="en-US">#N/A</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002580" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002590" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002600" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002610" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002620" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002630" role="tablecontent" xml-lang="en-US" localize="false">0.3333333333</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002640" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002650" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002660" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002670" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002680" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002690" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002700" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002710" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002720" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002730" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002740" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002750" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002760" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002770" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002780" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002790" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002800" role="tablecontent" xml-lang="en-US">#N/A</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002810" role="tablecontent" xml-lang="en-US">#N/A</paragraph> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_regression.xhp b/source/text/scalc/01/statistics_regression.xhp index 456dad892d..7be159b68a 100644 --- a/source/text/scalc/01/statistics_regression.xhp +++ b/source/text/scalc/01/statistics_regression.xhp @@ -19,17 +19,12 @@ --> <meta> - <topic id="ID" indexer="include" status="PUBLISH"> + <topic id="regressiontopic" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Regression Analysis</title> <filename>/text/scalc/01/statistics_regression.xhp</filename> </topic> </meta> - <body> - -<h1 id="hd_id1701201615033510"><variable id="regressionanalysish1"><link href="text/scalc/01/statistics_regression.xhp" name="regression analysis">Regression Analysis</link></variable></h1> -<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/regressiondialog/RegressionDialog">Produces the regression analysis of a data set</ahelp></paragraph> - <bookmark xml-lang="en-US" branch="index" id="bm_id2764278"> <bookmark_value>Analysis toolpack;regression analysis</bookmark_value> <bookmark_value>regression analysis;Analysis toolpack</bookmark_value> @@ -38,15 +33,19 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/regressiondialog/RegressionDialog" id="bm_id2745673" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/regressiondialog/@@nowidget@@" id="bm_id2745673" localize="false"/> +<section id="regression"> +<h1 id="hd_id1701201615033510"><variable id="regressionanalysish1"><link href="text/scalc/01/statistics_regression.xhp" name="regression analysis">Regression Analysis</link></variable></h1> +<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/regressiondialog/RegressionDialog">Produces the regression analysis of a data set</ahelp></paragraph> +</section> <section id="howtoget"> -<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Regression</emph></variable></paragraph> +<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Regression</menuitem></variable></paragraph> </section> <paragraph id="par_id1001270" role="note" xml-lang="en-US">For more information on regression analysis, refer to the <link href="https://en.wikipedia.org/wiki/Regression_analysis" name="English Wikipedia: Regression analysis">corresponding Wikipedia article</link>.</paragraph> <embed href="text/scalc/01/stat_data.xhp#data"/> <embed href="text/scalc/01/stat_data.xhp#grouped"/> -<paragraph id="hd_id1000070" role="heading" level="3" xml-lang="en-US">Output Regression Type</paragraph> +<h2 id="hd_id1000070">Output Regression Type</h2> <paragraph id="par_id1001280" role="paragraph" xml-lang="en-US">Set the regression type. Three types are available: </paragraph> <list type="unordered"> @@ -315,10 +314,8 @@ </tablecell> </tablerow> </table> - <section id="relatedtopics"> - <embed href="text/scalc/01/statistics_fourier.xhp#fourieranalysysh1"/> -<paragraph id="par_id14337286612130" role="paragraph" xml-lang="en-US"> <link href="text/scalc/01/statistics.xhp#datasampling">Sampling</link>, <link href="text/scalc/01/statistics.xhp#descriptivestatistics">Descriptive Statistics</link>, <link href="text/scalc/01/statistics.xhp#anova">Analysis of Variance (ANOVA)</link>, <link href="text/scalc/01/statistics.xhp#correlation">Correlation</link>, <link href="text/scalc/01/statistics.xhp#covariance">Covariance</link>, <link href="text/scalc/01/statistics.xhp#exponentialsmoothing">Exponential Smoothing</link>, <link href="text/scalc/01/statistics.xhp#movingaverage">Moving Average</link>, <link href="text/scalc/01/statistics.xhp#ttest">Paired t-test</link>, <link href="text/scalc/01/statistics.xhp#ftest">F-test</link>, <link href="text/scalc/01/statistics.xhp#ztest">Z-test</link>, <link href="text/scalc/01/statistics.xhp#chisqtest">Chi-square test</link>.</paragraph> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/statistics_sampling.xhp b/source/text/scalc/01/statistics_sampling.xhp new file mode 100644 index 0000000000..219efe1844 --- /dev/null +++ b/source/text/scalc/01/statistics_sampling.xhp @@ -0,0 +1,234 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + --> + +<meta> +<topic id="datasampligtopic" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Data Sampling in Calc</title> +<filename>/text/scalc/01/statistics_sampling.xhp</filename> +</topic> +</meta> +<body> +<bookmark xml-lang="en-US" branch="index" id="bm_id2764278"> +<bookmark_value>Analysis toolpack;sampling</bookmark_value> +<bookmark_value>sampling;Analysis toolpack</bookmark_value> +<bookmark_value>Data statistics;sampling</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/SamplingDialog" id="bm_id2745673" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/@@nowidget@@" id="bm_id2745673" localize="false"/> +<section id="datasampling"> +<h1 id="hd_id1000020"><variable id="datasamplingh1"><link href="text/scalc/01/statistics_sampling.xhp" name="Sampling">Sampling</link></variable></h1> +<paragraph id="par_id1000030" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/samplingdialog/SamplingDialog">Create a table with data sampled from another table.</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Sampling</menuitem></variable></paragraph> +</section> +<paragraph id="par_id1000050" role="paragraph" xml-lang="en-US">Sampling allows you to pick data from a <emph>source</emph> table to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis.</paragraph> +<note id="par_id1000060">Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table.</note><embed href="text/scalc/01/stat_data.xhp#data"/> +<h2 id="hd_id1000030">Sampling Method</h2> +<paragraph id="par_id1000070" role="paragraph" xml-lang="en-US"><emph>Random</emph>: Picks exactly <emph>Sample Size</emph> lines of the source table in a random way.</paragraph> +<paragraph id="par_id1000080" role="paragraph" xml-lang="en-US"><emph>Sample size</emph>: Number of lines sampled from the source table.</paragraph> +<paragraph id="par_id1000090" role="paragraph" xml-lang="en-US"><emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>.</paragraph> +<paragraph id="par_id1000100" role="paragraph" xml-lang="en-US"><emph>Period</emph>: the number of lines to skip periodically when sampling.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph id="par_id1000110" role="paragraph" xml-lang="en-US">The following data will be used as example of source data table for sampling:</paragraph> +<table id="Tabela1"> +<tablerow> +<tablecell> +</tablecell> +<tablecell> +<paragraph id="par_id1000120" role="tablehead" xml-lang="en-US" localize="false">A</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000130" role="tablehead" xml-lang="en-US" localize="false">B</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000140" role="tablehead" xml-lang="en-US" localize="false">C</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000150" role="tablehead" xml-lang="en-US" localize="false">1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000160" role="tablecontent" xml-lang="en-US" localize="false">11</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000170" role="tablecontent" xml-lang="en-US" localize="false">21</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000180" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000190" role="tablehead" xml-lang="en-US" localize="false">2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000200" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000210" role="tablecontent" xml-lang="en-US" localize="false">22</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000220" role="tablecontent" xml-lang="en-US" localize="false">32</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000230" role="tablehead" xml-lang="en-US" localize="false">3</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000240" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000250" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000260" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000270" role="tablehead" xml-lang="en-US" localize="false">4</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000280" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000290" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000300" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000310" role="tablehead" xml-lang="en-US" localize="false">5</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000320" role="tablecontent" xml-lang="en-US" localize="false">15</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000330" role="tablecontent" xml-lang="en-US" localize="false">25</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000340" role="tablecontent" xml-lang="en-US" localize="false">35</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000350" role="tablehead" xml-lang="en-US" localize="false">6</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000360" role="tablecontent" xml-lang="en-US" localize="false">16</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000370" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000380" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000390" role="tablehead" xml-lang="en-US" localize="false">7</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000400" role="tablecontent" xml-lang="en-US" localize="false">17</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000410" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000420" role="tablecontent" xml-lang="en-US" localize="false">37</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000430" role="tablehead" xml-lang="en-US" localize="false">8</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000440" role="tablecontent" xml-lang="en-US" localize="false">18</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000450" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000460" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000470" role="tablehead" xml-lang="en-US" localize="false">9</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000480" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000490" role="tablecontent" xml-lang="en-US" localize="false">29</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000500" role="tablecontent" xml-lang="en-US" localize="false">39</paragraph> +</tablecell> +</tablerow> +</table> + +<paragraph id="par_id1000510" role="paragraph" xml-lang="en-US">Sampling with a period of 2 will result in the following table:</paragraph> +<table id="Tabela2"> +<tablerow> +<tablecell> +<paragraph id="par_id1000520" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000530" role="tablecontent" xml-lang="en-US" localize="false">22</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000540" role="tablecontent" xml-lang="en-US" localize="false">32</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000550" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000560" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000570" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000580" role="tablecontent" xml-lang="en-US" localize="false">16</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000590" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000600" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1000610" role="tablecontent" xml-lang="en-US" localize="false">18</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000620" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1000630" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_test_chisqr.xhp b/source/text/scalc/01/statistics_test_chisqr.xhp new file mode 100644 index 0000000000..04052f5470 --- /dev/null +++ b/source/text/scalc/01/statistics_test_chisqr.xhp @@ -0,0 +1,91 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * +--> + +<meta> +<topic id="chisquaretest" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Chi Square Statistics in Calc</title> +<filename>/text/scalc/01/statistics_test_chisqr.xhp</filename> +</topic> +</meta> +<body> +<bookmark xml-lang="en-US" branch="index" id="bm_id05004"> +<bookmark_value>Analysis toolpack;Chi-square test</bookmark_value> +<bookmark_value>Chi-square test;Analysis toolpack</bookmark_value> +<bookmark_value>Data statistics;Chi-square test</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog" id="bm_id05005" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/chisquaretestdialog/@@nowidget@@" id="bm_id05005" localize="false"/> +<section id="chisqtest"> + <h1 id="hd_id1000240"><variable id="chisqtesth1"><link href="text/scalc/01/statistics_test_chisqr.xhp" name="Chi-square test">Chi-square test</link></variable></h1> +<paragraph id="par_id1003641" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog">Calculates the Chi-square test of a data sample.</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1003990" role="paragraph" xml-lang="en-US"><variable id="sam02">Choose <menuitem>Data - Statistics - Chi-square Test</menuitem></variable></paragraph> +</section> +<note id="par_id1004000">For more information on chi-square tests, refer to the <link href="https://en.wikipedia.org/wiki/Chi-square_test" name="English Wikipedia: Chi-square_test">corresponding Wikipedia article</link>.</note> +<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#datafortests"/> +<h2 id="hd_id1000231">Results for Chi-square Test:</h2> +<table id="tablechisq"> +<tablerow> +<tablecell> +<paragraph id="par_id1004030" role="tablehead" xml-lang="en-US">Test of Independence (Chi-Square)</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1004040" role="tablecontent" xml-lang="en-US">Alpha</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1004050" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1004060" role="tablecontent" xml-lang="en-US">df</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1004070" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1004080" role="tablecontent" xml-lang="en-US">P-value</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1004090" role="tablecontent" xml-lang="en-US" localize="false">2.32567054678584E-014</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1004100" role="tablecontent" xml-lang="en-US">Test Statistic</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1004110" role="tablecontent" xml-lang="en-US" localize="false">91.6870055842</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1004120" role="tablecontent" xml-lang="en-US">Critical Value</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1004130" role="tablecontent" xml-lang="en-US" localize="false">21.0260698175</paragraph> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_test_f.xhp b/source/text/scalc/01/statistics_test_f.xhp new file mode 100644 index 0000000000..1fdc54d469 --- /dev/null +++ b/source/text/scalc/01/statistics_test_f.xhp @@ -0,0 +1,191 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + --> + +<meta> +<topic id="fteststat" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">F Test Statistics in Calc</title> +<filename>/text/scalc/01/statistics_test_f.xhp</filename> +</topic> +</meta> +<body> + +<bookmark xml-lang="en-US" branch="index" id="bm_id05002"> +<bookmark_value>Analysis toolpack;F-test</bookmark_value> +<bookmark_value>F-test;Analysis toolpack</bookmark_value> +<bookmark_value>Data statistics;F-test</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05003" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/@@nowidget@@" id="@@nowidget@@" localize="false"/> +<section id="ftest"> +<h1 id="hd_id1000180"><variable id="ftesth1"><link href="text/scalc/01/statistics_test_f.xhp" name="F-test">F-test</link></variable></h1> +<paragraph id="par_id1003240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the F-Test of two data samples.</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1003250" role="paragraph" xml-lang="en-US"><variable id="sam02">Choose <menuitem>Data - Statistics - F-test</menuitem></variable></paragraph> +</section> +<paragraph id="par_id1003260" role="paragraph" xml-lang="en-US">A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis.</paragraph> +<note id="par_id1003270">For more information on F-tests, refer to the <link href="https://en.wikipedia.org/wiki/F-test" name="English Wikipedia: F-test">corresponding Wikipedia article</link>.</note> +<h2 id="hd_id1000190">Data</h2> +<paragraph id="par_id1003280" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph> +<paragraph id="par_id1003290" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph> +<paragraph id="par_id1003300" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/> +<h2 id="hd_id1000200">Results for F-Test:</h2> +<paragraph id="par_id1003310" role="paragraph" xml-lang="en-US">The following table shows the <emph>F-Test</emph> for the data series above:</paragraph> +<table id="Tabela12"> +<tablerow> +<tablecell> +<paragraph id="par_id1003320" role="tablecontent" xml-lang="en-US">Ftest</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003330" role="tablecontent" xml-lang="en-US">Alpha</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003340" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +</tablecell> +<tablecell> +<paragraph id="par_id1003350" role="tablecontent" xml-lang="en-US">Variable 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003360" role="tablecontent" xml-lang="en-US">Variable 2</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003370" role="tablecontent" xml-lang="en-US">Mean</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003380" role="tablecontent" xml-lang="en-US" localize="false">16.9230769231</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003390" role="tablecontent" xml-lang="en-US" localize="false">20.4615384615</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003400" role="tablecontent" xml-lang="en-US">Variance</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003410" role="tablecontent" xml-lang="en-US" localize="false">125.0769230769</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003420" role="tablecontent" xml-lang="en-US" localize="false">94.4358974359</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003430" role="tablecontent" xml-lang="en-US">Observations</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003440" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003450" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003460" role="tablecontent" xml-lang="en-US">df</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003470" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003480" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003490" role="tablecontent" xml-lang="en-US">F</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003500" role="tablecontent" xml-lang="en-US" localize="false">1.3244637524</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003510" role="tablecontent" xml-lang="en-US">P (F<=f) right-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003520" role="tablecontent" xml-lang="en-US" localize="false">0.3170614146</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003530" role="tablecontent" xml-lang="en-US">F Critical right-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003540" role="tablecontent" xml-lang="en-US" localize="false">2.6866371125</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003550" role="tablecontent" xml-lang="en-US">P (F<=f) left-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003560" role="tablecontent" xml-lang="en-US" localize="false">0.6829385854</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003570" role="tablecontent" xml-lang="en-US">F Critical left-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003580" role="tablecontent" xml-lang="en-US" localize="false">0.3722125312</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003590" role="tablecontent" xml-lang="en-US">P two-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003600" role="tablecontent" xml-lang="en-US" localize="false">0.6341228293</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003610" role="tablecontent" xml-lang="en-US">F Critical two-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003620" role="tablecontent" xml-lang="en-US" localize="false">0.3051313549</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003630" role="tablecontent" xml-lang="en-US" localize="false">3.277277094</paragraph> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_test_t.xhp b/source/text/scalc/01/statistics_test_t.xhp new file mode 100644 index 0000000000..6a013e6a5d --- /dev/null +++ b/source/text/scalc/01/statistics_test_t.xhp @@ -0,0 +1,211 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + --> + +<meta> +<topic id="tteststat" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">T Test Statistics in Calc</title> +<filename>/text/scalc/01/statistics_test_t.xhp</filename> +</topic> +</meta> +<body> + +<bookmark xml-lang="en-US" branch="index" id="bm_id05001"> +<bookmark_value>Analysis toolpack;t-test</bookmark_value> +<bookmark_value>Analysis toolpack;paired t-test</bookmark_value> +<bookmark_value>t-test;Analysis toolpack</bookmark_value> +<bookmark_value>paired t-test;Analysis toolpack</bookmark_value> +<bookmark_value>Data statistics;paired t-test</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05002" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/@@nowidget@@" id="bm_id05002" localize="false"/> +<section id="ttest"> + <h1 id="hd_id1000150"><variable id="ttesth1"><link href="text/scalc/01/statistics_test_t.xhp" name="Paired t-test">Paired t-test</link></variable></h1> +<paragraph id="par_id1002820" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the paired t-Test of two data samples.</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1002830" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Paired t-test</menuitem></variable></paragraph> +</section> +<paragraph id="par_id1002840" role="paragraph" xml-lang="en-US">A <emph>paired t-test</emph> is any statistical hypothesis test that follows a Student's t distribution.</paragraph> +<note id="par_id1002850">For more information on paired t-tests, refer to the <link href="https://en.wikipedia.org/wiki/T-test" name="English Wikipedia: T-test">corresponding Wikipedia article</link>.</note> +<h2 id="hd_id1000160">Data</h2> +<paragraph id="par_id1002860" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph> +<paragraph id="par_id1002870" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph> +<paragraph id="par_id1002880" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/> +<h2 id="hd_id1000170">Results for paired t-test:</h2> +<paragraph id="par_id1002890" role="paragraph" xml-lang="en-US">The following table shows the <emph>paired t-test</emph> for the data series above:</paragraph> +<table id="Tabela11"> +<tablerow> +<tablecell> +<paragraph id="par_id1002900" role="tablehead" xml-lang="en-US">paired t-test</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002910" role="tablecontent" xml-lang="en-US">Alpha</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002920" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002930" role="tablecontent" xml-lang="en-US">Hypothesized Mean Difference</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002940" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +</tablecell> +<tablecell> +<paragraph id="par_id1002950" role="tablecontent" xml-lang="en-US">Variable 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002960" role="tablecontent" xml-lang="en-US">Variable 2</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1002970" role="tablecontent" xml-lang="en-US">Mean</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002980" role="tablecontent" xml-lang="en-US" localize="false">16.9230769231</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1002990" role="tablecontent" xml-lang="en-US" localize="false">20.4615384615</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003000" role="tablecontent" xml-lang="en-US">Variance</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003010" role="tablecontent" xml-lang="en-US" localize="false">125.0769230769</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003020" role="tablecontent" xml-lang="en-US" localize="false">94.4358974359</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003030" role="tablecontent" xml-lang="en-US">Observations</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003040" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003050" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003060" role="tablecontent" xml-lang="en-US">Pearson Correlation</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003070" role="tablecontent" xml-lang="en-US" localize="false">-0.0617539772</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003080" role="tablecontent" xml-lang="en-US">Observed Mean Difference</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003090" role="tablecontent" xml-lang="en-US" localize="false">-3.5384615385</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003100" role="tablecontent" xml-lang="en-US">Variance of the Differences</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003110" role="tablecontent" xml-lang="en-US" localize="false">232.9358974359</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003120" role="tablecontent" xml-lang="en-US">df </paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003130" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003140" role="tablecontent" xml-lang="en-US">t Stat</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003150" role="tablecontent" xml-lang="en-US" localize="false">-0.8359262137</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003160" role="tablecontent" xml-lang="en-US">P (T<=t) one-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003170" role="tablecontent" xml-lang="en-US" localize="false">0.2097651442</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003180" role="tablecontent" xml-lang="en-US">t Critical one-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003190" role="tablecontent" xml-lang="en-US" localize="false">1.7822875556</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003200" role="tablecontent" xml-lang="en-US">P (T<=t) two-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003210" role="tablecontent" xml-lang="en-US" localize="false">0.4195302884</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003220" role="tablecontent" xml-lang="en-US">t Critical two-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003230" role="tablecontent" xml-lang="en-US" localize="false">2.1788128297</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/statistics_test_z.xhp b/source/text/scalc/01/statistics_test_z.xhp new file mode 100644 index 0000000000..b54ba44fd5 --- /dev/null +++ b/source/text/scalc/01/statistics_test_z.xhp @@ -0,0 +1,188 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * 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 . + --> + +<meta> +<topic id="zteststat" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Z Test Statistics in Calc</title> +<filename>/text/scalc/01/statistics_test_z.xhp</filename> +</topic> +</meta> +<body> + +<bookmark xml-lang="en-US" branch="index" id="bm_id05003"> +<bookmark_value>Analysis toolpack;Z-test</bookmark_value> +<bookmark_value>Z-test;Analysis toolpack</bookmark_value> +<bookmark_value>Data statistics;Z-test</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ztestdialog/ZTestDialog" id="bm_id05004" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ztestdialog/@@nowidget@@" id="bm_id05004" localize="false"/> +<section id="ztest"> + <h1 id="hd_id1000210"><variable id="ztesth1"><link href="text/scalc/01/statistics_test_z.xhp" name="Z-test">Z-test</link></variable></h1> +<paragraph id="par_id1003640" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ztestdialog/ZTestDialog">Calculates the z-Test of two data samples.</ahelp></paragraph> +</section> +<section id="howtoget"> +<paragraph id="par_id1003650" role="paragraph" xml-lang="en-US"><variable id="sam02">Choose <menuitem>Data - Statistics - Z-test</menuitem></variable></paragraph> +</section> +<note id="par_id1003660">For more information on Z-tests, refer to the <link href="https://en.wikipedia.org/wiki/Z-test" name="English Wikipedia: Z-test">corresponding Wikipedia article</link>.</note> +<h2 id="hd_id1000220">Data</h2> +<paragraph id="par_id1003670" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph> +<paragraph id="par_id1003680" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph> +<paragraph id="par_id1003690" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/> +<h2 id="hd_id1000230">Results for z-Test:</h2> +<paragraph id="par_id1003700" role="paragraph" xml-lang="en-US">The following table shows the <emph>z-Test</emph> for the data series above:</paragraph> +<table id="Tabela13"> +<tablerow> +<tablecell> +<paragraph id="par_id1003710" role="tablecontent" xml-lang="en-US">z-test</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003720" role="tablecontent" xml-lang="en-US">Alpha</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003730" role="tablecontent" xml-lang="en-US" localize="false">0.05</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003740" role="tablecontent" xml-lang="en-US">Hypothesized Mean Difference</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003750" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +</tablecell> +<tablecell> +<paragraph id="par_id1003760" role="tablecontent" xml-lang="en-US">Variable 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003770" role="tablecontent" xml-lang="en-US">Variable 2</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003780" role="tablecontent" xml-lang="en-US">Known Variance</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003790" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003800" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003810" role="tablecontent" xml-lang="en-US">Mean</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003820" role="tablecontent" xml-lang="en-US" localize="false">16.9230769231</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003830" role="tablecontent" xml-lang="en-US" localize="false">20.4615384615</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003840" role="tablecontent" xml-lang="en-US">Observations</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003850" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003860" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003870" role="tablecontent" xml-lang="en-US">Observed Mean Difference</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003880" role="tablecontent" xml-lang="en-US" localize="false">-3.5384615385</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003890" role="tablecontent" xml-lang="en-US">z</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003900" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003910" role="tablecontent" xml-lang="en-US">P (Z<=z) one-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003920" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003930" role="tablecontent" xml-lang="en-US">z Critical one-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003940" role="tablecontent" xml-lang="en-US" localize="false">1.644853627</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003950" role="tablecontent" xml-lang="en-US">P (Z<=z) two-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003960" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1003970" role="tablecontent" xml-lang="en-US">z Critical two-tail</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1003980" role="tablecontent" xml-lang="en-US" localize="false">1.9599639845</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/main0112.xhp b/source/text/scalc/main0112.xhp index 77725a3257..c46aab32cf 100644 --- a/source/text/scalc/main0112.xhp +++ b/source/text/scalc/main0112.xhp @@ -48,6 +48,7 @@ <embed href="text/scalc/01/text2columns.xhp#t2cheader"/> <embed href="text/scalc/01/12070000.xhp#consolidateheader"/> <embed href="text/scalc/01/12080000.xhp#gliederung"/> +<embed href="text/scalc/01/statistics.xhp#analysistoolpack"/> </body> </helpdocument> |