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