How to Find R-Squared in Google Sheets

R-Squared (R²) is a measure of correlation that measures the proportion of change in the dependent variable that can be attributed to the independent variable. It can take any value between 0 to 1. R-Squared is calculated to perform regression analysis. Google Sheet comes with a built-in function to calculate the R-Squared.

There are two methods to find R-Squared in Google Sheets:

1. Using the RSQ function to calculate R-Squared directly
2. Using the CORREL function, then squaring the resultant value

Using the RSQ function on Google Sheets

R-Squared can be directly calculated using the RSQ function.

Syntax

RSQ(data_y, data_x)

Arguments

• data_y is the range of dependent data.
• data_x is the range of independent data.

Steps

1. In any empty cell, type the formula =RSQ()

   

2. Between the parenthesis, enter the arguments. In my case, I’m entering two ranges of data, under x and y, in my chart.

   

3. Press Enter. This is the R-Squared value.

   

Using the CORREL function on Google Sheets

R-Squared can be calculated by squaring the r value. To calculate the r-value, you can use the CORREL function.

Syntax

CORREL(data_y, data_x)

Arguments

• data_y is the range of dependent data.
• data_x is the range of independent data.

Steps

1. In any cell, type the formula =CORREL()

   

2. Between the parenthesis, enter the arguments. In my case, I’m entering two ranges of data under x and y.

   

3. Press Enter. This is the r value.

   

4. In another cell, square the r-value by referencing that cell. The formula to calculate the R-Squared is:

   r^2

   

5. Press Enter. This is the R-Squared value.