Excel Instructions: Linear Regression
To do that in Excel:
- Right-click on one of the points in the graph and choose Add Trendline from the pop-up menu.
- Make sure that the Trendline Options tab is selected in the Format Trendline menu box displayed on the right, and then scroll down and check the boxes next to Display Equation on chart and Display R-squared value on chart.
- Click the X button on the menu window to close it.
(You should see a graph window with the scatterplot and the regression line plotted on it. The regression line equation appears on the graph next to the line itself.)