Manuals/calci/RSQ

From ZCubes Wiki
Revision as of 20:43, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">'''RSQ'''</font></font><font face="Arial, sans-serif"><font size="2">(</f...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 RSQ(ky's,kx's)

Where ky's   is an array or range of data points and kx's   is an array or range of data points.


   It calculates the square of the Pearson product moment correlation coefficient through data points in ky's and kx's. 

RSQ


 

i.e.RSQ(Column1 Row 1:Column1Row8, Column2 Row 1:Column2Row8)

i.e.=RSQ(C1R1:C1R8,C2R1:C2R8)

=0.6002


Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1 4 16 0.6002
Row2 6 15
Row3 7 10
Row4 5 17
Row5 9 8
Row6 0 14
Row7
11
1
Row8
Row9
Row10