Formulas > =RSQ()
How to Use RSQ() in Google Sheets
Description
How To Actually Use RSQ() in Sheets
RSQ(data_y, data_x)
Try RSQ yourself
Use the RSQ formula to calculate the square of the correlation coefficient for the data in the ranges A1:A10 and B1:B10. The correct answer must return a numeric value representing the correlation.
Hints (2)
-
Make sure to reference the correct ranges for both data sets.
-
Remember that the first argument is the dependent variable.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the RSQ() formula:
Generate a RSQ() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses RSQ(). 2 free AI generations, no signup. Members get unlimited use.
Generate a RSQ() formula