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.hallot@libreoffice.org>

1 files changed, 109 insertions, 0 deletions

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>