Now you can see the regression equation and R² value above the trendline. First highlight all of the values in column B and drag them to column C. To add the R 2 value select More Trendline Options from.
Next type in the formula A22 in cell B2.
On an Excel chart theres a trendline you can see which illustrates the regression line the rate of change. Click on the Data tab and Data Analysis. If you dont see this option then you need to first install the free Analysis ToolPak. Select the X Range B1C8.