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.

You can use Microsoft Excel to calculate the loan-to-value ratio if you have the mortgage amount and appraised value of the property.