Difference between revisions of "Manuals/calci/COVARIANCE"

Latest revision as of 22:18, 8 February 2017

Refer the page

COVARIANCEDATAANALYSIS

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+Refer the page
-'''COVARIANCENDATAANALYSIS'''(Array,GroupBy,  NewTableFlag)
+*[[Manuals/calci/COVARIANCEDATAANALYSIS| COVARIANCEDATAANALYSIS]]
-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>
-----

Difference between revisions of "Manuals/calci/COVARIANCE"

Latest revision as of 22:18, 8 February 2017

Navigation menu

Search