diff options
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/statistics.xhp | 257 |
1 files changed, 257 insertions, 0 deletions
diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp new file mode 100644 index 0000000000..f1c3bb765a --- /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> |