Functions
RSQ
R-squared of linear regression
Try it
When to use it
When should I use RSQ?
Use RSQ to measure how well a linear regression model fits your data; it returns the square of the Pearson correlation coefficient so you can assess the proportion of variance in y explained by x.
Used in
Syntax
RSQ(known_y,known_x)Examples
=RSQ({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) // => 0.05795019157088121