Linear Regression (Best-Fit Line) Using Excel 2007

From linear regression (line of best fit) using Excel (2007). You use Microsoft Excel to different graphs to make this semester. This tutorial is ….

More PDF Content

Now that you know what Excel looks like, let\’s dive right in and get to work. But first, this is college and we do not simply connect the dots”when we make a graph – we do linear regression which generates a line that fits among the points. Let’s say that you have some XY data and would like to make a graph and you need a best-fit line. First thing first, enter the data into the appropriate columns placing your x-axis data first and y-axis data second.
Now you want to click on the Chart Wizard button to bring up a list of possible graph types. We will, for the most part, be using XY scatter plots. The most common mistake made by students is choosing the Line graph – so don’t do it!!! Right. Go ahead and click on Insert then choose the scatter option and finally the graph with no line on it.

Download Linear Regression (Best-Fit Line) Using Excel 2007 pdf from www2.selu.edu, 3 pages, 12.3KB.
Related Books

4 Responses to “Linear Regression (Best-Fit Line) Using Excel 2007”

  1. May I simply just say what a relief to uncover somebody that really understands what they’re discussing online. You actually understand how to bring an issue to light and make it important. More and more people really need to look at this and understand this side of the story. I was surprised that you aren’t more
    popular given that you definitely have the gift.

Leave a Reply