Calculating a Least Squares Regression Line: Equation, Example, Explanation If you want a simple explanation of how to calculate and draw a line of best fit through your data, read on!

Learn how to graph linear regression in Excel. Use these steps to analyze the linear relationship between an independent and a dependent variable.

To do so, click the Line tool and then hold down the Shift key while you click and drag to insert the line. Doing so forces Excel to draw a straight line between the two clicked points.