|
|
| (4 intermediate revisions by 2 users not shown) |
| 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>
| |
| − | ----
| |