blob: 43b1b5d5d1280fc1c835cef280e0a41b3ed00184 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
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>
|
