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

2013-10-25T02:31:43Z

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

New page

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

'''CORRELATIONDATAANALYSIS'''(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">Compares two sets of data to determine if there is any relationship between them.</div>
----
<div id="7SpaceContent" class="zcontent" align="left">If array contains the text, then CORRELATIONDATAANALYSIS returns NaN.</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

CORRELATION

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

Lets see an example in (Column3, Row1)

<nowiki>=CORRELATIONDATAANALYSIS(R1C1:R2C2, "Columns",TRUE)</nowiki>

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

<nowiki>=CORRELATIONDATAANALYSIS(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="2SpaceContent" class="zcontent" align="left">

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

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

{| class="SpreadSheet blue"
|+ <br />Correlation by Columns
|- class="even"
!
! Column1
! Column2
|- class="odd"
| Column1
| 1
| 1
|- class="even"
| Column2
| 1
| 1
|}

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

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

</div>
----

Manuals/calci/CORRELATION - Revision history

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

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