writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left">+ − + + + − <font size="3"><font face="Times New Roman">Where a1 is the first cell range and a2 is the second cell range of integers.</font></font>+ − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − <font size="3"><font face="Times New Roman">Covariance calculates as, the average of the products of deviations for each data point pair. It is to determine the relationship between two data sets. </font></font>+ − + + + + + − </div>+ − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − + − <font size="3">·</font> <font size="3"><font face="Times New Roman">Logical values and text representations of numbers are calculated but if an array or reference argument contains text, logical values, empty cells which are ignored</font></font>+ + + + + − <font size="3">·</font> <font size="3"><font face="Times New Roman">If either array1 or array2 is empty, COVAR calculates error value. </font></font>+ + + + − <font size="3"><font face="Times New Roman">+ + + + − <font size="3">·</font> <font size="3"><font face="Times New Roman">The covariance is: </font></font>+ + + + − <center><font size="3" face="Times New Roman"></font></center>+ + + + − <font size="3"><font face="Times New Roman">where x and y are the sample means AVERAGE(a1) and AVERAGE(a2), and n is the sample size.</font></font>+ + + + − </font></font></div>+ − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">COVAR</div></div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">AVEDEV (N1, N2...)</font></font> <font size="3"><font face="Times New Roman">Where N1, N 2 ... are positive integers.</font></font> '''</font></font></div> − ---- − <div id="5SpaceContent" class="zcontent" align="left"> − − Let’s see an example in (Column1 Row 1, Column2Row1) − − COVAR (a1, a2) − − B C − − 5 8 − − 6 9 − − 7 15 − − 8 17 − 9 20+ + − <nowiki>=COVAR (B2:B6, C2:C6) is 6.4</nowiki>+ − </div>+ − ---- − <div id="9SpaceContent" class="zcontent" align="left"> − {| id="TABLE1" class="SpreadSheet blue"+ − |- class="even" − | class=" " | − | Column1 − | class=" " | Column2 − | class=" " | Column3 − | class=" " | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f " | 5 − | class="sshl_f " | 8 − | class="sshl_f" | 6.4 − | class="sshl_f" | − |- class="even" − | class=" " | Row2 − | class="sshl_f" | 6 − | class="sshl_f" | 9 − | class="SelectTD" | − | class="sshl_f" | − |- class="odd" − | Row3 − | class="sshl_f" | 7 − | class="sshl_f" | 15 − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | Row4 − | class="sshl_f" | 8 − | class="sshl_f" | 17 − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | class=" " | Row5 − | class=" " | 9 − | class="sshl_f " | 20 − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | Row6 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |} − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----
no edit summary
=COVAR(a1,a2)=
<font size="3"><font face="Times New Roman">COVAR (a1, a2)</font></font>
where,
*<math>a1</math> first array of integers or reference to the cells containing array
*<math>a2</math> second array of integers or reference to the cells containing array
COVAR calculates the covariance, the average of the products of deviations for each data point pair in two arrays.
== Description ==
COVAR(a1,a2)
<font size="3" face="Times New Roman"> </font>
*COVAR is used to determine the relationship between two data sets.
*Arguments <math>a1</math>, <math>a2</math> can be numbers or can be names, arrays or references containing numbers.
*Values containing text, logical values or empty cells are ignored.
*If either <math>a1</math> or <math>a2</math> is empty, Calci displays a NaN error message.
*The number of data points in <math>a1</math> and <math>a2</math> should be same, else Calci displays a #N/A error message.
== Examples ==
<font size="3">·</font> <font size="3"><font face="Times New Roman">Arguments can be numbers, names, arrays, or references. </font></font>
<div id="2SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class="sshl_f" |'''Array 1'''
| class=" " |'''Array 2'''
| class=" " |
|- class="odd"
| class="sshl_f" |2
| class=" " |21
| class=" " |
|- class="even"
| class="sshl_f" |4
| class=" " |22
| class=" " |
|- class="odd"
| class="sshl_f" |6
| class=" " |23
| class=" " |
|- class="even"
| class="sshl_f" |8
| class=" " |24
| class=" " |
|- class="odd"
| class="sshl_f" |10
| class=" " |25
| class=" " |
|}
=COVAR(A2:A6,B2:B6) : Returns ''4'' as the output.
=COVAR(A2:A5,{12,13,14,15}) : Returns '2.5'' as the output.
== See Also ==
*[[Manuals/calci/COVARIANCE | COVARIANCE]]
== References ==
*[http://en.wikipedia.org/wiki/Covariance Covariance]