Manuals/calci/RSQ

RSQ (Array1,Array2)


  • is the array of y values.
  • is the array of x values.
    • RSQ(), returns the square of the Pearson product moment correlation coefficient.


Description

  • This function gives the square of Pearson Product Moment Correlation Coefficient.
  • This function is calculated using the data points of   and   values.
  • The formula for PPMC,   is defined by:

  where   and   are Average of the two Samples   and  .

  • This function gives the value of  , which is the square of this Correlation Coefficient.
  • The square value can be interpreted as the proportion of the variance in   attributable to the variance in  .
  • In  , the value of   and   must be either numbers or names, array, constants or references that contain numbers.
  • Suppose the array contains text, logicl values or empty cells, like that values are not considered.
  • This function will return the result as error when
1.   and   are empty or having the different number of data points.
2. The arguments having only one data point.
3. The arguments that are error values or text that cannot be translated in to numbers.

Refer PEARSON for more details.

Examples

Spreadsheet
A B C D E F G H
1 12 10 17 21 25 31 19 5
2 4 37 8 18 0 13 15 41
3 9 7 23 11 22 30 6 15
4 50 47 26 13 20 14 33 1
5 4 17 25 44 2 9 -1
6 18 36 40 11
  1. =RSQ(A1:A6,B1:B6) = 0.4003286578
  2. =RSQ(C1:C6,D1:D6) = 0.02320694105
  3. =RSQ(E1:H1,E2:H2) = 0.72060025461
  4. =RSQ(E3:E5,G3:G5) = 0.346037364910
  5. =RSQ(G3:G5,H3:H4) = NAN

Related Videos

RSQ

See Also

PEARSON

References

Pearson