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:

- Using the RSQ function to calculate R-Squared directly
- 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

- In any empty cell, type the formula
**=RSQ()** - Between the parenthesis, enter the arguments. In my case, I’m entering two ranges of data, under
**x**and**y**, in my chart. - 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

- In any cell, type the formula
**=CORREL()** - Between the parenthesis, enter the arguments. In my case, I’m entering two ranges of data under
**x**and**y**. - Press
**Enter**. This is the r value. - In another cell, square the r-value by referencing that cell. The formula to calculate the R-Squared is:
`r^2`

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