Spread the loveIn statistics, the correlation coefficient, denoted as ‘r’, is a measure that helps us understand the strength and direction of the relationship between two variables. Microsoft Excel, ...

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.