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()
Enter the RSQ Function. - Between the parenthesis, enter the arguments. In my case, I’m entering two ranges of data, under x and y, in my chart.
Enter the arguments. - Press Enter. This is the R-Squared value.
Calculating R Squared Value using RSQ Function.
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()
Enter the CORREL function. - Between the parenthesis, enter the arguments. In my case, I’m entering two ranges of data under x and y.
Squaring the r-value. - Press Enter. This is the r value.
Calculating the r-value. - In another cell, square the r-value by referencing that cell. The formula to calculate the R-Squared is:
r^2Squaring the r-value. - Press Enter. This is the R-Squared value.
Calculating R Squared Value by squaring the r-value.