Here, we look at how to use data imported into Microsoft Excel to perform a linear regression and ... To add the R 2 value, select "More Trendline Options" from the "Trendline" menu. Lastly, select ...

R-squared values range from 0 to 1, indicating the fit and explanatory power of a regression model. Values below 0.3 suggest weak explanatory power; above 0.7 indicate strong relationships. In finance ...