blob: b2b4d1d96c251990192f17c92e6e59dad5602af1 (
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
|
<?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 Covariance in Calc</title>
<filename>/text/scalc/01/statistics_covariance.xhp</filename>
</topic>
</meta>
<body>
<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"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/covariancedialog/@@nowidget@@" id="bm_id2945673" localize="false"/>
<section id="covariance">
<h1 id="hd_id1000100"><variable id="covarianceh1"><link href="text/scalc/01/statistics_covariance.xhp" name="Covariance">Covariance</link></variable></h1>
<paragraph id="par_id1001940" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the covariance of two sets of numeric data.</ahelp></paragraph>
</section>
<section id="howtoget">
<paragraph id="par_id1001950" role="paragraph" xml-lang="en-US"><variable id="cov01">Choose <menuitem>Data - Statistics - Covariance</menuitem></variable></paragraph>
</section>
<paragraph id="par_id1001960" role="paragraph" xml-lang="en-US">The covariance is a measure of how much two random variables change together.</paragraph>
<note id="par_id1001970">For more information on statistical covariance, refer to the <link href="https://en.wikipedia.org/wiki/Covariance" name="English Wikipedia: Covariance">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_id1001980" role="paragraph" xml-lang="en-US">The following table displays the results of the covariance of the sample data above.</paragraph>
<table id="Tabela7">
<tablerow>
<tablecell>
<paragraph id="par_id1001990" role="tablehead" xml-lang="en-US">Covariances</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1002000" role="tablehead" xml-lang="en-US">Column 1</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1002010" role="tablehead" xml-lang="en-US">Column 2</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1002020" role="tablehead" xml-lang="en-US">Column 3</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1002030" role="tablehead" xml-lang="en-US">Column 1</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1002040" role="tablecontent" xml-lang="en-US" localize="false">126.8099173554</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1002050" role="tablehead" xml-lang="en-US">Column 2</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1002060" role="tablecontent" xml-lang="en-US" localize="false">-61.4444444444</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1002070" role="tablecontent" xml-lang="en-US" localize="false">258.41</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1002080" role="tablehead" xml-lang="en-US">Column 3</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1002090" role="tablecontent" xml-lang="en-US" localize="false">-32</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1002100" role="tablecontent" xml-lang="en-US" localize="false">53.11</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1002110" role="tablecontent" xml-lang="en-US" localize="false">204.61</paragraph>
</tablecell>
</tablerow>
</table>
<section id="relatedtopics">
<embed href="text/scalc/01/stat_data.xhp#otherstat"/>
</section>
</body>
</helpdocument>
|
