summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-08-02 21:35:44 -0300
committerDavid Tardon <dtardon@redhat.com>2014-08-04 11:09:06 +0000
commit135498091966f63d582929446a084b41d3ffd4da (patch)
tree13f1fa177754b2f9f47d3304540f041bd84d4d66
parent4cdb8959d25330c2b26123b5a89b126617066e1e (diff)
Partial fix for fdo#80338: help for calc statistics
Entry page for Calc Data statistics. This is work in progress and the help content should be completed with the correct information. Change-Id: I34f67a2b10d76bb1da6a9b9f4e24d4242396cbe4 Reviewed-on: https://gerrit.libreoffice.org/10703 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
-rw-r--r--AllLangHelp_scalc.mk1
-rw-r--r--source/text/scalc/01/statistics.xhp257
2 files changed, 258 insertions, 0 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index c4ba90b08..07ca0ad7b 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -206,6 +206,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_yearfrac \
helpcontent2/source/text/scalc/01/solver \
helpcontent2/source/text/scalc/01/solver_options \
+ helpcontent2/source/text/scalc/01/statistics \
helpcontent2/source/text/scalc/01/text2columns \
helpcontent2/source/text/scalc/02/02130000 \
helpcontent2/source/text/scalc/02/02140000 \
diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp
new file mode 100644
index 000000000..f1c3bb765
--- /dev/null
+++ b/source/text/scalc/01/statistics.xhp
@@ -0,0 +1,257 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="statistics" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Data Statistics</title>
+<filename>/text/scalc/01/statistics.xhp</filename>
+</topic>
+</meta>
+<body>
+<paragraph role="heading" id="hd_id1" xml-lang="en-US" level="1" l10n="U" oldref="1">Data Statistics</paragraph>
+<section id="datasampling">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2764278">
+ <bookmark_value>Analysis toolpack;sampling</bookmark_value>
+ <bookmark_value>sampling;Analysis toolpack</bookmark_value>
+ <bookmark_value>Data statistics;sampling</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/SamplingDialog" id="bm_id2745673" localize="false"/>
+<paragraph role="heading" id="hd_id2753032" xml-lang="en-US" level="2" l10n="U" oldref="1">Sampling</paragraph>
+<paragraph role="paragraph" id="par_id2756327" xml-lang="en-US" l10n="U" oldref="2">
+ <ahelp hid="/modules/scalc/ui/samplingdialog/SamplingDialog">(to-do)</ahelp></paragraph>
+<section id="howtoget">
+ <paragraph role="paragraph" id="par_id2752992" xml-lang="en-US" l10n="U" oldref="26">
+ <variable id="sam01">Menu <emph>Data - Statistics - Sampling...</emph></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id2756923" xml-lang="en-US" l10n="U" oldref="4">
+ (To do)
+</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/input-range-label" id="bm_id2748663" localize="false"/>
+<paragraph role="heading" id="hd_id2753895" xml-lang="en-US" level="3" l10n="U" oldref="5">Input Range</paragraph>
+<paragraph role="paragraph" id="par_id2750400" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="modules/scalc/ui/samplingdialog/input-range-label">Select the input data range.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/output-range-label" id="bm_id263984" localize="false"/>
+<paragraph role="heading" id="hd_id2754704" xml-lang="en-US" level="3" l10n="CHG" oldref="7">Results to</paragraph>
+<paragraph role="paragraph" id="par_id2753967" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="modules/scalc/ui/samplingdialog/output-range-label">Selects the upper left cell where the samples will be displayed.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/samplingdialog/groupedby-columns-radio" id="bm_id2739518" localize="false"/>
+</section>
+
+<section id="descriptivestatistics">
+<bookmark xml-lang="en-US" branch="index" id="bm_id01001">
+ <bookmark_value>Analysis toolpack;descriptive statistics</bookmark_value>
+ <bookmark_value>descriptive statistics;Analysis toolpack</bookmark_value>
+ <bookmark_value>Data statistics;descriptive statistics</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog" id="bm_id01002" localize="false"/>
+<paragraph role="heading" id="hd_id01003" xml-lang="en-US" level="2" l10n="U" oldref="1">Descriptive Statistics</paragraph>
+<paragraph role="paragraph" id="par_id01004" xml-lang="en-US" l10n="U" oldref="2">
+ <ahelp hid="/modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog">(to-do)</ahelp></paragraph>
+<section id="howtoget">
+ <paragraph role="paragraph" id="par_id01005" xml-lang="en-US" l10n="U" oldref="26">
+ <variable id="sam01">Menu <emph>Data - Statistics - Descriptive Statistics...</emph></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id01006" xml-lang="en-US" l10n="U" oldref="4">
+ (To do)
+</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/descriptivestatisticsdialog/input-range-label" id="bm_id01007" localize="false"/>
+<paragraph role="heading" id="hd_id01008" xml-lang="en-US" level="3" l10n="U" oldref="5">Input Range</paragraph>
+<paragraph role="paragraph" id="par_id01009" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="modules/scalc/ui/descriptivestatisticsdialog/input-range-label">Select the input data range.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/descriptivestatisticsdialog/output-range-label" id="bm_id01010" localize="false"/>
+<paragraph role="heading" id="hd_id01011" xml-lang="en-US" level="3" l10n="CHG" oldref="7">Results to</paragraph>
+<paragraph role="paragraph" id="par_id01012" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="modules/scalc/ui/descriptivestatisticsdialog/output-range-label">Selects the upper left cell where the samples will be displayed.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/descriptivestatisticsdialog/groupedby-columns-radio" id="bm_id01013" localize="false"/>
+</section>
+
+<section id="anova">
+<bookmark xml-lang="en-US" branch="index" id="bm_id02001">
+ <bookmark_value>Analysis toolpack;analysis of variance</bookmark_value>
+ <bookmark_value>analysis of variance;Analysis toolpack</bookmark_value>
+ <bookmark_value>Data statistics;analysis of variance</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog" id="bm_id02002" localize="false"/>
+<paragraph role="heading" id="hd_id02003" xml-lang="en-US" level="2" l10n="U" oldref="1">Analysis of Variance (ANOVA)</paragraph>
+<paragraph role="paragraph" id="par_id02004" xml-lang="en-US" l10n="U" oldref="2">
+ <ahelp hid="/modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog">(to-do)</ahelp></paragraph>
+<section id="howtoget">
+ <paragraph role="paragraph" id="par_id02005" xml-lang="en-US" l10n="U" oldref="26">
+ <variable id="sam01">Menu <emph>Data - Statistics - Analysis of Variance (ANOVA)...</emph></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id02006" xml-lang="en-US" l10n="U" oldref="4">
+ (To do)
+</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/input-range-label" id="bm_id02007" localize="false"/>
+<paragraph role="heading" id="hd_id02008" xml-lang="en-US" level="3" l10n="U" oldref="5">Input Range</paragraph>
+<paragraph role="paragraph" id="par_id02009" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="modules/scalc/ui/analysisofvariancedialog/input-range-label">Select the input data range.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/output-range-label" id="bm_id02010" localize="false"/>
+<paragraph role="heading" id="hd_id02011" xml-lang="en-US" level="3" l10n="CHG" oldref="7">Results to</paragraph>
+<paragraph role="paragraph" id="par_id02012" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="modules/scalc/ui/analysisofvariancedialog/output-range-label">Selects the upper left cell where the samples will be displayed.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/analysisofvariancedialog/groupedby-columns-radio" id="bm_id02013" localize="false"/>
+</section>
+
+<section id="correlation">
+<bookmark xml-lang="en-US" branch="index" id="bm_id1464278">
+ <bookmark_value>Analysis toolpack;correlation</bookmark_value>
+ <bookmark_value>correlation;Analysis toolpack</bookmark_value>
+ <bookmark_value>Data statistics;correlation</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/CorrelationDialog" id="bm_id3145673" localize="false"/>
+<paragraph role="heading" id="hd_id3153032" xml-lang="en-US" level="2" l10n="U" oldref="1">Correlation</paragraph>
+<paragraph role="paragraph" id="par_id3156327" xml-lang="en-US" l10n="U" oldref="2">
+ <ahelp hid="/modules/scalc/ui/correlationdialog/CorrelationDialog">Calculates the correlation of two sets of numeric data.</ahelp></paragraph>
+<section id="howtoget">
+ <paragraph role="paragraph" id="par_id3152992" xml-lang="en-US" l10n="U" oldref="26">
+ <variable id="corr01">Menu <emph>Data - Statistics - Correlation...</emph></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id3155923" xml-lang="en-US" l10n="U" oldref="4">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 role="paragraph" id="par_id2955923" xml-lang="en-US" l10n="U" oldref="4">A correlation coefficient of +1 indicates a perfect positive correlation. </paragraph>
+<paragraph role="paragraph" id="par_id2855923" xml-lang="en-US" l10n="U" oldref="4">A correlation coefficient of -1 indicates a perfect negative correlation</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/input-range-label" id="bm_id3148663" localize="false"/>
+<paragraph role="heading" id="hd_id3153896" xml-lang="en-US" level="3" l10n="U" oldref="5">Input Range</paragraph>
+<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="modules/scalc/ui/correlationdialog/input-range-label">Select the inout data range.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/output-range-label" id="bm_id263985" localize="false"/>
+<paragraph role="heading" id="hd_id3154704" xml-lang="en-US" level="3" l10n="CHG" oldref="7">Results to</paragraph>
+<paragraph role="paragraph" id="par_id3153967" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="modules/scalc/ui/correlationdialog/output-range-label">Selects the upper left cell where the correlation will be displayed.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/groupedby-columns-radio" id="bm_id5339518" localize="false"/>
+<paragraph role="heading" id="par_idN10709" xml-lang="en-US" level="3" l10n="NEW">Columns</paragraph>
+<paragraph role="paragraph" id="par_idN1070D" xml-lang="en-US" l10n="NEW"><ahelp hid="modules/scalc/ui/correlationdialog/groupedby-columns-radio">The data series ae in columns.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/correlationdialog/groupedby-columns-radio" id="bm_id2339518" localize="false"/>
+<paragraph role="heading" id="par_idN11709" xml-lang="en-US" level="3" l10n="NEW">Rows</paragraph>
+<paragraph role="paragraph" id="par_idN1270D" xml-lang="en-US" l10n="NEW"><ahelp hid="modules/scalc/ui/correlationdialog/groupedby-columns-radio">The data series are in rows.</ahelp></paragraph>
+</section>
+
+<section id="covariance">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2964278">
+ <bookmark_value>Analysis toolpack;covariance</bookmark_value>
+ <bookmark_value>covariance;Analysis toolpack</bookmark_value>
+ <bookmark_value>Data statistics;covariance</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/CovarianceDialog" id="bm_id2945673" localize="false"/>
+<paragraph role="heading" id="hd_id2953032" xml-lang="en-US" level="2" l10n="U" oldref="1">Covariance</paragraph>
+<paragraph role="paragraph" id="par_id2956327" xml-lang="en-US" l10n="U" oldref="2">
+ <ahelp hid="/modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the covariance of two sets of numeric data.</ahelp></paragraph>
+<section id="howtoget">
+ <paragraph role="paragraph" id="par_id2952992" xml-lang="en-US" l10n="U" oldref="26">
+ <variable id="cov01">Menu <emph>Data - Statistics - Covariance...</emph></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id2956923" xml-lang="en-US" l10n="U" oldref="4">
+ Covariance indicates how two variables are related. A positive covariance means the variables are positively related,
+ while a negative covariance means the variables are inversely related.
+</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/input-range-label" id="bm_id3148663" localize="false"/>
+<paragraph role="heading" id="hd_id2953895" xml-lang="en-US" level="3" l10n="U" oldref="5">Input Range</paragraph>
+<paragraph role="paragraph" id="par_id2950400" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="modules/scalc/ui/covariancedialog/input-range-label">Select the input data range.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/output-range-label" id="bm_id263985" localize="false"/>
+<paragraph role="heading" id="hd_id2954704" xml-lang="en-US" level="3" l10n="CHG" oldref="7">Results to</paragraph>
+<paragraph role="paragraph" id="par_id2953967" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="modules/scalc/ui/covariancedialog/output-range-label">Selects the upper left cell where the correlation will be displayed.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/groupedby-columns-radio" id="bm_id5339518" localize="false"/>
+<paragraph role="heading" id="par_idN117091" xml-lang="en-US" level="3" l10n="NEW">Columns</paragraph>
+<paragraph role="paragraph" id="par_idN1170D" xml-lang="en-US" l10n="NEW"><ahelp hid="modules/scalc/ui/covariancedialog/groupedby-columns-radio">The data series are in columns.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/groupedby-columns-radio" id="bm_id2339518" localize="false"/>
+<paragraph role="heading" id="par_idN11710" xml-lang="en-US" level="3" l10n="NEW">Rows</paragraph>
+<paragraph role="paragraph" id="par_idN1171D" xml-lang="en-US" l10n="NEW"><ahelp hid="modules/scalc/ui/covariancedialog/groupedby-columns-radio">The data series are in rows.</ahelp></paragraph>
+</section>
+
+<section id="exponentialsmoothing">
+<bookmark xml-lang="en-US" branch="index" id="bm_id03001">
+ <bookmark_value>Analysis toolpack;exponential smoothing</bookmark_value>
+ <bookmark_value>exponential smoothing;Analysis toolpack</bookmark_value>
+ <bookmark_value>Data statistics;exponential smoothing</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog" id="bm_id03002" localize="false"/>
+<paragraph role="heading" id="hd_id03003" xml-lang="en-US" level="2" l10n="U" oldref="1">Exponential Smoothing</paragraph>
+<paragraph role="paragraph" id="par_id03004" xml-lang="en-US" l10n="U" oldref="2">
+ <ahelp hid="/modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">(to-do)</ahelp></paragraph>
+<section id="howtoget">
+ <paragraph role="paragraph" id="par_id03005" xml-lang="en-US" l10n="U" oldref="26">
+ <variable id="sam01">Menu <emph>Data - Statistics - Exponential Smoothing...</emph></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id03006" xml-lang="en-US" l10n="U" oldref="4">
+ (To do)
+</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/input-range-label" id="bm_id03007" localize="false"/>
+<paragraph role="heading" id="hd_id03008" xml-lang="en-US" level="3" l10n="U" oldref="5">Input Range</paragraph>
+<paragraph role="paragraph" id="par_id03009" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="modules/scalc/ui/exponentialsmoothingdialog/input-range-label">Select the input data range.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/output-range-label" id="bm_id03010" localize="false"/>
+<paragraph role="heading" id="hd_id03011" xml-lang="en-US" level="3" l10n="CHG" oldref="7">Results to</paragraph>
+<paragraph role="paragraph" id="par_id03012" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="modules/scalc/ui/exponentialsmoothingdialog/output-range-label">Selects the upper left cell where the samples will be displayed.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/groupedby-columns-radio" id="bm_id03013" localize="false"/>
+</section>
+
+<section id="movingaverage">
+<bookmark xml-lang="en-US" branch="index" id="bm_id04001">
+ <bookmark_value>Analysis toolpack;moving average</bookmark_value>
+ <bookmark_value>moving average;Analysis toolpack</bookmark_value>
+ <bookmark_value>Data statistics;moving average</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movingaveragedialog/MovingAverageDialog" id="bm_id04002" localize="false"/>
+<paragraph role="heading" id="hd_id04003" xml-lang="en-US" level="2" l10n="U" oldref="1">Moving Average</paragraph>
+<paragraph role="paragraph" id="par_id04004" xml-lang="en-US" l10n="U" oldref="2">
+ <ahelp hid="/modules/scalc/ui/movingaveragedialog/MovingAverageDialog">(to-do)</ahelp></paragraph>
+<section id="howtoget">
+ <paragraph role="paragraph" id="par_id04005" xml-lang="en-US" l10n="U" oldref="26">
+ <variable id="sam01">Menu <emph>Data - Statistics - Moving Average...</emph></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id04006" xml-lang="en-US" l10n="U" oldref="4">
+ (To do)
+</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movingaveragedialog/input-range-label" id="bm_id04007" localize="false"/>
+<paragraph role="heading" id="hd_id04008" xml-lang="en-US" level="3" l10n="U" oldref="5">Input Range</paragraph>
+<paragraph role="paragraph" id="par_id04009" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="modules/scalc/ui/movingaveragedialog/input-range-label">Select the input data range.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movingaveragedialog/output-range-label" id="bm_id04010" localize="false"/>
+<paragraph role="heading" id="hd_id04011" xml-lang="en-US" level="3" l10n="CHG" oldref="7">Results to</paragraph>
+<paragraph role="paragraph" id="par_id04012" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="modules/scalc/ui/movingaveragedialog/output-range-label">Selects the upper left cell where the samples will be displayed.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movingaveragedialog/groupedby-columns-radio" id="bm_id04013" localize="false"/>
+</section>
+
+<section id="ttest">
+<bookmark xml-lang="en-US" branch="index" id="bm_id05001">
+ <bookmark_value>Analysis toolpack;t-test</bookmark_value>
+ <bookmark_value>t-test;Analysis toolpack</bookmark_value>
+ <bookmark_value>Data statistics;t-test</bookmark_value>
+ <bookmark_value>Analysis toolpack;F-test</bookmark_value>
+ <bookmark_value>F-test;Analysis toolpack</bookmark_value>
+ <bookmark_value>Data statistics;F-test</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05002" localize="false"/>
+<paragraph role="heading" id="hd_id05003" xml-lang="en-US" level="2" l10n="U" oldref="1">t-test and F-test</paragraph>
+<paragraph role="paragraph" id="par_id05004" xml-lang="en-US" l10n="U" oldref="2">
+ <ahelp hid="/modules/scalc/ui/ttestdialog/TTestDialog">(to-do)</ahelp></paragraph>
+<section id="howtoget">
+ <paragraph role="paragraph" id="par_id05005" xml-lang="en-US" l10n="U" oldref="26">
+ <variable id="sam01">Menu <emph>Data - Statistics - t-test...</emph></variable></paragraph>
+ <paragraph role="paragraph" id="par_id050051" xml-lang="en-US" l10n="U" oldref="26">
+ <variable id="sam02">Menu <emph>Data - Statistics - F-test...</emph></variable></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id05006" xml-lang="en-US" l10n="U" oldref="4">
+ (To do)
+</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/input-range-label" id="bm_id05007" localize="false"/>
+<paragraph role="heading" id="hd_id05008" xml-lang="en-US" level="3" l10n="U" oldref="5">Input Range</paragraph>
+<paragraph role="paragraph" id="par_id05009" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="modules/scalc/ui/ttestdialog/input-range-label">Select the input data range.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/output-range-label" id="bm_id05010" localize="false"/>
+<paragraph role="heading" id="hd_id05011" xml-lang="en-US" level="3" l10n="CHG" oldref="7">Results to</paragraph>
+<paragraph role="paragraph" id="par_id05012" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="modules/scalc/ui/ttestdialog/output-range-label">Selects the upper left cell where the samples will be displayed.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/ttestdialog/groupedby-columns-radio" id="bm_id05013" localize="false"/>
+</section>
+
+</body>
+
+</helpdocument>