Catherine Falls Commercial/Getty Images Linear regression is a type ... and then "Linear Trendline." To add the R 2 value, select "More Trendline Options" from the "Trendline" menu. Lastly, select ...
In addition to basic calculation functions, Excel also provides data analysis tools that allow you to find the R2 of two lines with an Excel formula. R2, or R-squared, is the relationship between two ...