summaryrefslogtreecommitdiff
path: root/source/text/scalc/01
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2019-06-29 14:41:39 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2019-07-02 13:56:08 +0200
commitc7e097196ca1e9e3423ed92eaa9ce75bf78b7cc9 (patch)
tree1041b111de11f76b37363e0787c29454b7d5f113 /source/text/scalc/01
parent4b523164742b4eaffb576c0b1f507cf42f236ad5 (diff)
Add Help for FOURIER calc function and analysis
Refactor sample tables, Mute l10n for numbers FOURIER function Fourier analysis Sample file Change-Id: If5361fe009ec380e9cdd6f3e24184471c1451421 Reviewed-on: https://gerrit.libreoffice.org/74914 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01')
-rw-r--r--source/text/scalc/01/04060107.xhp260
-rw-r--r--source/text/scalc/01/func_fourier.xhp48
-rw-r--r--source/text/scalc/01/stat_data.xhp1975
-rw-r--r--source/text/scalc/01/statistics.xhp8
-rw-r--r--source/text/scalc/01/statistics_fourier.xhp656
-rw-r--r--source/text/scalc/01/statistics_regression.xhp14
6 files changed, 2140 insertions, 821 deletions
diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp
index aa73753312..93da1256fc 100644
--- a/source/text/scalc/01/04060107.xhp
+++ b/source/text/scalc/01/04060107.xhp
@@ -42,7 +42,7 @@
<bookmark_value>forced array handling</bookmark_value>
</bookmark>
<comment>mw deleted "creating;"</comment>
-<paragraph id="hd_id3147273" role="heading" level="1" xml-lang="en-US">Array Functions</paragraph>
+<paragraph id="hd_id3147273" role="heading" level="1" xml-lang="en-US"><variable id="arrayfunctit"><link href="text/scalc/01/04060107.xhp" name="array functions">Array Functions</link></variable></paragraph>
<paragraph id="par_id3154744" role="paragraph" xml-lang="en-US"><variable id="matrixtext">This category contains the array functions.</variable></paragraph>
<paragraph id="hd_id3146084" role="heading" level="2" xml-lang="en-US">What is an Array?</paragraph>
<paragraph id="par_id3154298" role="paragraph" xml-lang="en-US"><variable id="wasmatrix">An array is a linked range of cells on a spreadsheet containing values.</variable> A square range of 3 rows and 3 columns is a 3 x 3 array:</paragraph>
@@ -51,55 +51,55 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id3154692" role="paragraph" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_id3154692" role="tablehead" localize="false">A</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150117" role="paragraph" xml-lang="en-US">B</paragraph>
+ <paragraph id="par_id3150117" role="tablehead" localize="false">B</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155325" role="paragraph" xml-lang="en-US">C</paragraph>
+ <paragraph id="par_id3155325" role="tablehead" localize="false">C</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3153104" role="paragraph" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_id3153104" role="tablehead" localize="false">1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3146996" role="paragraph" xml-lang="en-US"><item type="input">7</item></paragraph>
+ <paragraph id="par_id3146996" role="paragraph" localize="false"><item type="input">7</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150529" role="paragraph" xml-lang="en-US"><item type="input">31</item></paragraph>
+ <paragraph id="par_id3150529" role="paragraph" localize="false"><item type="input">31</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3148831" role="paragraph" xml-lang="en-US"><item type="input">33</item></paragraph>
+ <paragraph id="par_id3148831" role="paragraph" localize="false"><item type="input">33</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3148943" role="paragraph" xml-lang="en-US">2</paragraph>
+ <paragraph id="par_id3148943" role="tablehead" localize="false">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149771" role="paragraph" xml-lang="en-US"><item type="input">95</item></paragraph>
+ <paragraph id="par_id3149771" role="paragraph" localize="false"><item type="input">95</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3158407" role="paragraph" xml-lang="en-US"><item type="input">17</item></paragraph>
+ <paragraph id="par_id3158407" role="paragraph" localize="false"><item type="input">17</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3148806" role="paragraph" xml-lang="en-US"><item type="input">2</item></paragraph>
+ <paragraph id="par_id3148806" role="paragraph" localize="false"><item type="input">2</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154904" role="paragraph" xml-lang="en-US">3</paragraph>
+ <paragraph id="par_id3154904" role="tablehead" localize="false">3</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150779" role="paragraph" xml-lang="en-US"><item type="input">5</item></paragraph>
+ <paragraph id="par_id3150779" role="paragraph" localize="false"><item type="input">5</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3148449" role="paragraph" xml-lang="en-US"><item type="input">10</item></paragraph>
+ <paragraph id="par_id3148449" role="paragraph" localize="false"><item type="input">10</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147238" role="paragraph" xml-lang="en-US"><item type="input">50</item></paragraph>
+ <paragraph id="par_id3147238" role="paragraph" localize="false"><item type="input">50</item></paragraph>
</tablecell>
</tablerow>
</table>
@@ -188,7 +188,7 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_idN10D65" role="tablehead" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_idN10D65" role="tablehead" localize="false">A</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10D6B" role="tablehead" xml-lang="en-US">B (formula)</paragraph>
@@ -199,10 +199,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN10D79" role="tablehead" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_idN10D79" role="tablehead" localize="false">1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10D80" role="paragraph" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_idN10D80" role="paragraph" localize="false">1</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10D86" role="paragraph" xml-lang="en-US">{=IF(A1:A3&gt;0;"yes";"no")}</paragraph>
@@ -213,10 +213,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN10D94" role="tablehead" xml-lang="en-US">2</paragraph>
+ <paragraph id="par_idN10D94" role="tablehead" localize="false">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10D9B" role="paragraph" xml-lang="en-US">0</paragraph>
+ <paragraph id="par_idN10D9B" role="paragraph" localize="false">0</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10DA1" role="paragraph" xml-lang="en-US">{=IF(A1:A3&gt;0;"yes";"no")}</paragraph>
@@ -227,10 +227,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN10DAF" role="tablehead" xml-lang="en-US">3</paragraph>
+ <paragraph id="par_idN10DAF" role="tablehead" localize="false">3</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10DB6" role="paragraph" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_idN10DB6" role="paragraph" localize="false">1</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10DBC" role="paragraph" xml-lang="en-US">{=IF(A1:A3&gt;0;"yes";"no")}</paragraph>
@@ -246,7 +246,7 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_idN10DE2" role="tablehead" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_idN10DE2" role="tablehead" localize="false">A</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10DE8" role="tablehead" xml-lang="en-US">B (formula)</paragraph>
@@ -263,52 +263,52 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN10E02" role="tablehead" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_idN10E02" role="tablehead" localize="false">1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E09" role="tablecontent" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_idN10E09" role="tablecontent" localize="false">1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E0F" role="tablecontent" xml-lang="en-US">=A1:A2+1</paragraph>
+ <paragraph id="par_idN10E0F" role="tablecontent" localize="false">=A1:A2+1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E17" role="tablecontent" xml-lang="en-US">2</paragraph>
+ <paragraph id="par_idN10E17" role="tablecontent" localize="false">2</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10E1D" role="tablecontent" xml-lang="en-US">=SUMPRODUCT(A1:A2+1)</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E25" role="tablecontent" xml-lang="en-US">5</paragraph>
+ <paragraph id="par_idN10E25" role="tablecontent" localize="false">5</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN10E2D" role="tablehead" xml-lang="en-US">2</paragraph>
+ <paragraph id="par_idN10E2D" role="tablehead" localize="false">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E34" role="tablecontent" xml-lang="en-US">2</paragraph>
+ <paragraph id="par_idN10E34" role="tablecontent" localize="false">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E3A" role="tablecontent" xml-lang="en-US">=A1:A2+1</paragraph>
+ <paragraph id="par_idN10E3A" role="tablecontent" localize="false">=A1:A2+1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E42" role="tablecontent" xml-lang="en-US">3</paragraph>
+ <paragraph id="par_idN10E42" role="tablecontent" localize="false">3</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10E48" role="tablecontent" xml-lang="en-US">=SUMPRODUCT(A1:A2+1)</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E50" role="tablecontent" xml-lang="en-US">5</paragraph>
+ <paragraph id="par_idN10E50" role="tablecontent" localize="false">5</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN10E58" role="tablehead" xml-lang="en-US">3</paragraph>
+ <paragraph id="par_idN10E58" role="tablehead" localize="false">3</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E63" role="tablecontent" xml-lang="en-US">=A1:A2+1</paragraph>
+ <paragraph id="par_idN10E63" role="tablecontent" localize="false">=A1:A2+1</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10E6A" role="tablecontent" xml-lang="en-US">#VALUE!</paragraph>
@@ -317,7 +317,7 @@
<paragraph id="par_idN10E70" role="tablecontent" xml-lang="en-US">=SUMPRODUCT(A1:A2+1)</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN10E78" role="tablecontent" xml-lang="en-US">5</paragraph>
+ <paragraph id="par_idN10E78" role="tablecontent" localize="false">5</paragraph>
</tablecell>
</tablerow>
</table>
@@ -359,105 +359,105 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id3155869" role="paragraph" xml-lang="en-US"><emph>A</emph></paragraph>
+ <paragraph id="par_id3155869" role="tablehead" localize="false">A</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149328" role="paragraph" xml-lang="en-US"><emph>B</emph></paragraph>
+ <paragraph id="par_id3149328" role="tablehead" localize="false">B</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152467" role="paragraph" xml-lang="en-US"><emph>C</emph></paragraph>
+ <paragraph id="par_id3152467" role="tablehead" localize="false">C</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154528" role="paragraph" xml-lang="en-US"><emph>1</emph></paragraph>
+ <paragraph id="par_id3154528" role="tablehead" localize="false">1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149744" role="paragraph" xml-lang="en-US">12</paragraph>
+ <paragraph id="par_id3149744" role="paragraph" localize="false">12</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147309" role="paragraph" xml-lang="en-US">5</paragraph>
+ <paragraph id="par_id3147309" role="paragraph" localize="false">5</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154199" role="paragraph" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_id3154199" role="paragraph" localize="false">1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3159218" role="paragraph" xml-lang="en-US"><emph>2</emph></paragraph>
+ <paragraph id="par_id3159218" role="tablehead" localize="false">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153263" role="paragraph" xml-lang="en-US">8</paragraph>
+ <paragraph id="par_id3153263" role="paragraph" localize="false">8</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3156201" role="paragraph" xml-lang="en-US">10</paragraph>
+ <paragraph id="par_id3156201" role="paragraph" localize="false">10</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147552" role="paragraph" xml-lang="en-US">3</paragraph>
+ <paragraph id="par_id3147552" role="paragraph" localize="false">3</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3149174" role="paragraph" xml-lang="en-US"><emph>3</emph></paragraph>
+ <paragraph id="par_id3149174" role="tablehead" localize="false">3</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151201" role="paragraph" xml-lang="en-US">24</paragraph>
+ <paragraph id="par_id3151201" role="paragraph" localize="false">24</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150245" role="paragraph" xml-lang="en-US">15</paragraph>
+ <paragraph id="par_id3150245" role="paragraph" localize="false">15</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159194" role="paragraph" xml-lang="en-US">2</paragraph>
+ <paragraph id="par_id3159194" role="paragraph" localize="false">2</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3146925" role="paragraph" xml-lang="en-US"><emph>4</emph></paragraph>
+ <paragraph id="par_id3146925" role="tablehead" localize="false">4</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154128" role="paragraph" xml-lang="en-US">11</paragraph>
+ <paragraph id="par_id3154128" role="paragraph" localize="false">11</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151067" role="paragraph" xml-lang="en-US">20</paragraph>
+ <paragraph id="par_id3151067" role="paragraph" localize="false">20</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3156033" role="paragraph" xml-lang="en-US">3</paragraph>
+ <paragraph id="par_id3156033" role="paragraph" localize="false">3</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3149298" role="paragraph" xml-lang="en-US"><emph>5</emph></paragraph>
+ <paragraph id="par_id3149298" role="tablehead" localize="false">5</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151382" role="paragraph" xml-lang="en-US">5</paragraph>
+ <paragraph id="par_id3151382" role="paragraph" localize="false">5</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155141" role="paragraph" xml-lang="en-US">25</paragraph>
+ <paragraph id="par_id3155141" role="paragraph" localize="false">25</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145213" role="paragraph" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_id3145213" role="paragraph" localize="false">1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3145268" role="paragraph" xml-lang="en-US"><emph>6</emph></paragraph>
+ <paragraph id="par_id3145268" role="tablehead" localize="false">6</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3163724" role="paragraph" xml-lang="en-US">20</paragraph>
+ <paragraph id="par_id3163724" role="paragraph" localize="false">20</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147132" role="paragraph" xml-lang="en-US">&gt;25</paragraph>
+ <paragraph id="par_id3147132" role="paragraph" localize="false">&gt;25</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3148903" role="paragraph" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_id3148903" role="paragraph" localize="false">1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3151007" role="paragraph" xml-lang="en-US"><emph>7</emph></paragraph>
+ <paragraph id="par_id3151007" role="tablehead" localize="false">7</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153294" role="paragraph" xml-lang="en-US">16</paragraph>
+ <paragraph id="par_id3153294" role="paragraph" localize="false">16</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -466,10 +466,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147284" role="paragraph" xml-lang="en-US"><emph>8</emph></paragraph>
+ <paragraph id="par_id3147284" role="tablehead" localize="false">8</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154914" role="paragraph" xml-lang="en-US">9</paragraph>
+ <paragraph id="par_id3154914" role="paragraph" localize="false">9</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -478,10 +478,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154218" role="paragraph" xml-lang="en-US"><emph>9</emph></paragraph>
+ <paragraph id="par_id3154218" role="tablehead" localize="false">9</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147226" role="paragraph" xml-lang="en-US">7</paragraph>
+ <paragraph id="par_id3147226" role="paragraph" localize="false">7</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -490,10 +490,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3149045" role="paragraph" xml-lang="en-US"><emph>10</emph></paragraph>
+ <paragraph id="par_id3149045" role="tablehead" localize="false">10</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155799" role="paragraph" xml-lang="en-US">16</paragraph>
+ <paragraph id="par_id3155799" role="paragraph" localize="false">16</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -502,10 +502,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3155076" role="paragraph" xml-lang="en-US"><emph>11</emph></paragraph>
+ <paragraph id="par_id3155076" role="tablehead" localize="false">11</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150217" role="paragraph" xml-lang="en-US">33</paragraph>
+ <paragraph id="par_id3150217" role="paragraph" localize="false">33</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -592,7 +592,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN11B69" role="tablehead" localize="false" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_idN11B69" role="tablehead" localize="false">1</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN11B8F" role="tableicontent" localize="false" xml-lang="en-US"><item type="input">2</item></paragraph>
@@ -712,30 +712,30 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id3157922" role="paragraph" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_id3157922" role="tablehead" localize="false">A</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3157945" role="paragraph" xml-lang="en-US">B</paragraph>
+ <paragraph id="par_id3157945" role="tablehead" localize="false">B</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152486" role="paragraph" xml-lang="en-US">C</paragraph>
+ <paragraph id="par_id3152486" role="tablehead" localize="false">C</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152509" role="paragraph" xml-lang="en-US">D</paragraph>
+ <paragraph id="par_id3152509" role="tablehead" localize="false">D</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152532" role="paragraph" xml-lang="en-US">E</paragraph>
+ <paragraph id="par_id3152532" role="tablehead" localize="false">E</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153431" role="paragraph" xml-lang="en-US">F</paragraph>
+ <paragraph id="par_id3153431" role="tablehead" localize="false">F</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153454" role="paragraph" xml-lang="en-US">G</paragraph>
+ <paragraph id="par_id3153454" role="tablehead" localize="false">G</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154995" role="paragraph" xml-lang="en-US"><emph>1</emph></paragraph>
+ <paragraph id="par_id3154995" role="tablehead" localize="false">1</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3155021" role="paragraph" xml-lang="en-US"><item type="input">x1</item></paragraph>
@@ -758,16 +758,16 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3145686" role="paragraph" xml-lang="en-US"><emph>2</emph></paragraph>
+ <paragraph id="par_id3145686" role="tablehead" localize="false">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145713" role="paragraph" xml-lang="en-US"><item type="input">4</item></paragraph>
+ <paragraph id="par_id3145713" role="paragraph" localize="false"><item type="input">4</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145736" role="paragraph" xml-lang="en-US"><item type="input">7</item></paragraph>
+ <paragraph id="par_id3145736" role="paragraph" localize="false"><item type="input">7</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159427" role="paragraph" xml-lang="en-US"><item type="input">100</item></paragraph>
+ <paragraph id="par_id3159427" role="paragraph" localize="false"><item type="input">100</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -783,16 +783,16 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3152408" role="paragraph" xml-lang="en-US"><emph>3</emph></paragraph>
+ <paragraph id="par_id3152408" role="tablehead" localize="false">3</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152435" role="paragraph" xml-lang="en-US"><item type="input">5</item></paragraph>
+ <paragraph id="par_id3152435" role="paragraph" localize="false"><item type="input">5</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152458" role="paragraph" xml-lang="en-US"><item type="input">9</item></paragraph>
+ <paragraph id="par_id3152458" role="paragraph" localize="false"><item type="input">9</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155652" role="paragraph" xml-lang="en-US"><item type="input">105</item></paragraph>
+ <paragraph id="par_id3155652" role="paragraph" localize="false"><item type="input">105</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -808,16 +808,16 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3159506" role="paragraph" xml-lang="en-US"><emph>4</emph></paragraph>
+ <paragraph id="par_id3159506" role="tablehead" localize="false">4</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159533" role="paragraph" xml-lang="en-US"><item type="input">6</item></paragraph>
+ <paragraph id="par_id3159533" role="paragraph" localize="false"><item type="input">6</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159556" role="paragraph" xml-lang="en-US"><item type="input">11</item></paragraph>
+ <paragraph id="par_id3159556" role="paragraph" localize="false"><item type="input">11</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159579" role="paragraph" xml-lang="en-US"><item type="input">104</item></paragraph>
+ <paragraph id="par_id3159579" role="paragraph" localize="false"><item type="input">104</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -833,16 +833,16 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3152655" role="paragraph" xml-lang="en-US"><emph>5</emph></paragraph>
+ <paragraph id="par_id3152655" role="tablehead" localize="false">5</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152682" role="paragraph" xml-lang="en-US"><item type="input">7</item></paragraph>
+ <paragraph id="par_id3152682" role="paragraph" localize="false"><item type="input">7</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152705" role="paragraph" xml-lang="en-US"><item type="input">12</item></paragraph>
+ <paragraph id="par_id3152705" role="paragraph" localize="false"><item type="input">12</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152728" role="paragraph" xml-lang="en-US"><item type="input">108</item></paragraph>
+ <paragraph id="par_id3152728" role="paragraph" localize="false"><item type="input">108</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -850,7 +850,7 @@
<paragraph id="par_id3144352" role="paragraph" xml-lang="en-US"><item type="input">13,21</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3144375" role="paragraph" xml-lang="en-US"><item type="input">4</item></paragraph>
+ <paragraph id="par_id3144375" role="paragraph" localize="false"><item type="input">4</item></paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3144398" role="paragraph" xml-lang="en-US"><item type="input">#NA</item></paragraph>
@@ -858,16 +858,16 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3144425" role="paragraph" xml-lang="en-US"><emph>6</emph></paragraph>
+ <paragraph id="par_id3144425" role="tablehead" localize="false">6</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3144452" role="paragraph" xml-lang="en-US"><item type="input">8</item></paragraph>
+ <paragraph id="par_id3144452" role="paragraph" localize="false"><item type="input">8</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3144475" role="paragraph" xml-lang="en-US"><item type="input">15</item></paragraph>
+ <paragraph id="par_id3144475" role="paragraph" localize="false"><item type="input">15</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3144498" role="paragraph" xml-lang="en-US"><item type="input">111</item></paragraph>
+ <paragraph id="par_id3144498" role="paragraph" localize="false"><item type="input">111</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -883,16 +883,16 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3158306" role="paragraph" xml-lang="en-US"><emph>7</emph></paragraph>
+ <paragraph id="par_id3158306" role="tablehead" localize="false">7</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3158333" role="paragraph" xml-lang="en-US"><item type="input">9</item></paragraph>
+ <paragraph id="par_id3158333" role="paragraph" localize="false"><item type="input">9</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3158356" role="paragraph" xml-lang="en-US"><item type="input">17</item></paragraph>
+ <paragraph id="par_id3158356" role="paragraph" localize="false"><item type="input">17</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3158379" role="paragraph" xml-lang="en-US"><item type="input">120</item></paragraph>
+ <paragraph id="par_id3158379" role="paragraph" localize="false"><item type="input">120</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -905,16 +905,16 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3144560" role="paragraph" xml-lang="en-US"><emph>8</emph></paragraph>
+ <paragraph id="par_id3144560" role="tablehead" localize="false">8</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3144586" role="paragraph" xml-lang="en-US"><item type="input">10</item></paragraph>
+ <paragraph id="par_id3144586" role="paragraph" localize="false"><item type="input">10</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3144609" role="paragraph" xml-lang="en-US"><item type="input">19</item></paragraph>
+ <paragraph id="par_id3144609" role="paragraph" localize="false"><item type="input">19</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3144632" role="paragraph" xml-lang="en-US"><item type="input">133</item></paragraph>
+ <paragraph id="par_id3144632" role="paragraph" localize="false"><item type="input">133</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -995,30 +995,30 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B2F" role="tablehead" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_idN11B2F" role="tablehead" localize="false">A</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B35" role="tablehead" xml-lang="en-US">B</paragraph>
+ <paragraph id="par_idN11B35" role="tablehead" localize="false">B</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B3B" role="tablehead" xml-lang="en-US">C</paragraph>
+ <paragraph id="par_idN11B3B" role="tablehead" localize="false">C</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B41" role="tablehead" xml-lang="en-US">D</paragraph>
+ <paragraph id="par_idN11B41" role="tablehead" localize="false">D</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN11B48" role="tablecontent" xml-lang="en-US">1</paragraph>
+ <paragraph id="par_idN11B48" role="tablehead" localize="false">1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B4E" role="tablecontent" xml-lang="en-US"><item type="input">2</item></paragraph>
+ <paragraph id="par_idN11B4E" role="tablecontent" localize="false"><item type="input">2</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B54" role="tablecontent" xml-lang="en-US"><item type="input">3</item></paragraph>
+ <paragraph id="par_idN11B54" role="tablecontent" localize="false"><item type="input">3</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B5A" role="tablecontent" xml-lang="en-US"><item type="input">4</item></paragraph>
+ <paragraph id="par_idN11B5A" role="tablecontent" localize="false"><item type="input">4</item></paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN11B60" role="tablecontent" xml-lang="en-US"><item type="input">5</item></paragraph>
@@ -1026,36 +1026,36 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN11B67" role="tablecontent" xml-lang="en-US">2</paragraph>
+ <paragraph id="par_idN11B67" role="tablehead" localize="false">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B6D" role="tablecontent" xml-lang="en-US"><item type="input">6</item></paragraph>
+ <paragraph id="par_idN11B6D" role="tablecontent" localize="false"><item type="input">6</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B73" role="tablecontent" xml-lang="en-US"><item type="input">7</item></paragraph>
+ <paragraph id="par_idN11B73" role="tablecontent" localize="false"><item type="input">7</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B79" role="tablecontent" xml-lang="en-US"><item type="input">8</item></paragraph>
+ <paragraph id="par_idN11B79" role="tablecontent" localize="false"><item type="input">8</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B7F" role="tablecontent" xml-lang="en-US"><item type="input">9</item></paragraph>
+ <paragraph id="par_idN11B7F" role="tablecontent" localize="false"><item type="input">9</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_idN11B86" role="tablecontent" xml-lang="en-US">3</paragraph>
+ <paragraph id="par_idN11B86" role="tablehead" localize="false">3</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B8C" role="tablecontent" xml-lang="en-US"><item type="input">10</item></paragraph>
+ <paragraph id="par_idN11B8C" role="tablecontent" localize="false"><item type="input">10</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B92" role="tablecontent" xml-lang="en-US"><item type="input">11</item></paragraph>
+ <paragraph id="par_idN11B92" role="tablecontent" localize="false"><item type="input">11</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B98" role="tablecontent" xml-lang="en-US"><item type="input">12</item></paragraph>
+ <paragraph id="par_idN11B98" role="tablecontent" localize="false"><item type="input">12</item></paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_idN11B9E" role="tablecontent" xml-lang="en-US"><item type="input">13</item></paragraph>
+ <paragraph id="par_idN11B9E" role="tablecontent" localize="false"><item type="input">13</item></paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/source/text/scalc/01/func_fourier.xhp b/source/text/scalc/01/func_fourier.xhp
new file mode 100644
index 0000000000..1c6bb7d8af
--- /dev/null
+++ b/source/text/scalc/01/func_fourier.xhp
@@ -0,0 +1,48 @@
+<?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="functfourier" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">FOURIER function</title>
+ <filename>/text/scalc/01/func_fourier.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="fourier01">
+ <bookmark id="bm_id681556227727944" xml-lang="en-US" branch="hid/SC_HID_FUNC_FOURIER" localize="false"/>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id581556228060864">
+<bookmark_value>FOURIER function</bookmark_value>
+ </bookmark>
+ <h2 id="hd_id551556227727946"><variable id="fourierfunct"><link href="text/scalc/01/func_fourier.xhp" name="fourierfunction">FOURIER</link></variable></h2>
+ <paragraph id="par_id121556227727948" role="paragraph"><variable id="textjoinfunction"><ahelp hid=".">Computes the Discrete Fourier Transform [DFT] of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp></variable> The function is an <link href="text/scalc/01/04060107.xhp" name="array formula">array formula</link>.</paragraph>
+ </section>
+ <embed href="text/scalc/00/avail_release.xhp#6.3"/>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+
+ <paragraph role="code" id="par_id541556228253979">FOURIER(Array, GroupedByColumns, Inverse, Polar, MinimumMagnitude)</paragraph>
+ <paragraph role="paragraph" id="par_id741556228390897"><emph>Array</emph> is a 2 x N or N x 2 range representing an array of complex number to be transformed, where N is the length of the array. The array represents the real and imaginary parts of the data.</paragraph>
+
+ <paragraph role="paragraph" id="par_id621556228397269"><emph>GroupedByColumns</emph> is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE the array is grouped by columns where the first column contains the real part of the complex number and the second columns contains the imaginary part of the complex number. When FALSE, the first row contains the real part of the complex number and the second row contains the imaginary part of the complex number. If there is only 1 column (row), the input sequence is treated as purely real.</paragraph>
+
+ <paragraph role="paragraph" id="par_id631556228516997"><emph>Inverse</emph> is an optional logical (TRUE or FALSE, 1 or 0) argument. When TRUE, calculates the inverse Discrete Fourier Transform. The default value is FALSE.</paragraph>
+
+ <paragraph role="paragraph" id="par_id811561732287508"><emph>Polar</emph>: is an optional logical (TRUE or FALSE, 1 or 0) argument. Indicates whether the final output is in polar coordinates (magnitude, phase). This argument is optional and the default value is FALSE.</paragraph>
+
+ <paragraph role="paragraph" id="par_id661561732521977"><emph>MinimumMagnitude</emph>: used only if Polar=TRUE. All frequency components with magnitude less than <emph>MinimumMagnitude</emph> will be suppressed with a zero magnitude-phase entry. This is very useful when looking at the magnitude-phase spectrum of a signal because there is always some very tiny amount of rounding error when doing FFT algorithms and results in incorrect non-zero phase for non-existent frequencies. By providing a suitable value to this parameter, these non-existent frequency components can be suppressed. By default the value of <emph>MinimumMagnitude</emph> is 0.0, and no suppression is done by default.</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+ <embed href="text/scalc/01/stat_data.xhp#fourierdata"/>
+ <embed href="text/scalc/06/calcsamplefiles.xhp#func_fourier"/>
+ <section id="relatedtopics">
+ <embed href="text/scalc/01/statistics_fourier.xhp#fourieranalysysh1"/>
+ <embed href="text/scalc/01/04060107.xhp#arrayfunctit"/>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp
index b201e36e53..4c88b0d0b4 100644
--- a/source/text/scalc/01/stat_data.xhp
+++ b/source/text/scalc/01/stat_data.xhp
@@ -1,702 +1,1321 @@
<?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 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">
- <title id="tit" xml-lang="en-US">Data</title>
- <filename>/text/scalc/01/stat_data.xhp</filename>
- </topic>
-</meta>
+ <meta>
+ <topic id="ID" indexer="include">
+ <title id="tit" xml-lang="en-US">Data</title>
+ <filename>/text/scalc/01/stat_data.xhp</filename>
+ </topic>
+ </meta>
-<body>
+ <body>
+ <section id="data">
+ <h2 id="hd_id1000010">Data</h2>
+ <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="data">
+ <section id="grouped">
+ <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>
-<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="sampledata01">
-<section id="grouped">
+ <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>
-<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>
+ <table id="Tabela3">
+ <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 id="sampledata01">
+ </section>
-<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>
+ <section id="timeseries01">
-<table id="Tabela3">
- <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>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <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>
-</section>
+ <table id="Tabela8">
+ <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 id="timeseries01">
+ </section>
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<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>
+ <section id="datafortests">
-<table id="Tabela8">
- <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>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <paragraph id="par_id1000970" role="paragraph" xml-lang="en-US">The following table has two data sets.</paragraph>
-</section>
+ <table id="Tabela9">
+ <tablerow>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1000980" role="tablehead" xml-lang="en-US" localize="false">A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1000990" role="tablehead" xml-lang="en-US" localize="false">B</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001000" role="tablehead" xml-lang="en-US" localize="false">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001010" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001020" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001030" role="tablehead" xml-lang="en-US" localize="false">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001040" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001050" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001060" role="tablehead" xml-lang="en-US" localize="false">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001070" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001080" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001090" role="tablehead" xml-lang="en-US" localize="false">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001100" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001110" role="tablecontent" xml-lang="en-US" localize="false">5</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001120" role="tablehead" xml-lang="en-US" localize="false">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001130" role="tablecontent" xml-lang="en-US" localize="false">20</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001140" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001150" role="tablehead" xml-lang="en-US" localize="false">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001160" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001170" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001180" role="tablehead" xml-lang="en-US" localize="false">7</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001190" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001200" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001210" role="tablehead" xml-lang="en-US" localize="false">8</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001220" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001230" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001240" role="tablehead" xml-lang="en-US" localize="false">9</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001250" role="tablecontent" xml-lang="en-US" localize="false">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001260" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001270" role="tablehead" xml-lang="en-US" localize="false">10</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001280" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001290" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001300" role="tablehead" xml-lang="en-US" localize="false">11</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001310" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001320" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001330" role="tablehead" xml-lang="en-US" localize="false">12</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001340" role="tablecontent" xml-lang="en-US" localize="false">8</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001350" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001360" role="tablehead" xml-lang="en-US" localize="false">13</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001370" role="tablecontent" xml-lang="en-US" localize="false">9</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001380" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
-<section id="datafortests">
+ </section>
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id1000970" role="paragraph" xml-lang="en-US">The following table has two data sets.</paragraph>
+ <section id="regressiondata">
-<table id="Tabela9">
- <tablerow>
- <tablecell>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1000980" role="tablehead" xml-lang="en-US" localize="false">A</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1000990" role="tablehead" xml-lang="en-US" localize="false">B</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001000" role="tablehead" xml-lang="en-US" localize="false">1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001010" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001020" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001030" role="tablehead" xml-lang="en-US" localize="false">2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001040" role="tablecontent" xml-lang="en-US" localize="false">26</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001050" role="tablecontent" xml-lang="en-US" localize="false">13</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001060" role="tablehead" xml-lang="en-US" localize="false">3</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001070" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001080" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001090" role="tablehead" xml-lang="en-US" localize="false">4</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001100" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001110" role="tablecontent" xml-lang="en-US" localize="false">5</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001120" role="tablehead" xml-lang="en-US" localize="false">5</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001130" role="tablecontent" xml-lang="en-US" localize="false">20</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001140" role="tablecontent" xml-lang="en-US" localize="false">34</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001150" role="tablehead" xml-lang="en-US" localize="false">6</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001160" role="tablecontent" xml-lang="en-US" localize="false">27</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001170" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001180" role="tablehead" xml-lang="en-US" localize="false">7</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001190" role="tablecontent" xml-lang="en-US" localize="false">28</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001200" role="tablecontent" xml-lang="en-US" localize="false">31</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001210" role="tablehead" xml-lang="en-US" localize="false">8</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001220" role="tablecontent" xml-lang="en-US" localize="false">14</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001230" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001240" role="tablehead" xml-lang="en-US" localize="false">9</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001250" role="tablecontent" xml-lang="en-US" localize="false">4</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001260" role="tablecontent" xml-lang="en-US" localize="false">24</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001270" role="tablehead" xml-lang="en-US" localize="false">10</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001280" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001290" role="tablecontent" xml-lang="en-US" localize="false">23</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001300" role="tablehead" xml-lang="en-US" localize="false">11</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001310" role="tablecontent" xml-lang="en-US" localize="false">2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001320" role="tablecontent" xml-lang="en-US" localize="false">19</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001330" role="tablehead" xml-lang="en-US" localize="false">12</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001340" role="tablecontent" xml-lang="en-US" localize="false">8</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001350" role="tablecontent" xml-lang="en-US" localize="false">10</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id1001360" role="tablehead" xml-lang="en-US" localize="false">13</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001370" role="tablecontent" xml-lang="en-US" localize="false">9</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id1001380" role="tablecontent" xml-lang="en-US" localize="false">33</paragraph>
- </tablecell>
- </tablerow>
-</table>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <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="table regression">
+ <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>
-</section>
+ <section id="fourierdata">
+ <table id="fouriertable">
+ <tablerow>
+ <tablecell colspan="2">
+ <paragraph role="paragraph" id="par_id11561818344892"><emph>Group By Columns</emph></paragraph>
+ </tablecell>
+ <tablecell colspan="3">
+ <paragraph role="paragraph" id="par_id151561818353339">TRUE</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="2">
+ <paragraph role="paragraph" id="par_id141561818361892"><emph>Polar</emph></paragraph>
+ </tablecell>
+ <tablecell colspan="3">
+ <paragraph role="paragraph" id="par_id361561818366868">FALSE</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="2">
+ <paragraph role="paragraph" id="par_id181561818387534"><emph>Inverse</emph></paragraph>
+ </tablecell>
+ <tablecell colspan="3">
+ <paragraph role="paragraph" id="par_id681561818391189">FALSE</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="2">
+ <paragraph id="par_id201561827895671" role="paragraph"><emph>Formula</emph></paragraph>
+ </tablecell>
+ <tablecell colspan="3">
+ <paragraph role="paragraph" id="par_id361561818379679">{=FOURIER(B6:C40,B1,B2,B3,0)}</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="2" >
+ <paragraph role="tablehead" id="par_id711561818399814"><emph>Source Array</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell colspan="2" >
+ <paragraph role="tablehead" id="par_id551561818405550"><emph>Transformed Array</emph></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="tablecontent" id="par_id581561818425613"><emph>Real</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="tablecontent" id="par_id251561818431620"><emph>Imaginary</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="tablecontent" id="par_id161561818436495"><emph>Real</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="tablecontent" id="par_id471561818441429"><emph>Imaginary</emph></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id801561818463882">0.392555411592569</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id721561818470696">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id901561818478432">17.1775578743134</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id231561818483198">3.88635177703826E-015</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id451561818495372">1.20843701681219</paragraph>
-<section id="regressiondata">
-
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<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>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id841561818500031">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id351561818505918">3.428868795359</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id741561818511221">2.37164790000189</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id71561818588117">0.851477676762644</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id151561818594448">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id781561818600947">-6.80271615433369</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id331561818606157">-15.1345439297576</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id511561818617438">1.78534651907738</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id71561818624526">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id511561818630050">-1.605447356601</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id531561818635293">-5.08653060378972</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id201561818646809">1.77946506138316</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id181561818652799">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id941561818657440">0.395847917447356</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id211561818662346">-2.41926785527625</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id201561818672591">1.51890060220168</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id521561818697771">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id231561818703358">-1.49410383304833</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id351561818708108">-2.39148041275</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id511561818720692">1.04694666137238</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id81561818725058">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id631561818732885">0.87223579298981</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id491561818737195">-1.14394086206797</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id341561818748455">0.83110083951399</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id731561818753079">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id171561818760856">1.5332458505929</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id371561818765611">0.678159168870983</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id271561818784104">1.23006228455127</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id661561818790833">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id101561818795844">0.450563708411459</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id31561818802582">0.22911248792634</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id11561818812548">0.133409796396031</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id41561818817467">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id461561818823748">0.545106616940358</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id761561818828054">0.411028927740438</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id961561818837482">0.130471655802496</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id651561818842250">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id281561818846175">2.22685996425193</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id891561818850209">-2.43092236748302</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id391561818882179">0.386478761838145</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id511561818888890">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id11561818894216">-1.61522859107175</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id781561818899764">-2.41682657284899</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id801561818913687">-0.703398287742919</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id871561818918456">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id651561818923166">1.30245078290168</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id381561818928231">1.45443785733126</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id781561818940758">-0.899115309693977</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id971561818947103">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id111561818951932">1.57930628561185</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id961561818966489">-1.33862736591677</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id151561818975263">-0.124045510064504</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id501561818979823">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id471561818985572">-1.07572227365276</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id331561818991587">-0.921557968003809</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id861561819001577">-0.513553513012611</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id511561819007803">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id851561819018109">-0.0557824179238028</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id1001561819024945">-1.81336029451831</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id201561819246213">-0.613559196487517</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id651561819250743">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id71561819260676">-0.577666040004067</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id551561819266277">1.38887243891951</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id431561819277248">0.32607259491689</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id791561819282068">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id621561819290524">-0.826878282157686</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id981561819297732">-0.186591000796403</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id261561819306914">0.0316297814625926</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id251561819311860">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id391561819316479">-0.826878282157715</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id961561819322645">0.186591000796416</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id731561819333339">0.52298725899815</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id941561819339393">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id121561819344871">-0.577666040004051</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" localize="false" id="par_id971561819349810">-1.38887243891954</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id731561819392346" localize="false">0.436798031445888</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id561561819399250" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id61561819405840" localize="false">-0.0557824179237846</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id191561819410154" localize="false">1.81336029451832</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id71561819420534" localize="false">0.846212627320418</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id461561819426024" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id21561819430293" localize="false">-1.07572227365276</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id511561819434519" localize="false">0.921557968003802</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id291561819447556" localize="false">0.913061096906024</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id521561819452047" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id91561819456321" localize="false">1.57930628561187</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id301561819461753" localize="false">1.33862736591678</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id521561819471243" localize="false">1.2666287534781</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id921561819476877" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id861561819481609" localize="false">1.3024507829017</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id281561819486147" localize="false">-1.45443785733125</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id851561819501489" localize="false">1.6653650481107</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id301561819506930" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id701561819513459" localize="false">-1.61522859107176</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id831561819519487" localize="false">2.416826572849</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id681561819528152" localize="false">1.36582636202864</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id91561819533149" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id361561819538204" localize="false">2.22685996425191</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id981561819543324" localize="false">2.43092236748304</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id571561819553521" localize="false">1.46722190894756</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id931561819558299" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id681561819565335" localize="false">0.545106616940365</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id861561819569932" localize="false">-0.411028927740441</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id491561819657054" localize="false">0.66120489728397</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id641561819661633" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id911561819665799" localize="false">0.450563708411458</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id641561819670302" localize="false">-0.229112487926344</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id411561819678799" localize="false">0.701534531762234</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id821561819683412" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id271561819689747" localize="false">1.53324585059292</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id151561819694309" localize="false">-0.678159168870965</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id571561819705483" localize="false">0.65869368245062</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id231561819709872" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id71561819715948" localize="false">0.872235792989797</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id551561819721648" localize="false">1.14394086206799</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id211561819731261" localize="false">0.287522455580069</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id861561819735297" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id281561819740362" localize="false">-1.49410383304834</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id821561819745383" localize="false">2.39148041275001</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id241561819755044" localize="false">-0.409911360506096</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id401561819759465" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id161561819764609" localize="false">0.395847917447327</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id821561819768996" localize="false">2.41926785527626</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id981561819778078" localize="false">-0.583168875679498</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id1001561819781923" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id471561819786217" localize="false">-1.60544735660102</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id671561819789866" localize="false">5.08653060378972</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id21561819799738" localize="false">-0.799684083650078</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id851561819803994" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id671561819808109" localize="false">-6.80271615433379</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id631561819812163" localize="false">15.1345439297575</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id961561819820866" localize="false">-0.621417306845244</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id361561819824853" localize="false">0</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id811561819835495" localize="false">3.42886879535907</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id451561819841409" localize="false">-2.37164790000194</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ </body>
</helpdocument>
diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp
index 52b3a60811..e48774db3e 100644
--- a/source/text/scalc/01/statistics.xhp
+++ b/source/text/scalc/01/statistics.xhp
@@ -1658,15 +1658,15 @@
</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"/>
-<paragraph id="hd_id1000240" role="heading" xml-lang="en-US" level="2">Chi-square test</paragraph>
+<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>
-<paragraph id="hd_id1000250" role="heading" xml-lang="en-US" level="3">Data</paragraph>
-<paragraph id="par_id1004010" role="paragraph" xml-lang="en-US"><emph>Input range</emph>: The reference of the range of the data series to analyze.</paragraph>
-<paragraph id="par_id1004020" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/>
+<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>
diff --git a/source/text/scalc/01/statistics_fourier.xhp b/source/text/scalc/01/statistics_fourier.xhp
new file mode 100644
index 0000000000..383cb88576
--- /dev/null
+++ b/source/text/scalc/01/statistics_fourier.xhp
@@ -0,0 +1,656 @@
+<?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 id="tit" xml-lang="en-US">Fourier Analysis</title>
+ <filename>/text/scalc/01/statistics_fourier.xhp</filename>
+ </topic>
+ </meta>
+
+ <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="howtoget">
+ <paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Fourier Analysis</emph></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>
+
+ <embed href="text/scalc/01/stat_data.xhp#data"/>
+ <paragraph role="paragraph" id="par_id301561811172762"><emph>Input range has label</emph>: Mark when the first row or column of the input array is actually a label and not part of the data analysis.</paragraph>
+ <paragraph role="paragraph" id="par_id741556228390897">Input Range is a 2 x N or N x 2 range representing an array of complex number to be transformed, where N is the length of the array. The array represents the real and imaginary parts of the data.</paragraph>
+ <embed href="text/scalc/01/stat_data.xhp#grouped"/>
+
+ <h3 id="hd_id211561811324208">Options:</h3>
+ <paragraph role="paragraph" id="par_id631556228516997"><emph>Inverse</emph>: When checked, calculates the inverse Discrete Fourier Transform.</paragraph>
+ <paragraph role="paragraph" id="par_id811561732287508"><emph>Polar</emph>: When checked, the results are in polar coordinates (magnitude, phase).</paragraph>
+ <paragraph role="paragraph" id="par_id661561732521977"><emph>Minimum magnitude for polar form output (in dB)</emph>: used only when output is in polar form. All frequency components with magnitude less than this value in decibels will be suppressed with a zero magnitude-phase entry. This is very useful when looking at the magnitude-phase spectrum of a signal because there is always some very tiny amount of rounding error when doing FFT algorithms and results in incorrect non-zero phase for non-existent frequencies. By providing a suitable value to this parameter, these non-existent frequency components can be suppressed.</paragraph>
+
+ <embed href="text/scalc/06/calcsamplefiles.xhp#func_fourier"/>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+ <paragraph role="paragraph" id="par_id731561827207828">The source data for this example is the same of the <link href="text/scalc/01/func_fourier.xhp" name="Fourier function">FOURIER function page</link>.</paragraph>
+ <table id="Tabela1">
+ <tablerow>
+ <tablecell colspan="2">
+ <paragraph id="par_id290620191257279817" role="tablehead">Fourier Transform</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell colspan="2">
+ <paragraph id="par_id29062019125727379" role="tablehead">Fourier Transform</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell colspan="2">
+ <paragraph id="par_id290620191257276510" role="tablecontent"><emph>Input data range : $B$6:$C$40</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell colspan="2">
+ <paragraph id="par_id290620191257273433" role="tablecontent"><emph>Input data range : $B$6:$C$40</emph></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257273688" role="tablecontent"><emph>Real</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257276202" role="tablecontent"><emph>Imaginary</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id481561825547527" role="tablecontent"><emph>Magnitude</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id751561825556834" role="tablecontent"><emph>Phase</emph></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id29062019125727529" role="tablecontent" localize="false">17.1775578743134</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257277650" role="tablecontent" localize="false">3.88635177703826E-15</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id711561825563346" role="tablecontent" localize="false">17.1775578743134</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id901561825568423" role="tablecontent" localize="false">2.26245884628906E-16</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257274698" role="tablecontent" localize="false">3.428868795359</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257276895" role="tablecontent" localize="false">2.37164790000189</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id201561825580585" role="tablecontent" localize="false">4.16915518748944</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id101561825584332" role="tablecontent" localize="false">0.605113892937279</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257278831" role="tablecontent" localize="false">-6.80271615433369</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257273532" role="tablecontent" localize="false">-15.1345439297576</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id711561825589842" role="tablecontent" localize="false">16.5931120359682</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id81561825619703" role="tablecontent" localize="false">-1.99322000923881</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257274709" role="tablecontent" localize="false">-1.605447356601</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257276525" role="tablecontent" localize="false">-5.08653060378972</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id991561825625022" role="tablecontent" localize="false">5.33387802617444</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id21561825629228" role="tablecontent" localize="false">-1.87652762269615</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257272245" role="tablecontent" localize="false">0.395847917447356</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257274310" role="tablecontent" localize="false">-2.41926785527625</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id701561825635119" role="tablecontent" localize="false">2.45143886917874</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id831561825638615" role="tablecontent" localize="false">-1.40861048708919</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id29062019125727326" role="tablecontent" localize="false">-1.49410383304833</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257275013" role="tablecontent" localize="false">-2.39148041275</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id241561825641911" role="tablecontent" localize="false">2.81984482347817</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id221561825645728" role="tablecontent" localize="false">-2.12922380028329</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257277775" role="tablecontent" localize="false">0.87223579298981</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257277856" role="tablecontent" localize="false">-1.14394086206797</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id671561825649808" role="tablecontent" localize="false">1.43853952829993</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id321561825657817" role="tablecontent" localize="false">-0.919353665468368</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257274532" role="tablecontent" localize="false">1.5332458505929</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257279129" role="tablecontent" localize="false">0.678159168870983</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id681561825661535" role="tablecontent" localize="false">1.6765269746366</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id671561825665344" role="tablecontent" localize="false">0.416434654153369</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257287695" role="tablecontent" localize="false">0.450563708411459</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257286376" role="tablecontent" localize="false">0.22911248792634</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id511561825670030" role="tablecontent" localize="false">0.505470263676592</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id761561825674325" role="tablecontent" localize="false">0.470425948779898</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257286648" role="tablecontent" localize="false">0.545106616940358</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257285951" role="tablecontent" localize="false">0.411028927740438</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id91561825686459" role="tablecontent" localize="false">0.682704916689207</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id561561825689880" role="tablecontent" localize="false">0.646077879418302</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257285124" role="tablecontent" localize="false">2.22685996425193</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257286584" role="tablecontent" localize="false">-2.43092236748302</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id151561825697930" role="tablecontent" localize="false">3.29670879167654</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id381561825701512" role="tablecontent" localize="false">-0.829181229907427</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257286986" role="tablecontent" localize="false">-1.61522859107175</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257281114" role="tablecontent" localize="false">-2.41682657284899</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id891561825705846" role="tablecontent" localize="false">2.90689079338124</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id11561825709464" role="tablecontent" localize="false">-2.15994697868441</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257283083" role="tablecontent" localize="false">1.30245078290168</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257287927" role="tablecontent" localize="false">1.45443785733126</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id611561825715444" role="tablecontent" localize="false">1.95237484175544</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id871561825718419" role="tablecontent" localize="false">0.840472341525344</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257281022" role="tablecontent" localize="false">1.57930628561185</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257288920" role="tablecontent" localize="false">-1.33862736591677</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id171561825722999" role="tablecontent" localize="false">2.07029745895472</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id381561825726528" role="tablecontent" localize="false">-0.70310180067089</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id29062019125728198" role="tablecontent" localize="false">-1.07572227365276</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257281880" role="tablecontent" localize="false">-0.921557968003809</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id621561825733235" role="tablecontent" localize="false">1.41649126309482</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id911561825736891" role="tablecontent" localize="false">-2.43322886402899</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257286891" role="tablecontent" localize="false">-0.055782417923803</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257285354" role="tablecontent" localize="false">-1.81336029451831</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id71561825745885" role="tablecontent" localize="false">1.81421807837012</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id341561825750480" role="tablecontent" localize="false">-1.60154853447151</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257283162" role="tablecontent" localize="false">-0.577666040004067</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257282542" role="tablecontent" localize="false">1.38887243891951</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id851561825755054" role="tablecontent" localize="false">1.50421564456836</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id141561825758670" role="tablecontent" localize="false">1.96495487990047</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257285160" role="tablecontent" localize="false">-0.826878282157686</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257287292" role="tablecontent" localize="false">-0.186591000796403</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id41561825766562" role="tablecontent" localize="false">0.847669685126376</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id721561825770334" role="tablecontent" localize="false">-2.91965280961949</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257285848" role="tablecontent" localize="false">-0.826878282157715</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257289336" role="tablecontent" localize="false">0.186591000796416</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id471561825776243" role="tablecontent" localize="false">0.847669685126408</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id991561825781290" role="tablecontent" localize="false">2.91965280961948</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257288490" role="tablecontent" localize="false">-0.577666040004051</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257284271" role="tablecontent" localize="false">-1.38887243891954</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id661561825788196" role="tablecontent" localize="false">1.50421564456838</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id321561825791887" role="tablecontent" localize="false">-1.96495487990045</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id29062019125728802" role="tablecontent" localize="false">-0.055782417923785</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257284034" role="tablecontent" localize="false">1.81336029451832</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id851561825796754" role="tablecontent" localize="false">1.81421807837012</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id691561825800702" role="tablecontent" localize="false">1.6015485344715</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257288282" role="tablecontent" localize="false">-1.07572227365276</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257283112" role="tablecontent" localize="false">0.921557968003802</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id171561825805651" role="tablecontent" localize="false">1.41649126309482</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id651561825809772" role="tablecontent" localize="false">2.433228864029</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257287702" role="tablecontent" localize="false">1.57930628561187</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257293964" role="tablecontent" localize="false">1.33862736591678</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id31561825813387" role="tablecontent" localize="false">2.07029745895474</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id261561825818319" role="tablecontent" localize="false">0.703101800670888</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257298813" role="tablecontent" localize="false">1.3024507829017</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257292229" role="tablecontent" localize="false">-1.45443785733125</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id811561825823956" role="tablecontent" localize="false">1.95237484175543</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id781561825828580" role="tablecontent" localize="false">-0.840472341525331</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id29062019125729581" role="tablecontent" localize="false">-1.61522859107176</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257299086" role="tablecontent" localize="false">2.416826572849</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001561825833977" role="tablecontent" localize="false">2.90689079338125</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id11561825837094" role="tablecontent" localize="false">2.15994697868441</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257296839" role="tablecontent" localize="false">2.22685996425191</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257292861" role="tablecontent" localize="false">2.43092236748304</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id791561825843164" role="tablecontent" localize="false">3.29670879167653</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id41561825846486" role="tablecontent" localize="false">0.829181229907435</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257291686" role="tablecontent" localize="false">0.545106616940365</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257299836" role="tablecontent" localize="false">-0.411028927740441</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id771561825852156" role="tablecontent" localize="false">0.682704916689214</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id941561825855686" role="tablecontent" localize="false">-0.646077879418299</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257292523" role="tablecontent" localize="false">0.450563708411458</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257295218" role="tablecontent" localize="false">-0.229112487926344</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id61561825860084" role="tablecontent" localize="false">0.505470263676594</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id741561825863994" role="tablecontent" localize="false">-0.470425948779905</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257297879" role="tablecontent" localize="false">1.53324585059292</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257293381" role="tablecontent" localize="false">-0.678159168870965</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id661561825873072" role="tablecontent" localize="false">1.6765269746366</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id81561825876773" role="tablecontent" localize="false">-0.416434654153355</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id29062019125729145" role="tablecontent" localize="false">0.872235792989797</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257299200" role="tablecontent" localize="false">1.14394086206799</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id221561825883285" role="tablecontent" localize="false">1.43853952829994</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id281561825886634" role="tablecontent" localize="false">0.919353665468386</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257298876" role="tablecontent" localize="false">-1.49410383304834</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257295073" role="tablecontent" localize="false">2.39148041275001</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id411561825892297" role="tablecontent" localize="false">2.81984482347818</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id631561825897202" role="tablecontent" localize="false">2.12922380028329</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257295843" role="tablecontent" localize="false">0.395847917447327</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257292406" role="tablecontent" localize="false">2.41926785527626</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id941561825902058" role="tablecontent" localize="false">2.45143886917875</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id101561825905350" role="tablecontent" localize="false">1.4086104870892</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257294283" role="tablecontent" localize="false">-1.60544735660102</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257293991" role="tablecontent" localize="false">5.08653060378972</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id811561825912635" role="tablecontent" localize="false">5.33387802617445</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461561825916257" role="tablecontent" localize="false">1.87652762269616</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257291705" role="tablecontent" localize="false">-6.80271615433379</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257294294" role="tablecontent" localize="false">15.1345439297575</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id831561825920319" role="tablecontent" localize="false">16.5931120359682</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id441561825923790" role="tablecontent" localize="false">1.99322000923882</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id290620191257297686" role="tablecontent" localize="false">3.42886879535907</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id290620191257296150" role="tablecontent" localize="false">-2.37164790000194</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id151561825927729" role="tablecontent" localize="false">4.16915518748952</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id551561825934063" role="tablecontent" localize="false">-0.605113892937279</paragraph>
+ </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>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/statistics_regression.xhp b/source/text/scalc/01/statistics_regression.xhp
index 07e2a5d2c8..c45fa0fce1 100644
--- a/source/text/scalc/01/statistics_regression.xhp
+++ b/source/text/scalc/01/statistics_regression.xhp
@@ -27,15 +27,13 @@
<body>
-
-<paragraph id="hd_id1701201615033510" role="heading" level="2" xml-lang="en-US">Regression Analysis</paragraph>
+<h1 id="hd_id1701201615033510"><variable id="regressionanalysish1"><link href="text/scalc/01/statistics_regression.xhp" name="regersion 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 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_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"/>
@@ -318,11 +316,9 @@
</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>
</section>
-</section>
</body>
-
</helpdocument>