RSQ(known_y's, known_x's)

Returns the square of pearson product moment correlation coefficient through data points in known y's and known x's.

known_y'sThe array of data points.
known_x'sThe array of data points.

* The arguments must be either numbers or names, arrays, or references that contain numbers.
* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
* If "known_y's" and "known_x's" are empty or have a different number of data points, then #N/A is returned.
* For more information, see the PEARSON function. The r-squared value can be interpreted as the proportion of the variance in y attributable to the variance in x.
* For the Microsoft documentation refer to
* For the Google documentation refer to

1=RSQ({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4}) = 0.058
2=RSQ({1, 2, 3}, {1, 2}) = #N/A

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top