Manuals/calci/RSQ
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 |