# 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.

Phoebe is an HR assistant in her day job, but is also a web blogger that loves writing guides and sharing her experiences. When she is not out with her friends, she enjoys traveling or binge-watching Netflix. She graduated with a BA in Communication and Media Studies from the University of Utah, and is a chief editor at TechObservatory.