Manuals/calci/COVARIANCE - Revision history

Jayaram: Replaced content with "Refer the page * COVARIANCEDATAANALYSIS"

2017-02-09T04:18:41Z

Replaced content with "Refer the page * COVARIANCEDATAANALYSIS"

Devika at 19:02, 5 June 2015

2015-06-05T19:02:00Z

Swapna at 21:01, 9 May 2015

2015-05-09T21:01:55Z

Swapna at 16:04, 21 January 2014

2014-01-21T16:04:26Z

Swapna at 16:01, 21 January 2014

2014-01-21T16:01:05Z

Show changes

MassBot1: Created page with "
'''COVARIANCENDATAANALYSIS'''(Array,GroupBy, NewTableFlag) where, '''Array '''- Input range should be one or..."

2013-10-25T02:32:29Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''COVARIANCENDATAANALYSIS'''(Array,GroupBy, NewTableFlag) where, '''Array '''- Input range should be one or..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''COVARIANCENDATAANALYSIS'''(Array,GroupBy, NewTableFlag)

where,

'''Array '''- Input range should be one or more blocks.

'''GroupBy''' - Either groupby rows or columns.

'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet.If NewTableFlag is omitted, it assumed to be FALSE.

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">Calculates the average of the product of deviatons of values from the means of each data set.</div>
----
<div id="7SpaceContent" class="zcontent" align="left">If array contains the text, then COVARIANCE returns NaN.</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

COVARIANCE

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

Lets see an example in (Column3, Row1)

<nowiki>=COVARIANCEDATAANALYSIS(R1C1:R4C2, "Columns",TRUE)</nowiki>

It returns the result in new sheet(2Sapce).

<nowiki>=COVARIANCEDATAANALYSIS(R1C1:R5C2,"Rows", TRUE)</nowiki>

It returns the result in new sheet(9space).

</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="5SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| class=" SelectTD1 ChangeBGColor SelectTD1" |
<div id="5Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="5Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="5Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | 5
| class=" " | 3
| class="sshl_f" | 2Space
| class="sshl_f" | 5
|- class="even"
| class=" " | Row2
| class=" " | 7
| class=" " | 8
| class=" " | 9
| class="sshl_f" | 128
|- class="odd"
| Row3
| class=" " | 12
| class=" " | 8
| 14
| class="sshl_f " | 15
|- class="even"
| Row4
| class=" " | 17
| class=" " | 18
| class="sshl_f" | 10000
| class=" " | 20
|- class="odd"
| class=" " | Row5
| 41
| 34
| 10023
| 168
|- class="even"
| Row6
| 6
| class="sshl_f" | 9Space
| 1.619775
| 0.525322
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| class="SpreadSheet blue"
|+ <br />Covariance by Columns
|- class="even"
!
! Column1
! Column2
|- class="odd"
| Column1
| 21.6875
| 23.4375
|- class="even"
| Column2
| 23.4375
| 29.6875
|}

</div>
----
<div id="9SpaceContent" class="zcontent" align="left">

{| class="SpreadSheet blue"
|+ <br />Covariance by Rows
|- class="even"
!
! Row1
! Row2
! Row3
! Row4
|- class="odd"
| Row1
| 1
| -0.5
| 2
| -0.5
|- class="even"
| Row2
| -0.5
| 0.25
| -1
| 0.25
|- class="odd"
| Row3
| 2
| -1
| 4
| -1
|- class="even"
| Row4
| -0.5
| 0.25
| -1
| 0.25
|}

</div>
----

← Older revision		Revision as of 04:18, 9 February 2017
Line 1:		Line 1:
−	~~=COVARIANCEDATAANALYSIS(Array, GroupBy, NewTableFlag)=~~	+	Refer the page

−	~~where,~~	+	*[[Manuals/calci/COVARIANCEDATAANALYSIS\| COVARIANCEDATAANALYSIS]]
−	*<math>Array</math> is array of integers or reference to the cells containing array,
−	*<math>GroupBy</math> is a method that performs the analysis by Columns or Rows,
−	*<math>NewTableFlag</math> is a flag that determines how the output should be displayed.
−
−	~~COVARIANCEDATAANALYSIS() calculates the average of product of deviations of values from the means of each data set.~~
−
−	~~== Description ==~~
−
−	~~COVARIANCEDATAANALYSIS(Array, GroupBy, NewTableFlag)~~
−
−	*Covariance is a method used to determine the relationship between two data sets.
−	*<math>Array</math> can be numbers or can be names, arrays or references containing numbers.
−	*Values containing text, logical values or empty cells are ignored.
−	*Argument <math>GroupBy</math> can be "Rows" or "Columns".
−	*<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
−	*If <math>NewTableFlag</math> is TRUE, output is displayed on a new ZSpace cube. If <math>NewTableFlag</math> is FALSE, output is displayed on the same spreadsheet where command is written.
−	*If data is invalid, Calci displays NaN error message.
−
−	~~==ZOS==~~
−
−	*The syntax is to calculate this function in ZOS is <math>COVARIANCEDATAANALYSIS (2D-Array,GroupBy,NewTableFlag)</math>
−	*<math>GroupBy</math> is a method that performs the analysis by Columns or Rows,
−	*<math>NewTableFlag</math> is a flag that determines how the output should be displayed which is either TRUE or FALSE.
−	*For e.g., COVARIANCEDATAANALYSIS([[10,13,16,19,22],[29,27,34,41,56]],"columns",true)
−	*COVARIANCEDATAANALYSIS([[33..39],[57..63]],"columns",false)
−
−	~~== Examples ==~~
−	~~Consider the following table with two arrays as input data.~~
−
−	~~<div id="5SpaceContent" class="zcontent" align="left">~~
−
−	~~{\| id="TABLE3" class="SpreadSheet blue"~~
−	~~\|- class="even"~~
−	~~\| class=" " \|~~
−	~~\| Column1~~
−	~~\| Column2~~
−	~~\| Column3~~
−	~~\| Column4~~
−
−	~~\|- class="odd"~~
−	~~\| class=" " \| Row1~~
−	~~\| class=" " \| 5~~
−	~~\| class=" " \| 3~~
−	~~\| class="sshl_f" \|~~
−	~~\| class="sshl_f" \|~~
−
−	~~\|- class="even"~~
−	~~\| class=" " \| Row2~~
−	~~\| class=" " \| 7~~
−	~~\| class=" " \| 8~~
−	~~\| class=" " \|~~
−	~~\| class="sshl_f" \|~~
−
−	~~\|- class="odd"~~
−	~~\| class=" " \| Row3~~
−	~~\| class=" " \| 12~~
−	~~\| class=" " \| 8~~
−	~~\| class=" " \|~~
−	~~\| class="sshl_f" \|~~
−
−	~~\|- class="even"~~
−	~~\| class=" " \| Row4~~
−	~~\| class=" " \| 17~~
−	~~\| class=" " \| 18~~
−	~~\| class="sshl_f" \|~~
−	~~\| class=" " \|~~
−
−	~~\|- class="odd"~~
−	~~\| class=" " \| Row5~~
−	~~\| class=" " \| 41~~
−	~~\| class=" " \| 34~~
−	~~\| class="sshl_f" \|~~
−	~~\| class=" " \|~~
−
−	~~\|- class="even"~~
−	~~\| class=" " \| Row6~~
−	~~\| class=" " \|~~
−	~~\| class=" " \|~~
−	~~\| class="sshl_f" \|~~
−	~~\| class=" " \|~~
−	\|}
−
−	~~</div>~~
−
−	~~=COVARIANCEDATAANALYSIS(A2:B5,"Columns",TRUE)~~
−	~~=COVARIANCEDATAANALYSIS(A2:B6,"Rows",TRUE)~~
−
−	~~----~~
−	~~Output for the above examples is displayed respectively.~~
−
−	~~<div id="2SpaceContent" class="zcontent" align="left">~~
−
−	~~{\| class="SpreadSheet blue"~~
−	~~\|+ <br />Covariance by Columns~~
−	~~\|- class="even"~~
−	!
−	~~! Column1~~
−	~~! Column2~~
−	~~\|- class="odd"~~
−	~~\| Column1~~
−	~~\| 21.6875~~
−	~~\| 23.4375~~
−	~~\|- class="even"~~
−	~~\| Column2~~
−	~~\| 23.4375~~
−	~~\| 29.6875~~
−	\|}
−
−	~~</div>~~
−	~~----~~
−	~~<div id="9SpaceContent" class="zcontent" align="left">~~
−
−	~~{\| class="SpreadSheet blue"~~
−	~~\|+ <br />Covariance by Rows~~
−	~~\|- class="even"~~
−	!
−	~~! Row1~~
−	~~! Row2~~
−	~~! Row3~~
−	~~! Row4~~
−	~~! Row5~~
−	~~\|- class="odd"~~
−	~~\| Row1~~
−	~~\| 1~~
−	~~\| -0.5~~
−	~~\| 2~~
−	~~\| -0.5~~
−	~~\| 3.5~~
−	~~\|- class="even"~~
−	~~\| Row2~~
−	~~\| -0.5~~
−	~~\| 0.25~~
−	~~\| -1~~
−	~~\| 0.25~~
−	~~\| -1.75~~
−	~~\|- class="odd"~~
−	~~\| Row3~~
−	~~\| 2~~
−	~~\| -1~~
−	~~\| 4~~
−	~~\| -1~~
−	~~\| 7~~
−	~~\|- class="even"~~
−	~~\| Row4~~
−	~~\| -0.5~~
−	~~\| 0.25~~
−	~~\| -1~~
−	~~\| 0.25~~
−	~~\| -1.75~~
−	~~\|- class="odd"~~
−	~~\| Row5~~
−	~~\| 3.5~~
−	~~\| -1.75~~
−	~~\| 7~~
−	~~\| -1.75~~
−	~~\| 12.25~~
−	\|}
−	~~</div>~~
−
−	~~==Related Videos==~~
−
−	~~{{#ev:youtube\|ualmyZiPs9w\|280\|center\|Covariance}}~~
−
−	~~== See Also ==~~
−
−	*[[Manuals/calci/~~COVAR~~ \| ~~COVAR~~]]
−
−	~~== References ==~~
−
−	*[http://en.wikipedia.org/wiki/Covariance Covariance]

@@ Line 19: / Line 19: @@
 *If <math>NewTableFlag</math> is TRUE, output is displayed on a new ZSpace cube. If <math>NewTableFlag</math> is FALSE, output is displayed on the same spreadsheet where command is written.
 *If data is invalid, Calci displays NaN error message.
 == Examples ==

@@ Line 152: / Line 152: @@
 |}
 </div>
 == See Also ==

@@ Line 21: / Line 21: @@
 == Examples ==
 <div id="5SpaceContent" class="zcontent" align="left">
@@ Line 81: / Line 82: @@
 ----
 <div id="2SpaceContent" class="zcontent" align="left">