source/text/scalc/00/00000412.xhp | 109 ++++++++++++++++++++
source/text/scalc/01/12080000.xhp | 10 -
source/text/scalc/01/12080300.xhp | 2
source/text/scalc/01/12080400.xhp | 2
source/text/scalc/01/live_data_stream.xhp | 2
source/text/scalc/01/statistics.xhp | 12 +-
source/text/scalc/01/statistics_anova.xhp | 112 ++++++++++-----------
source/text/scalc/01/statistics_correlation.xhp | 48 ++++-----
source/text/scalc/01/statistics_covariance.xhp | 44 ++++----
source/text/scalc/01/statistics_descriptive.xhp | 128 ++++++++++++------------
source/text/scalc/01/statistics_exposmooth.xhp | 84 ++++++++-------
source/text/scalc/01/statistics_fourier.xhp | 20 ++-
source/text/scalc/01/statistics_movingavg.xhp | 6 -
source/text/scalc/01/statistics_regression.xhp | 25 ++--
source/text/scalc/01/statistics_sampling.xhp | 122 +++++++++++-----------
source/text/scalc/01/statistics_test_chisqr.xhp | 36 +++---
source/text/scalc/01/statistics_test_f.xhp | 88 ++++++++--------
source/text/scalc/01/statistics_test_t.xhp | 92 ++++++++---------
source/text/scalc/01/statistics_test_z.xhp | 78 +++++++-------
source/text/scalc/main0112.xhp | 3
20 files changed, 578 insertions(+), 445 deletions(-)
New commits:
commit 77b44d5655ac785543535fbd05d422316ff68d0a
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Jan 5 11:42:54 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri Jan 5 19:49:07 2024 +0100
tdf#155876 UI cmds Calc-Sheet menu (49)
+ Data menu for Calc, Statistics commands
+ fixes
+ refactoring
Change-Id: I7ef7700412232bc6265c537c94207f42c498e639
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161690
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000412.xhp
b/source/text/scalc/00/00000412.xhp
index 75e29aeb62..8b691c9dc0 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -644,5 +644,114 @@
</tablerow>
</table>
</section>
+ <section id="statistics">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id471704386872787">Choose
<menuitem>Data - Statistics</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id361704462605759">Choose
<menuitem>Data - Statistics</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id641704462610723">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id541704461144979">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id791704461144980"
role="paragraph"><image src="cmd/lc_statisticsmenu.svg"
id="img_id511704461144981" width="1cm" height="1cm"><alt
id="alt_id761704461144982">Icon Statistics</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id741704461144984"
role="paragraph">Statistics</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+ <section id="stat_sampling">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id1000040" role="paragraph">Choose <menuitem>Data -
Statistics - Sampling</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id981704462941856">Choose
<menuitem>Data - Statistics - Sampling</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id221704462945303">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Sampling</menuitem>.</paragraph>
+ </section>
+ <section id="stat_descriptive">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id621704463141747" role="paragraph">Choose
<menuitem>Data - Statistics - Descriptive Statistics</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id291704463195858">Choose
<menuitem>Data - Statistics - Descriptive Statistics</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id421704463199642">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Descriptive Statistics</menuitem>.</paragraph>
+ </section>
+ <section id="stat_anova">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id1001250" role="paragraph">Choose <menuitem>Data -
Statistics - Analysis of Variance (ANOVA)</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id991704463588928">Choose
<menuitem>Data - Statistics - Analysis of Variance
(ANOVA)</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id991704463592208">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Analysis of Variance (ANOVA)</menuitem>.</paragraph>
+ </section>
+ <section id="stat_correlation">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id261704463752644" role="paragraph">Choose
<menuitem>Data - Statistics - Correlation</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id491704463758812">Choose
<menuitem>Data - Statistics - Correlation</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id631704463761947">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Correlation</menuitem>.</paragraph>
+ </section>
+ <section id="stat_covariance">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id1001950" role="paragraph">Choose <menuitem>Data -
Statistics - Covariance</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id31704463917441">Choose
<menuitem>Data - Statistics - Covariance</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id531704463920208">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Covariance</menuitem>.</paragraph>
+ </section>
+ <section id="stat_expon">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id1002130" role="paragraph">Choose <menuitem>Data -
Statistics - Exponential Smoothing</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id591704464123553">Choose
<menuitem>Data - Statistics - Exponential Smoothing</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id121704464126315">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Exponential Smoothing</menuitem>.</paragraph>
+ </section>
+ <section id="stat_movingavg">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id781704464266839" role="paragraph">Choose
<menuitem>Data - Statistics - Moving Average</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id681704464144618">Choose
<menuitem>Data - Statistics - Moving Average</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id821704464147643">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Moving Average</menuitem>.</paragraph>
+ </section>
+ <section id="stat_regression">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id731704464349309" role="paragraph">Choose
<menuitem>Data - Statistics - Regression</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id41704464352982">Choose
<menuitem>Data - Statistics - Regression</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id781704464356845">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Regression</menuitem>.</paragraph>
+ </section>
+ <section id="stat_ttest">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id1002830" role="paragraph">Choose <menuitem>Data -
Statistics - Paired t-test</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id651704464561944">Choose
<menuitem>Data - Statistics - Paired t-test</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id851704464564768">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Paired t-test</menuitem>.</paragraph>
+ </section>
+ <section id="stat_ftest">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id791704464660029" role="paragraph">Choose
<menuitem>Data - Statistics - F-test</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id911704464663694">Choose
<menuitem>Data - Statistics - F-test</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id101704464667638">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - F-test</menuitem>.</paragraph>
+ </section>
+ <section id="stat_ztest">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id1003650" role="paragraph">Choose <menuitem>Data -
Statistics - Z-test</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id651704464793226">Choose
<menuitem>Data - Statistics - Z-test</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id821704464796362">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Z-test</menuitem>.</paragraph>
+ </section>
+ <section id="stat_chitest">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id1003990" role="paragraph"><variable
id="sam02">Choose <menuitem>Data - Statistics - Chi-square
Test</menuitem></variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id81704464923384">Choose
<menuitem>Data - Statistics - Chi-square Test</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id481704464926832">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Chi-square Test</menuitem>.</paragraph>
+ </section>
+ <section id="stat_fourier">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id101704465098092" role="paragraph">Choose
<menuitem>Data - Statistics - Fourier Analysis</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id851704465051620">Choose
<menuitem>Data - Statistics - Fourier Analysis</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id701704465054813">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Statistics - Fourier Analysis</menuitem>.</paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12080000.xhp
b/source/text/scalc/01/12080000.xhp
index 36ff292db7..d4c95f8dd0 100644
--- a/source/text/scalc/01/12080000.xhp
+++ b/source/text/scalc/01/12080000.xhp
@@ -42,13 +42,11 @@
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#group_menu"/>
</section>
-<embed href="text/scalc/01/12080100.xhp#hide_details"/>
-<embed href="text/scalc/01/12080200.xhp#show_details"/>
-<h2 id="hd_id3147229"><link href="text/scalc/01/12080300.xhp">Group</link></h2>
-<embed href="text/scalc/01/12080300.xhp#gruppierung"/>
-<h2 id="hd_id3153188"><link
href="text/scalc/01/12080400.xhp">Ungroup</link></h2>
-<embed href="text/scalc/01/12080400.xhp#gruppierungauf"/>
+<embed href="text/scalc/01/12080300.xhp#group"/>
+<embed href="text/scalc/01/12080400.xhp#ungroup"/>
<embed href="text/scalc/01/12080500.xhp#auto_outline"/>
<embed href="text/scalc/01/12080600.xhp#remove"/>
+<embed href="text/scalc/01/12080200.xhp#show_details"/>
+<embed href="text/scalc/01/12080100.xhp#hide_details"/>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/12080300.xhp
b/source/text/scalc/01/12080300.xhp
index ae2569a786..a92a834361 100644
--- a/source/text/scalc/01/12080300.xhp
+++ b/source/text/scalc/01/12080300.xhp
@@ -34,8 +34,8 @@
<bookmark branch="hid/modules/scalc/ui/groupdialog/@@nowidget@@"
id="bm_id3156329" localize="false"/>
<section id="group">
<h1 id="hd_id3153088"><link href="text/scalc/01/12080300.xhp">Group</link></h1>
- </section>
<paragraph role="paragraph" id="par_id3153821"><variable
id="gruppierung"><ahelp hid=".">Defines the selected cell range as a group of
rows or columns.</ahelp></variable></paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#data_outline_group"/>
</section>
diff --git a/source/text/scalc/01/12080400.xhp
b/source/text/scalc/01/12080400.xhp
index d48adeaee4..4abc050762 100644
--- a/source/text/scalc/01/12080400.xhp
+++ b/source/text/scalc/01/12080400.xhp
@@ -32,8 +32,8 @@
<bookmark branch="hid/.uno:Ungroup" id="bm_id3153561" localize="false"/>
<section id="ungroup">
<h1 id="hd_id3148492"><link
href="text/scalc/01/12080400.xhp">Ungroup</link></h1>
- </section>
<paragraph role="paragraph" id="par_id3151384"><variable
id="gruppierungauf"><ahelp hid=".uno:Ungroup" visibility="visible">Ungroups the
selection. In a nested group, the last rows or columns that were added are
removed from the group.</ahelp></variable></paragraph>
+</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#data_outline_ungroup"/>
</section>
diff --git a/source/text/scalc/01/live_data_stream.xhp
b/source/text/scalc/01/live_data_stream.xhp
index 17bfc00de2..d003dcb555 100644
--- a/source/text/scalc/01/live_data_stream.xhp
+++ b/source/text/scalc/01/live_data_stream.xhp
@@ -33,7 +33,7 @@
<bookmark_value>Data Stream;Streams</bookmark_value>
</bookmark>
<section id="live_data_stream">
- <h1 id="hd_id240920171003006302"><link
href="text/scalc/01/live_data_stream.xhp">Live Data Stream</link></h1>
+ <h1 id="hd_id240920171003006302"><link
href="text/scalc/01/live_data_stream.xhp">Streams</link></h1>
<paragraph id="par_id240920171003293400" role="paragraph"><ahelp
hid="."><variable id="streams_desc">Create live data streams for
spreadsheets.</variable></ahelp></paragraph>
</section>
<section id="howtoget">
diff --git a/source/text/scalc/01/statistics.xhp
b/source/text/scalc/01/statistics.xhp
index 2293bd2019..eec8c2970e 100644
--- a/source/text/scalc/01/statistics.xhp
+++ b/source/text/scalc/01/statistics.xhp
@@ -20,18 +20,20 @@
<meta>
<topic id="statisticsmenu" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Data Statistics in Calc</title>
+<title id="tit">Data Statistics in Calc</title>
<filename>/text/scalc/01/statistics.xhp</filename>
</topic>
</meta>
<body>
-
+<bookmark branch="hid/.uno:StatisticsMenu" id="bm_id991704386719384"
localize="false"/>
<section id="analysistoolpack">
<h1 id="hd_id1000010"><link
href="text/scalc/01/statistics.xhp">Statistics</link></h1>
-<paragraph id="par_id1000010" role="paragraph" xml-lang="en-US">Use the data
statistics in Calc to perform complex data analysis</paragraph>
+<paragraph id="par_id1000010" role="paragraph">Use the data statistics in Calc
to perform complex data analysis</paragraph>
</section>
-
-<paragraph id="par_id1000020" role="paragraph" xml-lang="en-US">To work on a
complex statistical or engineering analysis, you can save steps and time by
using Calc Data Statistics. You provide the data and parameters for each
analysis, and the set of tools uses the appropriate statistical or engineering
functions to calculate and display the results in an output table.</paragraph>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000412.xhp#statistics"/>
+</section>
+<paragraph id="par_id1000020" role="paragraph">To work on a complex
statistical or engineering analysis, you can save steps and time by using Calc
Data Statistics. You provide the data and parameters for each analysis, and the
set of tools uses the appropriate statistical or engineering functions to
calculate and display the results in an output table.</paragraph>
<embed href="text/scalc/01/statistics_sampling.xhp#datasampling"/>
<embed href="text/scalc/01/statistics_descriptive.xhp#descriptivestatistics"/>
<embed href="text/scalc/01/statistics_anova.xhp#anova"/>
diff --git a/source/text/scalc/01/statistics_anova.xhp
b/source/text/scalc/01/statistics_anova.xhp
index 5bd8fcfee4..02369e8461 100644
--- a/source/text/scalc/01/statistics_anova.xhp
+++ b/source/text/scalc/01/statistics_anova.xhp
@@ -11,12 +11,12 @@
<meta>
<topic id="anovatopic" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">ANOVA</title>
+<title id="tit">ANOVA</title>
<filename>/text/scalc/01/statistics_anova.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id02001">
+<bookmark branch="index" id="bm_id02001">
<bookmark_value>Analysis toolpack;analysis of variance</bookmark_value>
<bookmark_value>Analysis toolpack;ANOVA</bookmark_value>
<bookmark_value>analysis of variance;Analysis toolpack</bookmark_value>
@@ -24,32 +24,34 @@
<bookmark_value>Data statistics;analysis of variance</bookmark_value>
<bookmark_value>Data statistics;ANOVA</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog"
id="bm_id02002" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/analysisofvariancedialog/@@nowidget@@"
id="bm_id02002" localize="false"/>
+<bookmark branch="hid/.uno:AnalysisOfVarianceDialog" id="bm_id91704458284640"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-AnalysisOfVarianceDialog"
id="bm_id631704460149385" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog"
id="bm_id02002" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/analysisofvariancedialog/@@nowidget@@"
id="bm_id03002" localize="false"/>
<section id="anova">
<h1 id="hd_id1000060"><variable id="anovah1"><link
href="text/scalc/01/statistics_anova.xhp">Analysis of Variance
(ANOVA)</link></variable></h1>
-<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog">Produces
the analysis of variance (ANOVA) of a given data set</ahelp></paragraph>
+<paragraph id="par_id1001240" role="paragraph"><ahelp
hid="modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog">Produces
the analysis of variance (ANOVA) of a given data set</ahelp></paragraph>
</section>
<section id="howtoget">
-<paragraph id="par_id1001250" role="paragraph" xml-lang="en-US"><variable
id="sam01">Choose <menuitem>Data - Statistics - Analysis of Variance
(ANOVA)</menuitem></variable></paragraph>
+ <embed href="text/scalc/00/00000412.xhp#stat_anova"/>
</section>
-<paragraph id="par_id1001260" role="paragraph" xml-lang="en-US">ANOVA is the
acronym for <emph>AN</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. This
tool produces the analysis of variance of a given data set</paragraph>
+<paragraph id="par_id1001260" role="paragraph">ANOVA is the acronym for
<emph>AN</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. This tool produces
the analysis of variance of a given data set</paragraph>
<note id="par_id1001270">For more information on ANOVA, refer to the <link
href="https://en.wikipedia.org/wiki/ANOVA";>corresponding Wikipedia
article</link>.</note>
<embed href="text/scalc/01/stat_data.xhp#data"/>
<embed href="text/scalc/01/stat_data.xhp#grouped"/>
<h2 id="hd_id1000070">Type</h2>
-<paragraph id="par_id1001280" role="paragraph" xml-lang="en-US">Select if the
analysis is for a <emph>single factor</emph> or for <emph>two factor</emph>
ANOVA.</paragraph>
+<paragraph id="par_id1001280" role="paragraph">Select if the analysis is for a
<emph>single factor</emph> or for <emph>two factor</emph> ANOVA.</paragraph>
<h2 id="hd_id1000080">Parameters</h2>
-<paragraph id="par_id1001290" role="paragraph"
xml-lang="en-US"><emph>Alpha</emph>: the level of significance of the
test.</paragraph>
-<paragraph id="par_id1001300" role="paragraph" xml-lang="en-US"><emph>Rows per
sample</emph>: Define how many rows a sample has.</paragraph>
+<paragraph id="par_id1001290" role="paragraph"><emph>Alpha</emph>: the level
of significance of the test.</paragraph>
+<paragraph id="par_id1001300" role="paragraph"><emph>Rows per sample</emph>:
Define how many rows a sample has.</paragraph>
<embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
-<paragraph id="par_id1001310" role="paragraph" xml-lang="en-US">The following
table displays the results of the <emph>analysis of variance (ANOVA)</emph> of
the sample data above.</paragraph>
+<paragraph id="par_id1001310" role="paragraph">The following table displays
the results of the <emph>analysis of variance (ANOVA)</emph> of the sample data
above.</paragraph>
<table id="Tabela5">
<tablerow>
<tablecell>
-<paragraph id="par_id1001320" role="tablehead" xml-lang="en-US">ANOVA - Single
Factor</paragraph>
+<paragraph id="par_id1001320" role="tablehead">ANOVA - Single
Factor</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -64,10 +66,10 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001330" role="tablecontent"
xml-lang="en-US">Alpha</paragraph>
+<paragraph id="par_id1001330" role="tablecontent">Alpha</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001340" role="tablecontent" xml-lang="en-US"
localize="false">0.05</paragraph>
+<paragraph id="par_id1001340" role="tablecontent"
localize="false">0.05</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -94,76 +96,76 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001350" role="tablecontent"
xml-lang="en-US">Groups</paragraph>
+<paragraph id="par_id1001350" role="tablecontent">Groups</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001360" role="tablecontent"
xml-lang="en-US">Count</paragraph>
+<paragraph id="par_id1001360" role="tablecontent">Count</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001370" role="tablecontent"
xml-lang="en-US">Sum</paragraph>
+<paragraph id="par_id1001370" role="tablecontent">Sum</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001380" role="tablecontent"
xml-lang="en-US">Mean</paragraph>
+<paragraph id="par_id1001380" role="tablecontent">Mean</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001390" role="tablecontent"
xml-lang="en-US">Variance</paragraph>
+<paragraph id="par_id1001390" role="tablecontent">Variance</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001400" role="tablecontent" xml-lang="en-US">Column
1</paragraph>
+<paragraph id="par_id1001400" role="tablecontent">Column 1</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001410" role="tablecontent" xml-lang="en-US"
localize="false">11</paragraph>
+<paragraph id="par_id1001410" role="tablecontent"
localize="false">11</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001420" role="tablecontent" xml-lang="en-US"
localize="false">461</paragraph>
+<paragraph id="par_id1001420" role="tablecontent"
localize="false">461</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001430" role="tablecontent" xml-lang="en-US"
localize="false">41.9090909091</paragraph>
+<paragraph id="par_id1001430" role="tablecontent"
localize="false">41.9090909091</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001440" role="tablecontent" xml-lang="en-US"
localize="false">139.4909090909</paragraph>
+<paragraph id="par_id1001440" role="tablecontent"
localize="false">139.4909090909</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001450" role="tablecontent" xml-lang="en-US">Column
2</paragraph>
+<paragraph id="par_id1001450" role="tablecontent">Column 2</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001460" role="tablecontent" xml-lang="en-US"
localize="false">10</paragraph>
+<paragraph id="par_id1001460" role="tablecontent"
localize="false">10</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001470" role="tablecontent" xml-lang="en-US"
localize="false">597</paragraph>
+<paragraph id="par_id1001470" role="tablecontent"
localize="false">597</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001480" role="tablecontent" xml-lang="en-US"
localize="false">59.7</paragraph>
+<paragraph id="par_id1001480" role="tablecontent"
localize="false">59.7</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001490" role="tablecontent" xml-lang="en-US"
localize="false">287.1222222222</paragraph>
+<paragraph id="par_id1001490" role="tablecontent"
localize="false">287.1222222222</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001500" role="tablecontent" xml-lang="en-US">Column
3</paragraph>
+<paragraph id="par_id1001500" role="tablecontent">Column 3</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001510" role="tablecontent" xml-lang="en-US"
localize="false">10</paragraph>
+<paragraph id="par_id1001510" role="tablecontent"
localize="false">10</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001520" role="tablecontent" xml-lang="en-US"
localize="false">447</paragraph>
+<paragraph id="par_id1001520" role="tablecontent"
localize="false">447</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001530" role="tablecontent" xml-lang="en-US"
localize="false">44.7</paragraph>
+<paragraph id="par_id1001530" role="tablecontent"
localize="false">44.7</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001540" role="tablecontent" xml-lang="en-US"
localize="false">227.3444444444</paragraph>
+<paragraph id="par_id1001540" role="tablecontent"
localize="false">227.3444444444</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -184,62 +186,62 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001550" role="tablecontent" xml-lang="en-US">Source of
Variation</paragraph>
+<paragraph id="par_id1001550" role="tablecontent">Source of
Variation</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001560" role="tablecontent"
xml-lang="en-US">SS</paragraph>
+<paragraph id="par_id1001560" role="tablecontent">SS</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001570" role="tablecontent"
xml-lang="en-US">df</paragraph>
+<paragraph id="par_id1001570" role="tablecontent">df</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001580" role="tablecontent"
xml-lang="en-US">MS</paragraph>
+<paragraph id="par_id1001580" role="tablecontent">MS</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001590" role="tablecontent"
xml-lang="en-US">F</paragraph>
+<paragraph id="par_id1001590" role="tablecontent">F</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001600" role="tablecontent"
xml-lang="en-US">P-value</paragraph>
+<paragraph id="par_id1001600" role="tablecontent">P-value</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id841554943563747" role="paragraph"
xml-lang="en-US">F-critical</paragraph>
+<paragraph id="par_id841554943563747" role="paragraph">F-critical</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001610" role="tablecontent" xml-lang="en-US">Between
Groups</paragraph>
+<paragraph id="par_id1001610" role="tablecontent">Between Groups</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001620" role="tablecontent" xml-lang="en-US"
localize="false">1876.5683284457</paragraph>
+<paragraph id="par_id1001620" role="tablecontent"
localize="false">1876.5683284457</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001630" role="tablecontent" xml-lang="en-US"
localize="false">2</paragraph>
+<paragraph id="par_id1001630" role="tablecontent"
localize="false">2</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001640" role="tablecontent" xml-lang="en-US"
localize="false">938.2841642229</paragraph>
+<paragraph id="par_id1001640" role="tablecontent"
localize="false">938.2841642229</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001650" role="tablecontent" xml-lang="en-US"
localize="false">4.3604117704</paragraph>
+<paragraph id="par_id1001650" role="tablecontent"
localize="false">4.3604117704</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001660" role="tablecontent" xml-lang="en-US"
localize="false">0.0224614952</paragraph>
+<paragraph id="par_id1001660" role="tablecontent"
localize="false">0.0224614952</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id411554944014360" role="paragraph" xml-lang="en-US"
localize="false">3.340385558</paragraph>
+<paragraph id="par_id411554944014360" role="paragraph"
localize="false">3.340385558</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001670" role="tablecontent" xml-lang="en-US">Within
Groups</paragraph>
+<paragraph id="par_id1001670" role="tablecontent">Within Groups</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001680" role="tablecontent" xml-lang="en-US"
localize="false">6025.1090909091</paragraph>
+<paragraph id="par_id1001680" role="tablecontent"
localize="false">6025.1090909091</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001690" role="tablecontent" xml-lang="en-US"
localize="false">28</paragraph>
+<paragraph id="par_id1001690" role="tablecontent"
localize="false">28</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001700" role="tablecontent" xml-lang="en-US"
localize="false">215.1824675325</paragraph>
+<paragraph id="par_id1001700" role="tablecontent"
localize="false">215.1824675325</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -248,13 +250,13 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001710" role="tablecontent"
xml-lang="en-US">Total</paragraph>
+<paragraph id="par_id1001710" role="tablecontent">Total</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001720" role="tablecontent" xml-lang="en-US"
localize="false">7901.6774193548</paragraph>
+<paragraph id="par_id1001720" role="tablecontent"
localize="false">7901.6774193548</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001730" role="tablecontent" xml-lang="en-US"
localize="false">30</paragraph>
+<paragraph id="par_id1001730" role="tablecontent"
localize="false">30</paragraph>
</tablecell>
<tablecell>
</tablecell>
diff --git a/source/text/scalc/01/statistics_correlation.xhp
b/source/text/scalc/01/statistics_correlation.xhp
index 7756df64f0..51824b9e84 100644
--- a/source/text/scalc/01/statistics_correlation.xhp
+++ b/source/text/scalc/01/statistics_correlation.xhp
@@ -11,55 +11,57 @@
<meta>
<topic id="ID" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Data Correlation in Calc</title>
+<title id="tit">Data Correlation in Calc</title>
<filename>/text/scalc/01/statistics_correlation.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id1464278">
+<bookmark branch="index" id="bm_id1464278">
<bookmark_value>Analysis toolpack;correlation</bookmark_value>
<bookmark_value>correlation;Analysis toolpack</bookmark_value>
<bookmark_value>Data statistics;correlation</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/correlationdialog/CorrelationDialog"
id="bm_id3145673" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/correlationdialog/@@nowidget@@" id="bm_id3145673"
localize="false"/>
+<bookmark branch="hid/.uno:CorrelationDialog" id="bm_id51704458389030"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-CorrelationDialog"
id="bm_id641704460191769" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/correlationdialog/CorrelationDialog"
id="bm_id3145673" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/correlationdialog/@@nowidget@@"
id="bm_id4145673" localize="false"/>
<section id="correlation">
<h1 id="hd_id1000090"><variable id="correlationh1"><link
href="text/scalc/01/statistics_correlation.xhp">Correlation</link></variable></h1>
-<paragraph id="par_id1001740" role="paragraph" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/correlationdialog/CorrelationDialog">Calculates the
correlation of two sets of numeric data.</ahelp></paragraph>
+<paragraph id="par_id1001740" role="paragraph"><ahelp
hid="modules/scalc/ui/correlationdialog/CorrelationDialog">Calculates the
correlation of two sets of numeric data.</ahelp></paragraph>
</section>
<section id="howtoget">
-<paragraph id="par_id1001750" role="paragraph" xml-lang="en-US"><variable
id="corr01">Choose <menuitem>Data - Statistics -
Correlation</menuitem></variable></paragraph>
+ <embed href="text/scalc/00/00000412.xhp#stat_correlation"/>
</section>
-<paragraph id="par_id1001760" role="paragraph" xml-lang="en-US">The
correlation coefficient (a value between -1 and +1) means how strongly two
variables are related to each other. You can use the CORREL function or the
Data Statistics to find the correlation coefficient between two
variables.</paragraph>
-<paragraph id="par_id1001770" role="paragraph" xml-lang="en-US">A correlation
coefficient of +1 indicates a perfect positive correlation. </paragraph>
-<paragraph id="par_id1001780" role="paragraph" xml-lang="en-US">A correlation
coefficient of -1 indicates a perfect negative correlation</paragraph>
+<paragraph id="par_id1001760" role="paragraph">The correlation coefficient (a
value between -1 and +1) means how strongly two variables are related to each
other. You can use the CORREL function or the Data Statistics to find the
correlation coefficient between two variables.</paragraph>
+<paragraph id="par_id1001770" role="paragraph">A correlation coefficient of +1
indicates a perfect positive correlation. </paragraph>
+<paragraph id="par_id1001780" role="paragraph">A correlation coefficient of -1
indicates a perfect negative correlation</paragraph>
<note id="par_id1001790">For more information on statistical correlation,
refer to the <link
href="https://en.wikipedia.org/wiki/Correlation";>corresponding Wikipedia
article</link>.</note>
<embed href="text/scalc/01/stat_data.xhp#data"/>
<embed href="text/scalc/01/stat_data.xhp#grouped"/>
<embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
-<paragraph id="par_id1001800" role="paragraph" xml-lang="en-US">The following
table displays the results of the correlation of the sample data
above.</paragraph>
+<paragraph id="par_id1001800" role="paragraph">The following table displays
the results of the correlation of the sample data above.</paragraph>
<table id="Tabela6">
<tablerow>
<tablecell>
-<paragraph id="par_id1001810" role="tablehead"
xml-lang="en-US">Correlations</paragraph>
+<paragraph id="par_id1001810" role="tablehead">Correlations</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001820" role="tablehead" xml-lang="en-US">Column
1</paragraph>
+<paragraph id="par_id1001820" role="tablehead">Column 1</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001830" role="tablehead" xml-lang="en-US">Column
2</paragraph>
+<paragraph id="par_id1001830" role="tablehead">Column 2</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001840" role="tablehead" xml-lang="en-US">Column
3</paragraph>
+<paragraph id="par_id1001840" role="tablehead">Column 3</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001850" role="tablehead" xml-lang="en-US">Column
1</paragraph>
+<paragraph id="par_id1001850" role="tablehead">Column 1</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001860" role="tablecontent" xml-lang="en-US"
localize="false">1</paragraph>
+<paragraph id="par_id1001860" role="tablecontent"
localize="false">1</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -68,29 +70,29 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001870" role="tablehead" xml-lang="en-US">Column
2</paragraph>
+<paragraph id="par_id1001870" role="tablehead">Column 2</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001880" role="tablecontent" xml-lang="en-US"
localize="false">-0.4029254917</paragraph>
+<paragraph id="par_id1001880" role="tablecontent"
localize="false">-0.4029254917</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001890" role="tablecontent" xml-lang="en-US"
localize="false">1</paragraph>
+<paragraph id="par_id1001890" role="tablecontent"
localize="false">1</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001900" role="tablehead" xml-lang="en-US">Column
3</paragraph>
+<paragraph id="par_id1001900" role="tablehead">Column 3</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001910" role="tablecontent" xml-lang="en-US"
localize="false">-0.2107642836</paragraph>
+<paragraph id="par_id1001910" role="tablecontent"
localize="false">-0.2107642836</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001920" role="tablecontent" xml-lang="en-US"
localize="false">0.2309714048</paragraph>
+<paragraph id="par_id1001920" role="tablecontent"
localize="false">0.2309714048</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001930" role="tablecontent" xml-lang="en-US"
localize="false">1</paragraph>
+<paragraph id="par_id1001930" role="tablecontent"
localize="false">1</paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/source/text/scalc/01/statistics_covariance.xhp
b/source/text/scalc/01/statistics_covariance.xhp
index bfc2f9556b..965c5ae345 100644
--- a/source/text/scalc/01/statistics_covariance.xhp
+++ b/source/text/scalc/01/statistics_covariance.xhp
@@ -11,51 +11,53 @@
<meta>
<topic id="ID" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Data Covariance in Calc</title>
+<title id="tit">Data Covariance in Calc</title>
<filename>/text/scalc/01/statistics_covariance.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id2964278">
+<bookmark branch="index" id="bm_id2964278">
<bookmark_value>Analysis toolpack;covariance</bookmark_value>
<bookmark_value>covariance;Analysis toolpack</bookmark_value>
<bookmark_value>Data statistics;covariance</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/covariancedialog/CovarianceDialog"
id="bm_id2945673" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/covariancedialog/@@nowidget@@" id="bm_id2945673"
localize="false"/>
+<bookmark branch="hid/.uno:CovarianceDialog" id="bm_id171704458503346"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-CovarianceDialog"
id="bm_id341704460231231" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/covariancedialog/CovarianceDialog"
id="bm_id2945673" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/covariancedialog/@@nowidget@@"
id="bm_id2965673" localize="false"/>
<section id="covariance">
<h1 id="hd_id1000100"><variable id="covarianceh1"><link
href="text/scalc/01/statistics_covariance.xhp">Covariance</link></variable></h1>
-<paragraph id="par_id1001940" role="paragraph" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the
covariance of two sets of numeric data.</ahelp></paragraph>
+ <paragraph id="par_id1001940" role="paragraph"><ahelp
hid="modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the
covariance of two sets of numeric data.</ahelp></paragraph>
</section>
<section id="howtoget">
-<paragraph id="par_id1001950" role="paragraph" xml-lang="en-US"><variable
id="cov01">Choose <menuitem>Data - Statistics -
Covariance</menuitem></variable></paragraph>
+ <embed href="text/scalc/00/00000412.xhp#stat_covariance"/>
</section>
-<paragraph id="par_id1001960" role="paragraph" xml-lang="en-US">The covariance
is a measure of how much two random variables change together.</paragraph>
+<paragraph id="par_id1001960" role="paragraph">The covariance is a measure of
how much two random variables change together.</paragraph>
<note id="par_id1001970">For more information on statistical covariance, refer
to the <link href="https://en.wikipedia.org/wiki/Covariance";>corresponding
Wikipedia article</link>.</note>
<embed href="text/scalc/01/stat_data.xhp#data"/>
<embed href="text/scalc/01/stat_data.xhp#grouped"/><embed
href="text/scalc/01/stat_data.xhp#sampledata01"/>
-<paragraph id="par_id1001980" role="paragraph" xml-lang="en-US">The following
table displays the results of the covariance of the sample data
above.</paragraph>
+<paragraph id="par_id1001980" role="paragraph">The following table displays
the results of the covariance of the sample data above.</paragraph>
<table id="Tabela7">
<tablerow>
<tablecell>
-<paragraph id="par_id1001990" role="tablehead"
xml-lang="en-US">Covariances</paragraph>
+<paragraph id="par_id1001990" role="tablehead">Covariances</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002000" role="tablehead" xml-lang="en-US">Column
1</paragraph>
+<paragraph id="par_id1002000" role="tablehead">Column 1</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002010" role="tablehead" xml-lang="en-US">Column
2</paragraph>
+<paragraph id="par_id1002010" role="tablehead">Column 2</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002020" role="tablehead" xml-lang="en-US">Column
3</paragraph>
+<paragraph id="par_id1002020" role="tablehead">Column 3</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002030" role="tablehead" xml-lang="en-US">Column
1</paragraph>
+<paragraph id="par_id1002030" role="tablehead">Column 1</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002040" role="tablecontent" xml-lang="en-US"
localize="false">126.8099173554</paragraph>
+<paragraph id="par_id1002040" role="tablecontent"
localize="false">126.8099173554</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -64,29 +66,29 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002050" role="tablehead" xml-lang="en-US">Column
2</paragraph>
+<paragraph id="par_id1002050" role="tablehead">Column 2</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002060" role="tablecontent" xml-lang="en-US"
localize="false">-61.4444444444</paragraph>
+<paragraph id="par_id1002060" role="tablecontent"
localize="false">-61.4444444444</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002070" role="tablecontent" xml-lang="en-US"
localize="false">258.41</paragraph>
+<paragraph id="par_id1002070" role="tablecontent"
localize="false">258.41</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002080" role="tablehead" xml-lang="en-US">Column
3</paragraph>
+<paragraph id="par_id1002080" role="tablehead">Column 3</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002090" role="tablecontent" xml-lang="en-US"
localize="false">-32</paragraph>
+<paragraph id="par_id1002090" role="tablecontent"
localize="false">-32</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002100" role="tablecontent" xml-lang="en-US"
localize="false">53.11</paragraph>
+<paragraph id="par_id1002100" role="tablecontent"
localize="false">53.11</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002110" role="tablecontent" xml-lang="en-US"
localize="false">204.61</paragraph>
+<paragraph id="par_id1002110" role="tablecontent"
localize="false">204.61</paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/source/text/scalc/01/statistics_descriptive.xhp
b/source/text/scalc/01/statistics_descriptive.xhp
index cf7a3d59e2..13476c7188 100644
--- a/source/text/scalc/01/statistics_descriptive.xhp
+++ b/source/text/scalc/01/statistics_descriptive.xhp
@@ -10,226 +10,228 @@
<meta>
<topic id="ID" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Descriptive Statistics in Calc</title>
+<title id="tit">Descriptive Statistics in Calc</title>
<filename>/text/scalc/01/statistics_descriptive.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id01001">
+<bookmark branch="index" id="bm_id01001">
<bookmark_value>Analysis toolpack;descriptive statistics</bookmark_value>
<bookmark_value>descriptive statistics;Analysis toolpack</bookmark_value>
<bookmark_value>Data statistics;descriptive statistics</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog"
id="bm_id01002" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/descriptivestatisticsdialog/@@nowidget@@"
id="bm_id01002" localize="false"/>
+<bookmark branch="hid/.uno:DescriptiveStatisticsDialog"
id="bm_id1001704458184056" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-DescriptiveStatisticsDialog"
id="bm_id661704460105179" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog"
id="bm_id01002" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/descriptivestatisticsdialog/@@nowidget@@"
id="bm_id07002" localize="false"/>
<section id="descriptivestatistics">
<h1 id="hd_id1000050"><variable id="descriptivestatisticsh1"><link
href="text/scalc/01/statistics_descriptive.xhp">Descriptive
Statistics</link></variable></h1>
-<paragraph id="par_id1000640" role="paragraph" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog">Fill
a table in the spreadsheet with the main statistical properties of the data
set.</ahelp></paragraph>
+ <paragraph id="par_id1000640" role="paragraph"><ahelp
hid="modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog">Fill
a table in the spreadsheet with the main statistical properties of the data
set.</ahelp></paragraph>
</section>
<section id="howtoget">
-<paragraph id="par_id1000650" role="paragraph" xml-lang="en-US"><variable
id="sam01">Choose <menuitem>Data - Statistics - Descriptive
Statistics</menuitem></variable></paragraph>
+ <embed href="text/scalc/00/00000412.xhp#stat_descriptive"/>
</section>
-<paragraph id="par_id1000660" role="paragraph" xml-lang="en-US">The
Descriptive Statistics analysis tool generates a report of univariate
statistics for data in the input range, providing information about the central
tendency and variability of your data.</paragraph>
+<paragraph id="par_id1000660" role="paragraph">The Descriptive Statistics
analysis tool generates a report of univariate statistics for data in the input
range, providing information about the central tendency and variability of your
data.</paragraph>
<note id="par_id1000670">For more information on descriptive statistics, refer
to the <link
href="https://en.wikipedia.org/wiki/Descriptive_statistics";>corresponding
Wikipedia article</link>.</note>
<embed href="text/scalc/01/stat_data.xhp#data"/>
<embed href="text/scalc/01/stat_data.xhp#grouped"/>
<embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
-<paragraph id="par_id1000680" role="paragraph" xml-lang="en-US">The following
table displays the results of the descriptive statistics of the sample data
above.</paragraph>
+<paragraph id="par_id1000680" role="paragraph">The following table displays
the results of the descriptive statistics of the sample data above.</paragraph>
<table id="Tabela4">
<tablerow>
<tablecell>
</tablecell>
<tablecell>
-<paragraph id="par_id1000690" role="tablehead"
xml-lang="en-US">Maths</paragraph>
+<paragraph id="par_id1000690" role="tablehead">Maths</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000700" role="tablehead"
xml-lang="en-US">Physics</paragraph>
+<paragraph id="par_id1000700" role="tablehead">Physics</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000710" role="tablehead"
xml-lang="en-US">Biology</paragraph>
+<paragraph id="par_id1000710" role="tablehead">Biology</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000720" role="tablehead"
xml-lang="en-US">Mean</paragraph>
+<paragraph id="par_id1000720" role="tablehead">Mean</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000730" role="tablecontent" xml-lang="en-US"
localize="false">41.9090909091</paragraph>
+<paragraph id="par_id1000730" role="tablecontent"
localize="false">41.9090909091</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000740" role="tablecontent" xml-lang="en-US"
localize="false">59.7</paragraph>
+<paragraph id="par_id1000740" role="tablecontent"
localize="false">59.7</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000750" role="tablecontent" xml-lang="en-US"
localize="false">44.7</paragraph>
+<paragraph id="par_id1000750" role="tablecontent"
localize="false">44.7</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000760" role="tablehead" xml-lang="en-US">Standard
Error</paragraph>
+<paragraph id="par_id1000760" role="tablehead">Standard Error</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000770" role="tablecontent" xml-lang="en-US"
localize="false">3.5610380138</paragraph>
+<paragraph id="par_id1000770" role="tablecontent"
localize="false">3.5610380138</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000780" role="tablecontent" xml-lang="en-US"
localize="false">5.3583786934</paragraph>
+<paragraph id="par_id1000780" role="tablecontent"
localize="false">5.3583786934</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000790" role="tablecontent" xml-lang="en-US"
localize="false">4.7680650629</paragraph>
+<paragraph id="par_id1000790" role="tablecontent"
localize="false">4.7680650629</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000800" role="tablehead"
xml-lang="en-US">Mode</paragraph>
+<paragraph id="par_id1000800" role="tablehead">Mode</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000810" role="tablecontent" xml-lang="en-US"
localize="false">47</paragraph>
+<paragraph id="par_id1000810" role="tablecontent"
localize="false">47</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000820" role="tablecontent" xml-lang="en-US"
localize="false">49</paragraph>
+<paragraph id="par_id1000820" role="tablecontent"
localize="false">49</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000830" role="tablecontent" xml-lang="en-US"
localize="false">60</paragraph>
+<paragraph id="par_id1000830" role="tablecontent"
localize="false">60</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000840" role="tablehead"
xml-lang="en-US">Median</paragraph>
+<paragraph id="par_id1000840" role="tablehead">Median</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000850" role="tablecontent" xml-lang="en-US"
localize="false">40</paragraph>
+<paragraph id="par_id1000850" role="tablecontent"
localize="false">40</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000860" role="tablecontent" xml-lang="en-US"
localize="false">64.5</paragraph>
+<paragraph id="par_id1000860" role="tablecontent"
localize="false">64.5</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000870" role="tablecontent" xml-lang="en-US"
localize="false">43.5</paragraph>
+<paragraph id="par_id1000870" role="tablecontent"
localize="false">43.5</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000880" role="tablehead"
xml-lang="en-US">Variance</paragraph>
+<paragraph id="par_id1000880" role="tablehead">Variance</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000890" role="tablecontent" xml-lang="en-US"
localize="false">139.4909090909</paragraph>
+<paragraph id="par_id1000890" role="tablecontent"
localize="false">139.4909090909</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000900" role="tablecontent" xml-lang="en-US"
localize="false">287.1222222222</paragraph>
+<paragraph id="par_id1000900" role="tablecontent"
localize="false">287.1222222222</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000910" role="tablecontent" xml-lang="en-US"
localize="false">227.3444444444</paragraph>
+<paragraph id="par_id1000910" role="tablecontent"
localize="false">227.3444444444</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000920" role="tablehead" xml-lang="en-US">Standard
Deviation</paragraph>
+<paragraph id="par_id1000920" role="tablehead">Standard Deviation</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000930" role="tablecontent" xml-lang="en-US"
localize="false">11.8106269559</paragraph>
+<paragraph id="par_id1000930" role="tablecontent"
localize="false">11.8106269559</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000940" role="tablecontent" xml-lang="en-US"
localize="false">16.944681237</paragraph>
+<paragraph id="par_id1000940" role="tablecontent"
localize="false">16.944681237</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000950" role="tablecontent" xml-lang="en-US"
localize="false">15.0779456308</paragraph>
+<paragraph id="par_id1000950" role="tablecontent"
localize="false">15.0779456308</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000960" role="tablehead"
xml-lang="en-US">Kurtosis</paragraph>
+<paragraph id="par_id1000960" role="tablehead">Kurtosis</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000970" role="tablecontent" xml-lang="en-US"
localize="false">-1.4621677981</paragraph>
+<paragraph id="par_id1000970" role="tablecontent"
localize="false">-1.4621677981</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000980" role="tablecontent" xml-lang="en-US"
localize="false">-0.9415988746</paragraph>
+<paragraph id="par_id1000980" role="tablecontent"
localize="false">-0.9415988746</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000990" role="tablecontent" xml-lang="en-US"
localize="false">1.418052719</paragraph>
+<paragraph id="par_id1000990" role="tablecontent"
localize="false">1.418052719</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001000" role="tablehead"
xml-lang="en-US">Skewness</paragraph>
+<paragraph id="par_id1001000" role="tablehead">Skewness</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001010" role="tablecontent" xml-lang="en-US"
localize="false">0.0152409533</paragraph>
+<paragraph id="par_id1001010" role="tablecontent"
localize="false">0.0152409533</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001020" role="tablecontent" xml-lang="en-US"
localize="false">-0.2226426904</paragraph>
+<paragraph id="par_id1001020" role="tablecontent"
localize="false">-0.2226426904</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001030" role="tablecontent" xml-lang="en-US"
localize="false">-0.9766803373</paragraph>
+<paragraph id="par_id1001030" role="tablecontent"
localize="false">-0.9766803373</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001040" role="tablehead"
xml-lang="en-US">Range</paragraph>
+<paragraph id="par_id1001040" role="tablehead">Range</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001050" role="tablecontent" xml-lang="en-US"
localize="false">31</paragraph>
+<paragraph id="par_id1001050" role="tablecontent"
localize="false">31</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001060" role="tablecontent" xml-lang="en-US"
localize="false">51</paragraph>
+<paragraph id="par_id1001060" role="tablecontent"
localize="false">51</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001070" role="tablecontent" xml-lang="en-US"
localize="false">50</paragraph>
+<paragraph id="par_id1001070" role="tablecontent"
localize="false">50</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001080" role="tablehead"
xml-lang="en-US">Minimum</paragraph>
+<paragraph id="par_id1001080" role="tablehead">Minimum</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001090" role="tablecontent" xml-lang="en-US"
localize="false">26</paragraph>
+<paragraph id="par_id1001090" role="tablecontent"
localize="false">26</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001100" role="tablecontent" xml-lang="en-US"
localize="false">33</paragraph>
+<paragraph id="par_id1001100" role="tablecontent"
localize="false">33</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001110" role="tablecontent" xml-lang="en-US"
localize="false">12</paragraph>
+<paragraph id="par_id1001110" role="tablecontent"
localize="false">12</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001120" role="tablehead"
xml-lang="en-US">Maximum</paragraph>
+<paragraph id="par_id1001120" role="tablehead">Maximum</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001130" role="tablecontent" xml-lang="en-US"
localize="false">57</paragraph>
+<paragraph id="par_id1001130" role="tablecontent"
localize="false">57</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001140" role="tablecontent" xml-lang="en-US"
localize="false">84</paragraph>
+<paragraph id="par_id1001140" role="tablecontent"
localize="false">84</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001150" role="tablecontent" xml-lang="en-US"
localize="false">62</paragraph>
+<paragraph id="par_id1001150" role="tablecontent"
localize="false">62</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001160" role="tablehead" xml-lang="en-US">Sum</paragraph>
+<paragraph id="par_id1001160" role="tablehead">Sum</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001170" role="tablecontent" xml-lang="en-US"
localize="false">461</paragraph>
+<paragraph id="par_id1001170" role="tablecontent"
localize="false">461</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001180" role="tablecontent" xml-lang="en-US"
localize="false">597</paragraph>
+<paragraph id="par_id1001180" role="tablecontent"
localize="false">597</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001190" role="tablecontent" xml-lang="en-US"
localize="false">447</paragraph>
+<paragraph id="par_id1001190" role="tablecontent"
localize="false">447</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1001200" role="tablehead"
xml-lang="en-US">Count</paragraph>
+<paragraph id="par_id1001200" role="tablehead">Count</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001210" role="tablecontent" xml-lang="en-US"
localize="false">11</paragraph>
+<paragraph id="par_id1001210" role="tablecontent"
localize="false">11</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001220" role="tablecontent" xml-lang="en-US"
localize="false">10</paragraph>
+<paragraph id="par_id1001220" role="tablecontent"
localize="false">10</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1001230" role="tablecontent" xml-lang="en-US"
localize="false">10</paragraph>
+<paragraph id="par_id1001230" role="tablecontent"
localize="false">10</paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/source/text/scalc/01/statistics_exposmooth.xhp
b/source/text/scalc/01/statistics_exposmooth.xhp
index 47a8be6d57..6815000193 100644
--- a/source/text/scalc/01/statistics_exposmooth.xhp
+++ b/source/text/scalc/01/statistics_exposmooth.xhp
@@ -10,163 +10,165 @@
<meta>
<topic id="exponentialsmooth" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Exponential Smoothing in Calc</title>
+<title id="tit">Exponential Smoothing in Calc</title>
<filename>/text/scalc/01/statistics_exposmooth.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id03001">
+<bookmark branch="index" id="bm_id03001">
<bookmark_value>Analysis toolpack;exponential smoothing</bookmark_value>
<bookmark_value>exponential smoothing;Analysis toolpack</bookmark_value>
<bookmark_value>Data statistics;exponential smoothing</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog"
id="bm_id03002" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/exponentialsmoothingdialog/@@nowidget@@"
id="bm_id03002" localize="false"/>
+<bookmark branch="hid/.uno:ExponentialSmoothingDialog"
id="bm_id351704458542363" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-ExponentialSmoothingDialog"
id="bm_id221704460261421" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog"
id="bm_id03002" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/exponentialsmoothingdialog/@@nowidget@@"
id="bm_id03003" localize="false"/>
<section id="exponentialsmoothing">
<h1 id="hd_id1000110"><variable id="exponentialsmoothingh1"><link
href="text/scalc/01/statistics_exposmooth.xhp">Exponential
Smoothing</link></variable></h1>
-<paragraph id="par_id1002120" role="paragraph" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">Results
in a smoothed data series</ahelp></paragraph>
+ <paragraph id="par_id1002120" role="paragraph"><ahelp
hid="modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">Results
in a smoothed data series</ahelp></paragraph>
</section>
<section id="howtoget">
-<paragraph id="par_id1002130" role="paragraph" xml-lang="en-US"><variable
id="sam01">Choose <menuitem>Data - Statistics - Exponential
Smoothing</menuitem></variable></paragraph>
+ <embed href="text/scalc/00/00000412.xhp#stat_expon"/>
</section>
-<paragraph id="par_id1002140" role="paragraph" xml-lang="en-US">Exponential
smoothing is a filtering technique that when applied to a data set, produces
smoothed results. It is employed in many domains such as stock market,
economics and in sampled measurements.</paragraph>
+<paragraph id="par_id1002140" role="paragraph">Exponential smoothing is a
filtering technique that when applied to a data set, produces smoothed results.
It is employed in many domains such as stock market, economics and in sampled
measurements.</paragraph>
<note id="par_id1002150">For more information on exponential smoothing, refer
to the <link
href="https://en.wikipedia.org/wiki/Exponential_smoothing";>corresponding
Wikipedia article</link>.</note><embed
href="text/scalc/01/stat_data.xhp#data"/><embed
href="text/scalc/01/stat_data.xhp#grouped"/>
<h2 id="hd_id1000120">Parameters</h2>
-<paragraph id="par_id1002160" role="paragraph"
xml-lang="en-US"><emph>Smoothing Factor</emph>: A parameter between 0 and 1
that represents the damping factor Alpha in the smoothing
equation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
-<paragraph id="par_id1002170" role="paragraph" xml-lang="en-US">The resulting
smoothing is below with smoothing factor as 0.5:</paragraph>
+<paragraph id="par_id1002160" role="paragraph"><emph>Smoothing Factor</emph>:
A parameter between 0 and 1 that represents the damping factor Alpha in the
smoothing equation.</paragraph><embed
href="text/scalc/01/stat_data.xhp#timeseries01"/>
+<paragraph id="par_id1002170" role="paragraph">The resulting smoothing is
below with smoothing factor as 0.5:</paragraph>
<table id="Tabela9">
<tablerow>
<tablecell>
-<paragraph id="par_id1002180" role="tablehead"
xml-lang="en-US">Alpha</paragraph>
+<paragraph id="par_id1002180" role="tablehead">Alpha</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002190" role="tablecontent" xml-lang="en-US"
localize="false">0.5</paragraph>
+<paragraph id="par_id1002190" role="tablecontent"
localize="false">0.5</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002200" role="tablehead" xml-lang="en-US">Column
1</paragraph>
+<paragraph id="par_id1002200" role="tablehead">Column 1</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002210" role="tablehead" xml-lang="en-US">Column
2</paragraph>
+<paragraph id="par_id1002210" role="tablehead">Column 2</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002220" role="tablecontent" xml-lang="en-US"
localize="false">1</paragraph>
+<paragraph id="par_id1002220" role="tablecontent"
localize="false">1</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002230" role="tablecontent" xml-lang="en-US"
localize="false">0</paragraph>
+<paragraph id="par_id1002230" role="tablecontent"
localize="false">0</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002240" role="tablecontent" xml-lang="en-US"
localize="false">1</paragraph>
+<paragraph id="par_id1002240" role="tablecontent"
localize="false">1</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002250" role="tablecontent" xml-lang="en-US"
localize="false">0</paragraph>
+<paragraph id="par_id1002250" role="tablecontent"
localize="false">0</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002260" role="tablecontent" xml-lang="en-US"
localize="false">0.5</paragraph>
+<paragraph id="par_id1002260" role="tablecontent"
localize="false">0.5</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002270" role="tablecontent" xml-lang="en-US"
localize="false">0</paragraph>
+<paragraph id="par_id1002270" role="tablecontent"
localize="false">0</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002280" role="tablecontent" xml-lang="en-US"
localize="false">0.25</paragraph>
+<paragraph id="par_id1002280" role="tablecontent"
localize="false">0.25</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002290" role="tablecontent" xml-lang="en-US"
localize="false">0.5</paragraph>
+<paragraph id="par_id1002290" role="tablecontent"
localize="false">0.5</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002300" role="tablecontent" xml-lang="en-US"
localize="false">0.125</paragraph>
+<paragraph id="par_id1002300" role="tablecontent"
localize="false">0.125</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002310" role="tablecontent" xml-lang="en-US"
localize="false">0.25</paragraph>
+<paragraph id="par_id1002310" role="tablecontent"
localize="false">0.25</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002320" role="tablecontent" xml-lang="en-US"
localize="false">0.0625</paragraph>
+<paragraph id="par_id1002320" role="tablecontent"
localize="false">0.0625</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002330" role="tablecontent" xml-lang="en-US"
localize="false">0.125</paragraph>
+<paragraph id="par_id1002330" role="tablecontent"
localize="false">0.125</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002340" role="tablecontent" xml-lang="en-US"
localize="false">0.03125</paragraph>
+<paragraph id="par_id1002340" role="tablecontent"
localize="false">0.03125</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002350" role="tablecontent" xml-lang="en-US"
localize="false">0.0625</paragraph>
+<paragraph id="par_id1002350" role="tablecontent"
localize="false">0.0625</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002360" role="tablecontent" xml-lang="en-US"
localize="false">0.015625</paragraph>
+<paragraph id="par_id1002360" role="tablecontent"
localize="false">0.015625</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002370" role="tablecontent" xml-lang="en-US"
localize="false">0.03125</paragraph>
+<paragraph id="par_id1002370" role="tablecontent"
localize="false">0.03125</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002380" role="tablecontent" xml-lang="en-US"
localize="false">0.0078125</paragraph>
+<paragraph id="par_id1002380" role="tablecontent"
localize="false">0.0078125</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002390" role="tablecontent" xml-lang="en-US"
localize="false">0.015625</paragraph>
+<paragraph id="par_id1002390" role="tablecontent"
localize="false">0.015625</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002400" role="tablecontent" xml-lang="en-US"
localize="false">0.00390625</paragraph>
+<paragraph id="par_id1002400" role="tablecontent"
localize="false">0.00390625</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002410" role="tablecontent" xml-lang="en-US"
localize="false">0.0078125</paragraph>
+<paragraph id="par_id1002410" role="tablecontent"
localize="false">0.0078125</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002420" role="tablecontent" xml-lang="en-US"
localize="false">0.001953125</paragraph>
+<paragraph id="par_id1002420" role="tablecontent"
localize="false">0.001953125</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002430" role="tablecontent" xml-lang="en-US"
localize="false">0.00390625</paragraph>
+<paragraph id="par_id1002430" role="tablecontent"
localize="false">0.00390625</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002440" role="tablecontent" xml-lang="en-US"
localize="false">0.0009765625</paragraph>
+<paragraph id="par_id1002440" role="tablecontent"
localize="false">0.0009765625</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002450" role="tablecontent" xml-lang="en-US"
localize="false">0.001953125</paragraph>
+<paragraph id="par_id1002450" role="tablecontent"
localize="false">0.001953125</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002460" role="tablecontent" xml-lang="en-US"
localize="false">0.0004882813</paragraph>
+<paragraph id="par_id1002460" role="tablecontent"
localize="false">0.0004882813</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002470" role="tablecontent" xml-lang="en-US"
localize="false">0.0009765625</paragraph>
+<paragraph id="par_id1002470" role="tablecontent"
localize="false">0.0009765625</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1002480" role="tablecontent" xml-lang="en-US"
localize="false">0.0002441406</paragraph>
+<paragraph id="par_id1002480" role="tablecontent"
localize="false">0.0002441406</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1002490" role="tablecontent" xml-lang="en-US"
localize="false">0.0004882813</paragraph>
+<paragraph id="par_id1002490" role="tablecontent"
localize="false">0.0004882813</paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/source/text/scalc/01/statistics_fourier.xhp
b/source/text/scalc/01/statistics_fourier.xhp
index f17adba38a..7a8046d48f 100644
--- a/source/text/scalc/01/statistics_fourier.xhp
+++ b/source/text/scalc/01/statistics_fourier.xhp
@@ -11,26 +11,28 @@
<meta>
<topic id="ID" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Fourier Analysis</title>
+ <title id="tit">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"/>
- <bookmark xml-lang="en-US" branch="index" id="bm_id2764278">
+<body>
+<bookmark branch="hid/.uno:FourierAnalysisDialog" id="bm_id991704458938583"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-FourierAnalysisDialog"
id="bm_id261704459639233" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/fourieranalysisdialog/FourierAnalysisDialog"
id="bm_id2345673" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/regressiondialog/@@nowidget@@"
id="bm_id2745773" localize="false"/>
+<bookmark 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>
+</bookmark>
- <section id="fourieranalysis">
+<section id="fourieranalysis">
<h1 id="hd_id431561808831965"><variable id="fourieranalysysh1"><link
href="text/scalc/01/statistics_fourier.xhp">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>
+ <paragraph id="par_id1001240" role="paragraph"><ahelp
hid="modules/scalc/ui/regressiondialog/RegressionDialog">Produces the Fourier
analysis of a data set by computing the Discrete Fourier Transform (DFT) of an
input array of complex numbers using a couple of Fast Fourier Transform (FFT)
algorithms.</ahelp></paragraph>
</section>
<section id="howtoget">
- <paragraph id="par_id1000040" role="paragraph"
xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics -
Fourier Analysis</menuitem></variable></paragraph>
+ <embed href="text/scalc/00/00000412.xhp#stat_fourier"/>
</section>
<note id="par_id1001270">For more information on Fourier analysis,
refer to the <link
href="https://en.wikipedia.org/wiki/Fourier_analysis";>corresponding Wikipedia
article</link>.</note>
diff --git a/source/text/scalc/01/statistics_movingavg.xhp
b/source/text/scalc/01/statistics_movingavg.xhp
index 76f9ee6eef..81abee2409 100644
--- a/source/text/scalc/01/statistics_movingavg.xhp
+++ b/source/text/scalc/01/statistics_movingavg.xhp
@@ -21,14 +21,16 @@
<bookmark_value>moving average;Analysis toolpack</bookmark_value>
<bookmark_value>Data statistics;moving average</bookmark_value>
</bookmark>
-<bookmark
branch="hid/modules/scalc/ui/movingaveragedialog/MovingAverageDialog"
id="bm_id04002" localize="false"/>
+<bookmark branch="hid/.uno:MovingAverageDialog" id="bm_id31704458606219"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-MovingAverageDialog"
id="bm_id111704460323596" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/movingaveragedialog/MovingAverageDialog"
id="bm_id04003" localize="false"/>
<bookmark branch="hid/modules/scalc/ui/movingaveragedialog/@@nowidget@@"
id="bm_id04002" localize="false"/>
<section id="movingaverage">
<h1 id="hd_id1000130"><variable id="movingaverageh1"><link
href="text/scalc/01/statistics_movingavg.xhp">Moving
Average</link></variable></h1>
<paragraph id="par_id1002500" role="paragraph"><ahelp
hid="modules/scalc/ui/movingaveragedialog/MovingAverageDialog">Calculates the
moving average of a time series</ahelp></paragraph>
</section>
<section id="howtoget">
-<paragraph id="par_id1002510" role="paragraph"><variable id="sam01">Choose
<menuitem>Data - Statistics - Moving Average</menuitem></variable></paragraph>
+ <embed href="text/scalc/00/00000412.xhp#stat_movingavg"/>
</section>
<note id="par_id1002520">For more information on the moving average, refer to
the <link href="https://en.wikipedia.org/wiki/Moving_average";>corresponding
Wikipedia article</link>.</note>
<embed href="text/scalc/01/stat_data.xhp#data"/>
diff --git a/source/text/scalc/01/statistics_regression.xhp
b/source/text/scalc/01/statistics_regression.xhp
index d647297346..fae1230806 100644
--- a/source/text/scalc/01/statistics_regression.xhp
+++ b/source/text/scalc/01/statistics_regression.xhp
@@ -20,12 +20,12 @@
<meta>
<topic id="regressiontopic" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Regression Analysis</title>
+ <title id="tit">Regression Analysis</title>
<filename>/text/scalc/01/statistics_regression.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id2764278">
+<bookmark 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>
@@ -34,18 +34,19 @@
<bookmark_value>regression analysis;power</bookmark_value>
<bookmark_value>regression analysis;logarithmic</bookmark_value>
</bookmark>
-
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/regressiondialog/RegressionDialog"
id="bm_id2745673" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/regressiondialog/@@nowidget@@" id="bm_id2745673"
localize="false"/>
+<bookmark branch="hid/.uno:RegressionDialog" id="bm_id341704458664640"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-RegressionDialog"
id="bm_id651704459290345" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/regressiondialog/RegressionDialog"
id="bm_id2745673" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/regressiondialog/@@nowidget@@"
id="bm_id2755673" localize="false"/>
<section id="regression">
<h1 id="hd_id1701201615033510"><variable id="regressionanalysish1"><link
href="text/scalc/01/statistics_regression.xhp">Regression
Analysis</link></variable></h1>
-<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/regressiondialog/RegressionDialog">Performs linear,
logarithmic, or power regression analysis of a data set comprising one
dependent variable and multiple independent variables.</ahelp></paragraph>
+<paragraph id="par_id1001240" role="paragraph"><ahelp
hid="modules/scalc/ui/regressiondialog/RegressionDialog">Performs linear,
logarithmic, or power regression analysis of a data set comprising one
dependent variable and multiple independent variables.</ahelp></paragraph>
</section>
<paragraph role="paragraph" id="par_id431629832333206">For example, a crop
yield (dependent variable) may be related to rainfall, temperature conditions,
sunshine, humidity, soil quality and more, all of them independent
variables.</paragraph>
<section id="howtoget">
-<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable
id="sam01">Choose <menuitem>Data - Statistics -
Regression</menuitem></variable></paragraph>
+ <embed href="text/scalc/00/00000412.xhp#stat_regression"/>
</section>
-<paragraph id="par_id1001270" role="note" xml-lang="en-US">For more
information on regression analysis, refer to the <link
href="https://en.wikipedia.org/wiki/Regression_analysis";>corresponding
Wikipedia article</link>.</paragraph>
+<note id="par_id1001270">For more information on regression analysis, refer to
the <link
href="https://en.wikipedia.org/wiki/Regression_analysis";>corresponding
Wikipedia article</link>.</note>
<h2 id="hd_id891629830986496">Data</h2>
<h3 id="hd_id101629830993962">Independent variable(s) (X) range:</h3>
<paragraph role="paragraph" id="par_id961629834099308">Enter a single range
that contains multiple independent variable observations (along columns or
rows). All X variable observations need to be entered adjacent to each other in
the same table.</paragraph>
@@ -58,17 +59,17 @@
<embed href="text/scalc/01/stat_data.xhp#grouped"/>
<h2 id="hd_id1000070">Output Regression Types</h2>
-<paragraph id="par_id1001280" role="paragraph" xml-lang="en-US">Set the
regression type. Three types are available: </paragraph>
+<paragraph id="par_id1001280" role="paragraph">Set the regression type. Three
types are available: </paragraph>
<list type="unordered">
<listitem>
- <paragraph id="par_id1701201620334364" role="listitem"
xml-lang="en-US"><emph>Linear Regression</emph>: finds a linear function in the
form of y = b + a<sub>1</sub>.[x<sub>1</sub>] + a<sub>2</sub>.[x<sub>2</sub>] +
a<sub>3</sub>.[x<sub>3</sub>] ..., where a<sub>i</sub> is the i-th slope,
[x<sub>i</sub>] is the i-th independent variable, and b is the intercept that
best fits the data.</paragraph>
+ <paragraph id="par_id1701201620334364" role="listitem"><emph>Linear
Regression</emph>: finds a linear function in the form of y = b +
a<sub>1</sub>.[x<sub>1</sub>] + a<sub>2</sub>.[x<sub>2</sub>] +
a<sub>3</sub>.[x<sub>3</sub>] ..., where a<sub>i</sub> is the i-th slope,
[x<sub>i</sub>] is the i-th independent variable, and b is the intercept that
best fits the data.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id1701201620340168" role="listitem"
xml-lang="en-US"><emph>Logarithmic regression</emph>: finds a logarithmic curve
in the form of y = b + a<sub>1</sub>.ln[x<sub>1</sub>] +
a<sub>2</sub>.ln[x<sub>2</sub>] + a<sub>3</sub>.ln[x<sub>3</sub>] ..., where
a<sub>i</sub> is the i-th coefficient, b is the intercept and ln[x<sub>i</sub>]
is the natural logarithm of the i-th independent variable, that best fits the
data.</paragraph>
+ <paragraph id="par_id1701201620340168" role="listitem"><emph>Logarithmic
regression</emph>: finds a logarithmic curve in the form of y = b +
a<sub>1</sub>.ln[x<sub>1</sub>] + a<sub>2</sub>.ln[x<sub>2</sub>] +
a<sub>3</sub>.ln[x<sub>3</sub>] ..., where a<sub>i</sub> is the i-th
coefficient, b is the intercept and ln[x<sub>i</sub>] is the natural logarithm
of the i-th independent variable, that best fits the data.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id1701201620340139" role="listitem"
xml-lang="en-US"><emph>Power regression</emph>: finds a power curve in the form
of y = exp( b + a<sub>1</sub>.ln[x<sub>1</sub>] +
a<sub>2</sub>.ln[x<sub>2</sub>] + a<sub>3</sub>.ln[x<sub>3</sub>] ...), where
a<sub>i</sub> is the i-th power, [x<sub>i</sub>] is the i-th independent
variable, and b is intercept that best fits the data.</paragraph>
+ <paragraph id="par_id1701201620340139" role="listitem"><emph>Power
regression</emph>: finds a power curve in the form of y = exp( b +
a<sub>1</sub>.ln[x<sub>1</sub>] + a<sub>2</sub>.ln[x<sub>2</sub>] +
a<sub>3</sub>.ln[x<sub>3</sub>] ...), where a<sub>i</sub> is the i-th power,
[x<sub>i</sub>] is the i-th independent variable, and b is intercept that best
fits the data.</paragraph>
</listitem></list>
<h2 id="hd_id331629834218606">Options</h2>
diff --git a/source/text/scalc/01/statistics_sampling.xhp
b/source/text/scalc/01/statistics_sampling.xhp
index 665f8bb30f..d4bef45c2e 100644
--- a/source/text/scalc/01/statistics_sampling.xhp
+++ b/source/text/scalc/01/statistics_sampling.xhp
@@ -10,26 +10,28 @@
<meta>
<topic id="datasampligtopic" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Data Sampling in Calc</title>
+<title id="tit">Data Sampling in Calc</title>
<filename>/text/scalc/01/statistics_sampling.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id2764278">
+<bookmark branch="index" id="bm_id2764278">
<bookmark_value>Analysis toolpack;sampling</bookmark_value>
<bookmark_value>sampling;Analysis toolpack</bookmark_value>
<bookmark_value>Data statistics;sampling</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/samplingdialog/SamplingDialog" id="bm_id2745673"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/samplingdialog/@@nowidget@@" id="bm_id2745673"
localize="false"/>
+<bookmark branch="hid/.uno:SamplingDialog" id="bm_id261704457846799"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-SamplingDialog"
id="bm_id951704460051485" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/samplingdialog/SamplingDialog"
id="bm_id2745673" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/samplingdialog/@@nowidget@@"
id="bm_id2745673" localize="false"/>
<section id="datasampling">
<h1 id="hd_id1000020"><variable id="datasamplingh1"><link
href="text/scalc/01/statistics_sampling.xhp">Sampling</link></variable></h1>
-<paragraph id="par_id1000030" role="paragraph" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/samplingdialog/SamplingDialog">Create a table with data
sampled from another table.</ahelp></paragraph>
+<paragraph id="par_id1000030" role="paragraph"><ahelp
hid="modules/scalc/ui/samplingdialog/SamplingDialog">Create a table with data
sampled from another table.</ahelp></paragraph>
</section>
<section id="howtoget">
-<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable
id="sam01">Choose <menuitem>Data - Statistics -
Sampling</menuitem></variable></paragraph>
+<embed href="text/scalc/00/00000412.xhp#stat_sampling"/>
</section>
-<paragraph id="par_id1000050" role="paragraph" xml-lang="en-US">Sampling
allows you to pick data from a <emph>source</emph> table (population) to fill a
<emph>target</emph> table. The sampling can be random or in a periodic basis,
as well as with or without sample replacement in the source table.</paragraph>
+<paragraph id="par_id1000050" role="paragraph">Sampling allows you to pick
data from a <emph>source</emph> table (population) to fill a
<emph>target</emph> table. The sampling can be random or in a periodic basis,
as well as with or without sample replacement in the source table.</paragraph>
<note id="par_id1000060">Sampling is done row-wise. That means, the sampled
data will pick the whole line of the source table and copy into a line of the
target table.</note><embed href="text/scalc/01/stat_data.xhp#data"/>
<h2 id="hd_id1000030">Sampling Method</h2>
<h3 id="hd_id611623249550632">Random</h3>
@@ -45,193 +47,193 @@
<h3 id="hd_id101623249682605">Period</h3>
<paragraph role="paragraph" id="par_id621623249692296">The number of lines to
skip periodically when sampling. The <emph>Period</emph> is limited to the
population size.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id1000110" role="paragraph" xml-lang="en-US">The following
data will be used as example of source data table for sampling:</paragraph>
+<paragraph id="par_id1000110" role="paragraph">The following data will be used
as example of source data table for sampling:</paragraph>
<table id="Tabela1">
<tablerow>
<tablecell>
</tablecell>
<tablecell>
-<paragraph id="par_id1000120" role="tablehead" xml-lang="en-US"
localize="false">A</paragraph>
+<paragraph id="par_id1000120" role="tablehead" localize="false">A</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000130" role="tablehead" xml-lang="en-US"
localize="false">B</paragraph>
+<paragraph id="par_id1000130" role="tablehead" localize="false">B</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000140" role="tablehead" xml-lang="en-US"
localize="false">C</paragraph>
+<paragraph id="par_id1000140" role="tablehead" localize="false">C</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000150" role="tablehead" xml-lang="en-US"
localize="false">1</paragraph>
+<paragraph id="par_id1000150" role="tablehead" localize="false">1</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000160" role="tablecontent" xml-lang="en-US"
localize="false">11</paragraph>
+<paragraph id="par_id1000160" role="tablecontent"
localize="false">11</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000170" role="tablecontent" xml-lang="en-US"
localize="false">21</paragraph>
+<paragraph id="par_id1000170" role="tablecontent"
localize="false">21</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000180" role="tablecontent" xml-lang="en-US"
localize="false">31</paragraph>
+<paragraph id="par_id1000180" role="tablecontent"
localize="false">31</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000190" role="tablehead" xml-lang="en-US"
localize="false">2</paragraph>
+<paragraph id="par_id1000190" role="tablehead" localize="false">2</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000200" role="tablecontent" xml-lang="en-US"
localize="false">12</paragraph>
+<paragraph id="par_id1000200" role="tablecontent"
localize="false">12</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000210" role="tablecontent" xml-lang="en-US"
localize="false">22</paragraph>
+<paragraph id="par_id1000210" role="tablecontent"
localize="false">22</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000220" role="tablecontent" xml-lang="en-US"
localize="false">32</paragraph>
+<paragraph id="par_id1000220" role="tablecontent"
localize="false">32</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000230" role="tablehead" xml-lang="en-US"
localize="false">3</paragraph>
+<paragraph id="par_id1000230" role="tablehead" localize="false">3</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000240" role="tablecontent" xml-lang="en-US"
localize="false">13</paragraph>
+<paragraph id="par_id1000240" role="tablecontent"
localize="false">13</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000250" role="tablecontent" xml-lang="en-US"
localize="false">23</paragraph>
+<paragraph id="par_id1000250" role="tablecontent"
localize="false">23</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000260" role="tablecontent" xml-lang="en-US"
localize="false">33</paragraph>
+<paragraph id="par_id1000260" role="tablecontent"
localize="false">33</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000270" role="tablehead" xml-lang="en-US"
localize="false">4</paragraph>
+<paragraph id="par_id1000270" role="tablehead" localize="false">4</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000280" role="tablecontent" xml-lang="en-US"
localize="false">14</paragraph>
+<paragraph id="par_id1000280" role="tablecontent"
localize="false">14</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000290" role="tablecontent" xml-lang="en-US"
localize="false">24</paragraph>
+<paragraph id="par_id1000290" role="tablecontent"
localize="false">24</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000300" role="tablecontent" xml-lang="en-US"
localize="false">34</paragraph>
+<paragraph id="par_id1000300" role="tablecontent"
localize="false">34</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000310" role="tablehead" xml-lang="en-US"
localize="false">5</paragraph>
+<paragraph id="par_id1000310" role="tablehead" localize="false">5</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000320" role="tablecontent" xml-lang="en-US"
localize="false">15</paragraph>
+<paragraph id="par_id1000320" role="tablecontent"
localize="false">15</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000330" role="tablecontent" xml-lang="en-US"
localize="false">25</paragraph>
+<paragraph id="par_id1000330" role="tablecontent"
localize="false">25</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000340" role="tablecontent" xml-lang="en-US"
localize="false">35</paragraph>
+<paragraph id="par_id1000340" role="tablecontent"
localize="false">35</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000350" role="tablehead" xml-lang="en-US"
localize="false">6</paragraph>
+<paragraph id="par_id1000350" role="tablehead" localize="false">6</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000360" role="tablecontent" xml-lang="en-US"
localize="false">16</paragraph>
+<paragraph id="par_id1000360" role="tablecontent"
localize="false">16</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000370" role="tablecontent" xml-lang="en-US"
localize="false">26</paragraph>
+<paragraph id="par_id1000370" role="tablecontent"
localize="false">26</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000380" role="tablecontent" xml-lang="en-US"
localize="false">36</paragraph>
+<paragraph id="par_id1000380" role="tablecontent"
localize="false">36</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000390" role="tablehead" xml-lang="en-US"
localize="false">7</paragraph>
+<paragraph id="par_id1000390" role="tablehead" localize="false">7</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000400" role="tablecontent" xml-lang="en-US"
localize="false">17</paragraph>
+<paragraph id="par_id1000400" role="tablecontent"
localize="false">17</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000410" role="tablecontent" xml-lang="en-US"
localize="false">27</paragraph>
+<paragraph id="par_id1000410" role="tablecontent"
localize="false">27</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000420" role="tablecontent" xml-lang="en-US"
localize="false">37</paragraph>
+<paragraph id="par_id1000420" role="tablecontent"
localize="false">37</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000430" role="tablehead" xml-lang="en-US"
localize="false">8</paragraph>
+<paragraph id="par_id1000430" role="tablehead" localize="false">8</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000440" role="tablecontent" xml-lang="en-US"
localize="false">18</paragraph>
+<paragraph id="par_id1000440" role="tablecontent"
localize="false">18</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000450" role="tablecontent" xml-lang="en-US"
localize="false">28</paragraph>
+<paragraph id="par_id1000450" role="tablecontent"
localize="false">28</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000460" role="tablecontent" xml-lang="en-US"
localize="false">38</paragraph>
+<paragraph id="par_id1000460" role="tablecontent"
localize="false">38</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000470" role="tablehead" xml-lang="en-US"
localize="false">9</paragraph>
+<paragraph id="par_id1000470" role="tablehead" localize="false">9</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000480" role="tablecontent" xml-lang="en-US"
localize="false">19</paragraph>
+<paragraph id="par_id1000480" role="tablecontent"
localize="false">19</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000490" role="tablecontent" xml-lang="en-US"
localize="false">29</paragraph>
+<paragraph id="par_id1000490" role="tablecontent"
localize="false">29</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000500" role="tablecontent" xml-lang="en-US"
localize="false">39</paragraph>
+<paragraph id="par_id1000500" role="tablecontent"
localize="false">39</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph id="par_id1000510" role="paragraph" xml-lang="en-US">Sampling with
a period of 2 will result in the following table:</paragraph>
+<paragraph id="par_id1000510" role="paragraph">Sampling with a period of 2
will result in the following table:</paragraph>
<table id="Tabela2">
<tablerow>
<tablecell>
-<paragraph id="par_id1000520" role="tablecontent" xml-lang="en-US"
localize="false">12</paragraph>
+<paragraph id="par_id1000520" role="tablecontent"
localize="false">12</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000530" role="tablecontent" xml-lang="en-US"
localize="false">22</paragraph>
+<paragraph id="par_id1000530" role="tablecontent"
localize="false">22</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000540" role="tablecontent" xml-lang="en-US"
localize="false">32</paragraph>
+<paragraph id="par_id1000540" role="tablecontent"
localize="false">32</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000550" role="tablecontent" xml-lang="en-US"
localize="false">14</paragraph>
+<paragraph id="par_id1000550" role="tablecontent"
localize="false">14</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000560" role="tablecontent" xml-lang="en-US"
localize="false">24</paragraph>
+<paragraph id="par_id1000560" role="tablecontent"
localize="false">24</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000570" role="tablecontent" xml-lang="en-US"
localize="false">34</paragraph>
+<paragraph id="par_id1000570" role="tablecontent"
localize="false">34</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000580" role="tablecontent" xml-lang="en-US"
localize="false">16</paragraph>
+<paragraph id="par_id1000580" role="tablecontent"
localize="false">16</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000590" role="tablecontent" xml-lang="en-US"
localize="false">26</paragraph>
+<paragraph id="par_id1000590" role="tablecontent"
localize="false">26</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000600" role="tablecontent" xml-lang="en-US"
localize="false">36</paragraph>
+<paragraph id="par_id1000600" role="tablecontent"
localize="false">36</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph id="par_id1000610" role="tablecontent" xml-lang="en-US"
localize="false">18</paragraph>
+<paragraph id="par_id1000610" role="tablecontent"
localize="false">18</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000620" role="tablecontent" xml-lang="en-US"
localize="false">28</paragraph>
+<paragraph id="par_id1000620" role="tablecontent"
localize="false">28</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id1000630" role="tablecontent" xml-lang="en-US"
localize="false">38</paragraph>
+<paragraph id="par_id1000630" role="tablecontent"
localize="false">38</paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/source/text/scalc/01/statistics_test_chisqr.xhp
b/source/text/scalc/01/statistics_test_chisqr.xhp
index 2ede8080d2..cedfc7d5e2 100644
--- a/source/text/scalc/01/statistics_test_chisqr.xhp
+++ b/source/text/scalc/01/statistics_test_chisqr.xhp
@@ -11,24 +11,26 @@
<meta>
<topic id="chisquaretest" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Chi Square Statistics in Calc</title>
+<title id="tit">Chi Square Statistics in Calc</title>
<filename>/text/scalc/01/statistics_test_chisqr.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id05004">
+<bookmark branch="index" id="bm_id05004">
<bookmark_value>Analysis toolpack;Chi-square test</bookmark_value>
<bookmark_value>Chi-square test;Analysis toolpack</bookmark_value>
<bookmark_value>Data statistics;Chi-square test</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog"
id="bm_id05005" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/chisquaretestdialog/@@nowidget@@" id="bm_id05005"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-ChiSquareTestDialog"
id="bm_id311704459337183" localize="false"/>
+<bookmark branch="hid/.uno:ChiSquareTestDialog" id="bm_id521704458889731"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog"
id="bm_id05005" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/chisquaretestdialog/@@nowidget@@"
id="bm_id05015" localize="false"/>
<section id="chisqtest">
<h1 id="hd_id1000240"><variable id="chisqtesth1"><link
href="text/scalc/01/statistics_test_chisqr.xhp">Chi-square
test</link></variable></h1>
-<paragraph id="par_id1003641" role="paragraph" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog">Calculates the
Chi-square test of a data sample.</ahelp></paragraph>
-e
... etc. - the rest is truncated
