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.

Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.