How to find r-squared in excel scatter plot

R-squared, often written as r², is a measure of how well a linear regression model fits a dataset.

In technical terms, it is the proportion of the variance in the response variable that can be explained by the predictor variable.

The value for r² can range from 0 to 1:

• A value of 0 indicates that the response variable cannot be explained by the predictor variable at all.
• A value of 1 indicates that the response variable can be perfectly explained without error by the predictor variable.

Related: What is a Good R-squared Value?

This tutorial explains how to calculate r² for two variables in Excel.

Example: Calculating R-Squared in Excel

Suppose we have the following data for the number of hours studied and the exam score received for 20 students:

Now suppose we are interested in fitting a simple linear regression model to this data, using “hours” as the predictor variable and “score” as the response variable.

To find the r² for this data, we can use the RSQ() function in Excel, which uses the following syntax:

=RSQ(kn