diff options
| author | Olivier Hallot <ohallot@collabora.co.uk> | 2016-01-21 18:49:23 -0200 |
|---|---|---|
| committer | Olivier Hallot <ohallot@collabora.co.uk> | 2016-02-09 20:36:13 +0000 |
| commit | df2eefa2ce5e5db43df453ba1c2fb52abb88e08e (patch) | |
| tree | 31caaf8ad9a533827a8998e3d83fb4b7bf26a7b2 | |
| parent | 4b1bb982611b888fa7c4b11c614ea32c54f980a2 (diff) | |
tdf#96868 Help page for data statistics regression
Change-Id: I7c0e236c1d19572b682d5b6c120ce604f6e39de8
Reviewed-on: https://gerrit.libreoffice.org/22144
Reviewed-by: Olivier Hallot <ohallot@collabora.co.uk>
Tested-by: Olivier Hallot <ohallot@collabora.co.uk>
| -rw-r--r-- | AllLangHelp_scalc.mk | 1 | ||||
| -rw-r--r-- | source/text/scalc/01/stat_data.xhp | 1184 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics.xhp | 3 | ||||
| -rw-r--r-- | source/text/scalc/01/statistics_regression.xhp | 327 |
4 files changed, 997 insertions, 518 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index efce3956fe..02b56886ba 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -229,6 +229,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/solver \ helpcontent2/source/text/scalc/01/solver_options \ helpcontent2/source/text/scalc/01/statistics \ + helpcontent2/source/text/scalc/01/statistics_regression \ helpcontent2/source/text/scalc/01/stat_data \ helpcontent2/source/text/scalc/01/ODFF \ helpcontent2/source/text/scalc/01/text2columns \ diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp index 31e5611306..f11b62c861 100644 --- a/source/text/scalc/01/stat_data.xhp +++ b/source/text/scalc/01/stat_data.xhp @@ -1,4 +1,4 @@ -<?xml version="1.0"?> +<?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> <!-- * This file is part of the LibreOffice project. @@ -6,549 +6,697 @@ * 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="ID" indexer="include"> -<title xml-lang="en-US" id="tit">Data</title> -<filename>/text/scalc/01/stat_data.xhp</filename> -</topic> + <topic id="ID" indexer="Indexer"> + <title id="tit" xml-lang="en-US">Data</title> + <filename>/text/scalc/01/stat_data.xhp</filename> + </topic> </meta> + <body> + + <section id="data"> -<paragraph id="hd_id1000010" role="heading" xml-lang="en-US" level="3">Data</paragraph> + +<paragraph id="hd_id1000010" role="heading" level="3" xml-lang="en-US">Data</paragraph> <paragraph id="par_id1000010" role="paragraph" xml-lang="en-US"><emph>Input Range</emph>: The reference of the range of the data to analyze.</paragraph> <paragraph id="par_id1000020" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the results will be displayed.</paragraph> </section> + <section id="grouped"> -<paragraph id="hd_id1000020" role="heading" xml-lang="en-US" level="3">Grouped By</paragraph> + +<paragraph id="hd_id1000020" role="heading" level="3" xml-lang="en-US">Grouped By</paragraph> <paragraph id="par_id1000030" role="paragraph" xml-lang="en-US">Select whether the input data has <emph>columns</emph> or <emph>rows</emph> layout.</paragraph> </section> + <section id="sampledata01"> -<paragraph id="hd_id1000030" role="heading" xml-lang="en-US" level="3">Example</paragraph> + +<paragraph id="hd_id1000030" role="heading" level="3" xml-lang="en-US">Example</paragraph> <paragraph id="par_id1000040" role="paragraph" xml-lang="en-US">The following data will be used as example </paragraph> + <table id="Tabela3"> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -<paragraph id="par_id1000050" role="tablehead" xml-lang="en-US" localize="false">A</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000060" role="tablehead" xml-lang="en-US" localize="false">B</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000070" role="tablehead" xml-lang="en-US" localize="false">C</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000080" role="tablehead" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000090" role="tablehead" xml-lang="en-US">Maths</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000100" role="tablehead" xml-lang="en-US">Physics</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000110" role="tablehead" xml-lang="en-US">Biology</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000120" role="tablehead" xml-lang="en-US" localize="false">2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000130" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000140" role="tablecontent" xml-lang="en-US" localize="false">67</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000150" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000160" role="tablehead" xml-lang="en-US" localize="false">3</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000170" role="tablecontent" xml-lang="en-US" localize="false">36</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000180" role="tablecontent" xml-lang="en-US" localize="false">68</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000190" role="tablecontent" xml-lang="en-US" localize="false">42</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000200" role="tablehead" xml-lang="en-US" localize="false">4</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000210" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000220" role="tablecontent" xml-lang="en-US" localize="false">65</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000230" role="tablecontent" xml-lang="en-US" localize="false">44</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000240" role="tablehead" xml-lang="en-US" localize="false">5</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000250" role="tablecontent" xml-lang="en-US" localize="false">39</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000260" role="tablecontent" xml-lang="en-US" localize="false">64</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000270" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000280" role="tablehead" xml-lang="en-US" localize="false">6</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -<paragraph id="par_id1000290" role="tablecontent" xml-lang="en-US" localize="false">38</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000300" role="tablecontent" xml-lang="en-US" localize="false">43</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000310" role="tablehead" xml-lang="en-US" localize="false">7</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000320" role="tablecontent" xml-lang="en-US" localize="false">47</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000330" role="tablecontent" xml-lang="en-US" localize="false">84</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000340" role="tablecontent" xml-lang="en-US" localize="false">62</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000350" role="tablehead" xml-lang="en-US" localize="false">8</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000360" role="tablecontent" xml-lang="en-US" localize="false">29</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000370" role="tablecontent" xml-lang="en-US" localize="false">80</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000380" role="tablecontent" xml-lang="en-US" localize="false">51</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000390" role="tablehead" xml-lang="en-US" localize="false">9</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000400" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000410" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000420" role="tablecontent" xml-lang="en-US" localize="false">40</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000430" role="tablehead" xml-lang="en-US" localize="false">10</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000440" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000450" role="tablecontent" xml-lang="en-US" localize="false">49</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000460" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000470" role="tablehead" xml-lang="en-US" localize="false">11</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000480" role="tablecontent" xml-lang="en-US" localize="false">56</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000490" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000500" role="tablecontent" xml-lang="en-US" localize="false">60</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000510" role="tablehead" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000520" role="tablecontent" xml-lang="en-US" localize="false">57</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000530" role="tablehead" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000540" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph> -</tablecell> -<tablecell> -</tablecell> -<tablecell> -</tablecell> -</tablerow> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1000050" localize="false" role="tablehead" xml-lang="en-US">A</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000060" role="tablehead" xml-lang="en-US" localize="false">B</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000070" role="tablehead" xml-lang="en-US" localize="false">C</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000080" role="tablehead" localize="false" xml-lang="en-US">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000090" role="tablehead" xml-lang="en-US">Maths</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000100" role="tablehead" xml-lang="en-US">Physics</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000110" role="tablehead" xml-lang="en-US">Biology</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000120" role="tablehead" localize="false" xml-lang="en-US">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000130" role="tablecontent" localize="false" xml-lang="en-US">47</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000140" role="tablecontent" localize="false" xml-lang="en-US">67</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000150" role="tablecontent" localize="false" xml-lang="en-US">33</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000160" role="tablehead" localize="false" xml-lang="en-US">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000170" role="tablecontent" localize="false" xml-lang="en-US">36</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000180" role="tablecontent" localize="false" xml-lang="en-US">68</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000190" role="tablecontent" localize="false" xml-lang="en-US">42</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000200" role="tablehead" localize="false" xml-lang="en-US">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000210" role="tablecontent" localize="false" xml-lang="en-US">40</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000220" role="tablecontent" localize="false" xml-lang="en-US">65</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000230" role="tablecontent" localize="false" xml-lang="en-US">44</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000240" role="tablehead" localize="false" xml-lang="en-US">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000250" role="tablecontent" localize="false" xml-lang="en-US">39</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000260" role="tablecontent" localize="false" xml-lang="en-US">64</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000270" role="tablecontent" localize="false" xml-lang="en-US">60</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000280" role="tablehead" localize="false" xml-lang="en-US">6</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1000290" role="tablecontent" localize="false" xml-lang="en-US">38</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000300" role="tablecontent" localize="false" xml-lang="en-US">43</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000310" role="tablehead" localize="false" xml-lang="en-US">7</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000320" role="tablecontent" localize="false" xml-lang="en-US">47</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000330" role="tablecontent" localize="false" xml-lang="en-US">84</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000340" role="tablecontent" localize="false" xml-lang="en-US">62</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000350" role="tablehead" localize="false" xml-lang="en-US">8</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000360" role="tablecontent" localize="false" xml-lang="en-US">29</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000370" role="tablecontent" localize="false" xml-lang="en-US">80</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000380" role="tablecontent" localize="false" xml-lang="en-US">51</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000390" role="tablehead" localize="false" xml-lang="en-US">9</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000400" role="tablecontent" localize="false" xml-lang="en-US">27</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000410" role="tablecontent" localize="false" xml-lang="en-US">49</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000420" role="tablecontent" localize="false" xml-lang="en-US">40</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000430" role="tablehead" localize="false" xml-lang="en-US">10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000440" role="tablecontent" localize="false" xml-lang="en-US">57</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000450" role="tablecontent" localize="false" xml-lang="en-US">49</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000460" role="tablecontent" localize="false" xml-lang="en-US">12</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000470" role="tablehead" localize="false" xml-lang="en-US">11</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000480" role="tablecontent" localize="false" xml-lang="en-US">56</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000490" role="tablecontent" localize="false" xml-lang="en-US">33</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000500" role="tablecontent" localize="false" xml-lang="en-US">60</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000510" role="tablehead" localize="false" xml-lang="en-US">12</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000520" role="tablecontent" localize="false" xml-lang="en-US">57</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000530" role="tablehead" localize="false" xml-lang="en-US">13</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000540" role="tablecontent" localize="false" xml-lang="en-US">26</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> </table> + </section> + <section id="timeseries01"> -<paragraph id="hd_id1000040" role="heading" xml-lang="en-US" level="3">Example</paragraph> + +<paragraph id="hd_id1000040" role="heading" level="3" xml-lang="en-US">Example</paragraph> <paragraph id="par_id1000550" role="paragraph" xml-lang="en-US">The following table has two time series, one representing an impulse function at time t=0 and the other an impulse function at time t=2.</paragraph> + <table id="Tabela8"> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -<paragraph id="par_id1000560" role="tablehead" xml-lang="en-US" localize="false">A</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000570" role="tablehead" xml-lang="en-US" localize="false">B</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000580" role="tablehead" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000590" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000600" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000610" role="tablehead" xml-lang="en-US" localize="false">2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000620" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000630" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000640" role="tablehead" xml-lang="en-US" localize="false">3</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000650" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000660" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000670" role="tablehead" xml-lang="en-US" localize="false">4</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000680" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000690" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000700" role="tablehead" xml-lang="en-US" localize="false">5</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000710" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000720" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000730" role="tablehead" xml-lang="en-US" localize="false">6</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000740" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000750" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000760" role="tablehead" xml-lang="en-US" localize="false">7</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000770" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000780" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000790" role="tablehead" xml-lang="en-US" localize="false">8</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000800" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000810" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000820" role="tablehead" xml-lang="en-US" localize="false">9</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000830" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000840" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000850" role="tablehead" xml-lang="en-US" localize="false">10</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000860" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000870" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000880" role="tablehead" xml-lang="en-US" localize="false">11</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000890" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000900" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000910" role="tablehead" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000920" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000930" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1000940" role="tablehead" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000950" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000960" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -</tablerow> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1000560" role="tablehead" localize="false" xml-lang="en-US">A</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000570" role="tablehead" localize="false" xml-lang="en-US">B</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000580" role="tablehead" localize="false" xml-lang="en-US">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000590" role="tablecontent" localize="false" xml-lang="en-US">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000600" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000610" role="tablehead" localize="false" xml-lang="en-US">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000620" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000630" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000640" role="tablehead" localize="false" xml-lang="en-US">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000650" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000660" role="tablecontent" localize="false" xml-lang="en-US">1</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000670" role="tablehead" localize="false" xml-lang="en-US">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000680" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000690" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000700" role="tablehead" localize="false" xml-lang="en-US">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000710" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000720" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000730" role="tablehead" localize="false" xml-lang="en-US">6</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000740" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000750" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000760" role="tablehead" localize="false" xml-lang="en-US">7</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000770" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000780" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000790" role="tablehead" localize="false" xml-lang="en-US">8</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000800" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000810" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000820" role="tablehead" localize="false" xml-lang="en-US">9</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000830" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000840" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000850" role="tablehead" localize="false" xml-lang="en-US">10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000860" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000870" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000880" role="tablehead" localize="false" xml-lang="en-US">11</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000890" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000900" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000910" role="tablehead" localize="false" xml-lang="en-US">12</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000920" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000930" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1000940" role="tablehead" localize="false" xml-lang="en-US">13</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000950" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000960" role="tablecontent" localize="false" xml-lang="en-US">0</paragraph> + </tablecell> + </tablerow> </table> </section> + <section id="datafortests"> -<paragraph id="hd_id1000050" role="heading" xml-lang="en-US" level="3">Example</paragraph> + +<paragraph id="hd_id1000050" role="heading" level="3" xml-lang="en-US">Example</paragraph> <paragraph id="par_id1000970" role="paragraph" xml-lang="en-US">The following table has two data sets.</paragraph> + <table id="Tabela9"> -<tablerow> -<tablecell> -</tablecell> -<tablecell> -<paragraph id="par_id1000980" role="tablehead" xml-lang="en-US" localize="false">A</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1000990" role="tablehead" xml-lang="en-US" localize="false">B</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001000" role="tablehead" xml-lang="en-US" localize="false">1</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001010" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001020" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001030" role="tablehead" xml-lang="en-US" localize="false">2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001040" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001050" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001060" role="tablehead" xml-lang="en-US" localize="false">3</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001070" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001080" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001090" role="tablehead" xml-lang="en-US" localize="false">4</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001100" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001110" role="tablecontent" xml-lang="en-US" localize="false">5</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001120" role="tablehead" xml-lang="en-US" localize="false">5</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001130" role="tablecontent" xml-lang="en-US" localize="false">20</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001140" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001150" role="tablehead" xml-lang="en-US" localize="false">6</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001160" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001170" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001180" role="tablehead" xml-lang="en-US" localize="false">7</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001190" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001200" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001210" role="tablehead" xml-lang="en-US" localize="false">8</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001220" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001230" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001240" role="tablehead" xml-lang="en-US" localize="false">9</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001250" role="tablecontent" xml-lang="en-US" localize="false">4</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001260" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001270" role="tablehead" xml-lang="en-US" localize="false">10</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001280" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001290" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001300" role="tablehead" xml-lang="en-US" localize="false">11</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001310" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001320" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001330" role="tablehead" xml-lang="en-US" localize="false">12</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001340" role="tablecontent" xml-lang="en-US" localize="false">8</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001350" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph id="par_id1001360" role="tablehead" xml-lang="en-US" localize="false">13</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001370" role="tablecontent" xml-lang="en-US" localize="false">9</paragraph> -</tablecell> -<tablecell> -<paragraph id="par_id1001380" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph> -</tablecell> -</tablerow> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1000980" role="tablehead" xml-lang="en-US" localize="false">A</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1000990" role="tablehead" xml-lang="en-US" localize="false">B</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001000" role="tablehead" xml-lang="en-US" localize="false">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001010" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001020" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001030" role="tablehead" xml-lang="en-US" localize="false">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001040" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001050" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001060" role="tablehead" xml-lang="en-US" localize="false">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001070" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001080" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001090" role="tablehead" xml-lang="en-US" localize="false">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001100" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001110" role="tablecontent" xml-lang="en-US" localize="false">5</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001120" role="tablehead" xml-lang="en-US" localize="false">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001130" role="tablecontent" xml-lang="en-US" localize="false">20</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001140" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001150" role="tablehead" xml-lang="en-US" localize="false">6</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001160" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001170" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001180" role="tablehead" xml-lang="en-US" localize="false">7</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001190" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001200" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001210" role="tablehead" xml-lang="en-US" localize="false">8</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001220" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001230" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001240" role="tablehead" xml-lang="en-US" localize="false">9</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001250" role="tablecontent" xml-lang="en-US" localize="false">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001260" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001270" role="tablehead" xml-lang="en-US" localize="false">10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001280" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001290" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001300" role="tablehead" xml-lang="en-US" localize="false">11</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001310" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001320" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001330" role="tablehead" xml-lang="en-US" localize="false">12</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001340" role="tablecontent" xml-lang="en-US" localize="false">8</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001350" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1001360" role="tablehead" xml-lang="en-US" localize="false">13</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001370" role="tablecontent" xml-lang="en-US" localize="false">9</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1001380" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph> + </tablecell> + </tablerow> +</table> + +</section> + +<section id="regressiondata"> + +<paragraph id="hd_id1701201619425619" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<paragraph id="par_id1701201619425624" role="paragraph" xml-lang="en-US">The following table has samples of a physical phenomenon taken in 1 second interval.</paragraph> + +<table id="Table1"> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id170120161940524" role="tablehead" xml-lang="en-US" localize="false">A</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1701201619405255" role="tablehead" xml-lang="en-US" localize="false">B</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405244" role="tablehead" xml-lang="en-US" localize="false">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441023" role="paragraph" xml-lang="en-US" localize="false">Time</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441056" role="paragraph" xml-lang="en-US" localize="false">Measurement</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405214" role="tablehead" xml-lang="en-US" localize="false">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441082" role="paragraph" xml-lang="en-US" localize="false">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161501214" role="paragraph" xml-lang="en-US" localize="false">2.7</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405278" role="tablehead" xml-lang="en-US" localize="false">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441385" role="paragraph" xml-lang="en-US" localize="false">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615012191" role="paragraph" xml-lang="en-US" localize="false">4.0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405257" role="tablehead" xml-lang="en-US" localize="false">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441322" role="paragraph" xml-lang="en-US" localize="false">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615012192" role="paragraph" xml-lang="en-US" localize="false">4.4</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405289" role="tablehead" xml-lang="en-US" localize="false">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441312" role="paragraph" xml-lang="en-US" localize="false">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615012187" role="paragraph" xml-lang="en-US" localize="false">7.1</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405317" role="tablehead" xml-lang="en-US" localize="false">6</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441399" role="paragraph" xml-lang="en-US" localize="false">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615012121" role="paragraph" xml-lang="en-US" localize="false">4.9</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405368" role="tablehead" xml-lang="en-US" localize="false">7</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441393" role="paragraph" xml-lang="en-US" localize="false">6</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615012143" role="paragraph" xml-lang="en-US" localize="false">3.6</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405345" role="tablehead" xml-lang="en-US" localize="false">8</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161444136" role="paragraph" xml-lang="en-US" localize="false">7</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615012166" role="paragraph" xml-lang="en-US" localize="false">4.0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405311" role="tablehead" xml-lang="en-US" localize="false">9</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441334" role="paragraph" xml-lang="en-US" localize="false">8</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615012149" role="paragraph" xml-lang="en-US" localize="false">0.6</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405353" role="tablehead" xml-lang="en-US" localize="false">10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441380" role="paragraph" xml-lang="en-US" localize="false">9</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615012153" role="paragraph" xml-lang="en-US" localize="false">1.0</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201619405381" role="tablehead" xml-lang="en-US" localize="false">11</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201614441330" role="paragraph" xml-lang="en-US" localize="false">10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615012135" role="paragraph" xml-lang="en-US" localize="false">4.3</paragraph> + </tablecell> + </tablerow> </table> </section> </body> -</helpdocument> + +</helpdocument>
\ No newline at end of file diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp index 5cdd15940c..bdea8206cc 100644 --- a/source/text/scalc/01/statistics.xhp +++ b/source/text/scalc/01/statistics.xhp @@ -1699,5 +1699,8 @@ </tablerow> </table> </section> +<section id="relatedtopics"> +<link href="text/scalc/01/statistics_regression.xhp#regressionanalysis">Regression Analysis</link> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/statistics_regression.xhp b/source/text/scalc/01/statistics_regression.xhp new file mode 100644 index 0000000000..b6bf44b6ab --- /dev/null +++ b/source/text/scalc/01/statistics_regression.xhp @@ -0,0 +1,327 @@ +<?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="ID" indexer="Indexer" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Regression Analysis</title> + <filename>/text/scalc/01/statistics_regression.xhp</filename> + </topic> +</meta> + +<body> + + +<paragraph id="hd_id1701201615033510" role="heading" level="2" xml-lang="en-US">Regression Analysis</paragraph> +<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 id="regressionanalysis"> +<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> + <bookmark_value>Data statistics;regression analysis</bookmark_value> +</bookmark> + +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/regressiondialog/RegressionDialog" id="bm_id2745673" localize="false"/> + +<section id="howtoget"> +<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Regression...</emph></variable></paragraph> +</section> +<paragraph id="par_id1001270" role="note" xml-lang="en-US">For more information, please visit the Wikipedia: <link href="http://en.wikipedia.org/wiki/Regression_analysis">http://en.wikipedia.org/wiki/Regression_analysis</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> +<paragraph id="par_id1001280" role="paragraph" xml-lang="en-US">Set the regression type. Three types are available: </paragraph> + +<list type="unordered"> + <listitem> + <paragraph id="par_id1701201620334364" role="ul_item" xml-lang="en-US"><emph>Linear Regression</emph>: find a strait line in the form of <item type="literal">y = a.x + b</item>, where <item type="literal">a</item> is the slope and <item type="literal">b</item> is the intercept that best fits the data.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id1701201620340168" role="ul_item" xml-lang="en-US"><emph>Logarithmic regression</emph>: find a logarithmic curve in the form of <item type="literal">y = a.ln(x) + b</item>, where <item type="literal">a</item> is the slope, <item type="literal">b</item> is the intercept and <item type="literal">ln(x)</item> is the natural logarithm of <item type="literal">x</item>, that best fits the data.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id1701201620340139" role="ul_item" xml-lang="en-US"><emph>Power regression</emph>: Find a power curve in the form of <item type="literal">y = a.x^b</item>, where <item type="literal">a</item> is the slope, <item type="literal">b</item> is the intercept that best fits the data.</paragraph> + </listitem></list> +<embed href="text/scalc/01/stat_data.xhp#regressiondata"/> +<paragraph id="par_id1001310" role="paragraph" xml-lang="en-US">The results of the three types of <emph>regression analysis</emph> of the measurements in the table above are shown below.</paragraph> + +<table id="Tabela1"> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090526" role="tablehead" xml-lang="en-US">Regression</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090542" role="paragraph" xml-lang="en-US">Regression Model</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1701201618090596" role="paragraph" xml-lang="en-US">Linear</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1701201618090586" role="paragraph" xml-lang="en-US">Logarithmic</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1701201618090555" role="paragraph" xml-lang="en-US">Power</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090553" role="paragraph" xml-lang="en-US">R^2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114385" role="paragraph" localize="false" xml-lang="en-US">0.1243901235</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114339" role="paragraph" localize="false" xml-lang="en-US">0.036283506</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114321" role="paragraph" localize="false" xml-lang="en-US">0.0884254697</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090595" role="paragraph" xml-lang="en-US">Standard Error</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114322" role="paragraph" localize="false" xml-lang="en-US">1.8692568609</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114330" role="paragraph" localize="false" xml-lang="en-US">1.9610483597</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114373" role="paragraph" localize="false" xml-lang="en-US">0.7746321053</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090563" role="paragraph" xml-lang="en-US">Slope</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id19012061511466" role="paragraph" localize="false" xml-lang="en-US">-0.2193939394</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114648" role="paragraph" localize="false" xml-lang="en-US">-0.4894112008</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114619" role="paragraph" localize="false" xml-lang="en-US">4.812672931</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090642" role="paragraph" xml-lang="en-US">Intercept</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114679" role="paragraph" localize="false" xml-lang="en-US">4.8666666667</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120165114664" role="paragraph" localize="false" xml-lang="en-US">4.3992268695</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190101615114697" role="paragraph" localize="false" xml-lang="en-US">-0.3103085297</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id190120161511461" role="paragraph" localize="false" xml-lang="en-US">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114631" role="paragraph" localize="false" xml-lang="en-US">4.6472727273</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114663" role="paragraph" localize="false" xml-lang="en-US">4.3992268695</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id19012016151142" role="paragraph" localize="false" xml-lang="en-US">4.812672931</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114687" role="paragraph" localize="false" xml-lang="en-US">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114677" role="paragraph" localize="false" xml-lang="en-US">4.4278787879</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114693" role="paragraph" localize="false" xml-lang="en-US">4.0599928755</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114630" role="paragraph" localize="false" xml-lang="en-US">3.8812728356</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114697" role="paragraph" localize="false" xml-lang="en-US">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114659" role="paragraph" localize="false" xml-lang="en-US">4.2084848485</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114671" role="paragraph" localize="false" xml-lang="en-US">3.8615537101</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114664" role="paragraph" localize="false" xml-lang="en-US">3.4224061924</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id190120161511463" role="paragraph" localize="false" xml-lang="en-US">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161511462" role="paragraph" localize="false" xml-lang="en-US">3.9890909091</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161511466" role="paragraph" localize="false" xml-lang="en-US">3.7207588815</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114649" role="paragraph" localize="false" xml-lang="en-US">3.1301272785</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114699" role="paragraph" localize="false" xml-lang="en-US">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114635" role="paragraph" localize="false" xml-lang="en-US">3.7696969697</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114716" role="paragraph" localize="false" xml-lang="en-US">3.6115499281</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114792" role="paragraph" localize="false" xml-lang="en-US">2.9207204651</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114711" role="paragraph" localize="false" xml-lang="en-US">6</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114718" role="paragraph" localize="false" xml-lang="en-US">3.5503030303</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114732" role="paragraph" localize="false" xml-lang="en-US">3.5223197161</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114775" role="paragraph" localize="false" xml-lang="en-US">2.7600654308</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114712" role="paragraph" localize="false" xml-lang="en-US">7</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161511476" role="paragraph" localize="false" xml-lang="en-US">3.3309090909</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114710" role="paragraph" localize="false" xml-lang="en-US">3.4468766468</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615117" role="paragraph" localize="false" xml-lang="en-US">2.6311476385</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114767" role="paragraph" localize="false" xml-lang="en-US">8</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114753" role="paragraph" localize="false" xml-lang="en-US">3.1115151515</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id19012016151147" role="paragraph" localize="false" xml-lang="en-US">3.3815248876</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114720" role="paragraph" localize="false" xml-lang="en-US">2.5243514679</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114746" role="paragraph" localize="false" xml-lang="en-US">9</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114725" role="paragraph" localize="false" xml-lang="en-US">2.8921212121</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114758" role="paragraph" localize="false" xml-lang="en-US">3.3238805506</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114773" role="paragraph" localize="false" xml-lang="en-US">2.4337544465</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114789" role="paragraph" localize="false" xml-lang="en-US">10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161114720" role="paragraph" localize="false" xml-lang="en-US">2.6727272727</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114738" role="paragraph" localize="false" xml-lang="en-US">3.2723159341</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114798" role="paragraph" localize="false" xml-lang="en-US">2.3554713075</paragraph> + </tablecell> + </tablerow> +</table> + + +<section id="relatedtopics"> +<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">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> +</body> + +</helpdocument>
\ No newline at end of file |