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.

Variance is a measurement of the spread between numbers in a data set.The variance measures how far each number in the set is from the mean.You can use Microsoft Excel to calculate the variance of ...