diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-07 09:06:44 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-07 09:06:44 +0000 |
| commit | ed5640d8b587fbcfed7dd7967f3de04b37a76f26 (patch) | |
| tree | 7a5f7c6c9d02226d7471cb3cc8fbbf631b415303 /helpcontent2/source/text/scalc/01/statistics_correlation.xhp | |
| parent | Initial commit. (diff) | |
| download | libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.tar.xz libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.zip | |
Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'helpcontent2/source/text/scalc/01/statistics_correlation.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/statistics_correlation.xhp | 101 |
1 files changed, 101 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/statistics_correlation.xhp b/helpcontent2/source/text/scalc/01/statistics_correlation.xhp new file mode 100644 index 000000000..43b1b5d5d --- /dev/null +++ b/helpcontent2/source/text/scalc/01/statistics_correlation.xhp @@ -0,0 +1,101 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + +<meta> +<topic id="ID" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" 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_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"/> +<section id="correlation"> +<h1 id="hd_id1000090"><variable id="correlationh1"><link href="text/scalc/01/statistics_correlation.xhp" name="Correlation">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> +</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> +</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> +<note id="par_id1001790">For more information on statistical correlation, refer to the <link href="https://en.wikipedia.org/wiki/Correlation" name="English Wikipedia: 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> +<table id="Tabela6"> +<tablerow> +<tablecell> +<paragraph id="par_id1001810" role="tablehead" xml-lang="en-US">Correlations</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001820" role="tablehead" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001830" role="tablehead" xml-lang="en-US">Column 2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001840" role="tablehead" xml-lang="en-US">Column 3</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001850" role="tablehead" xml-lang="en-US">Column 1</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001860" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> +</tablecell> +<tablecell> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001870" role="tablehead" xml-lang="en-US">Column 2</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001880" role="tablecontent" xml-lang="en-US" localize="false">-0.4029254917</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001890" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> +</tablecell> +<tablecell> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph id="par_id1001900" role="tablehead" xml-lang="en-US">Column 3</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001910" role="tablecontent" xml-lang="en-US" localize="false">-0.2107642836</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001920" role="tablecontent" xml-lang="en-US" localize="false">0.2309714048</paragraph> +</tablecell> +<tablecell> +<paragraph id="par_id1001930" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> +</tablecell> +</tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> |