Calculate R-squared in Microsoft Excel by creating two data ranges to correlate. Use the correlation formula to correlate both sets of data, or x and y.

R-squared is a statistical measure that represents the proportion of the variance for a dependent variable that’s explained by an independent variable.