Creating the Least-Squares Regression Equation

Learning Outcomes

  • Find the equation of the least-squares regression line using technology
  • Interpret the slope and y-intercept of a least-squares regression line

Data rarely fit a straight line exactly. Usually, you must be satisfied with rough predictions. Typically, you have a set of data whose scatter plot appears to “fit” a straight line. This is called a Line of Best Fit or Least-Squares Line.

Activity

If you know a person’s pinky (smallest) finger length, do you think you could predict that person’s height? Collect data from your class (pinky finger length, in inches). The independent variable, x, is pinky finger length, and the dependent variable, y, is height. For each set of data, plot the points on graph paper. Make your graph big enough and use a ruler. Then “by eye” draw a line that appears to “fit” the data. For your line, pick two convenient points and use them to find the slope of the line. Find the y-intercept of the line by extending your line so it crosses the y-axis. Using the slopes and the y-intercepts, write your equation of “best fit.” Do you think everyone will have the same equation? Why or why not? According to your equation, what is the predicted height for a pinky length of 2.5 inches?

Example 1

A random sample of 11 statistics students produced the following data, where x is the third exam score out of 80, and y is the final exam score out of 200. Can you predict the final exam score of a random student if you know the third exam score?

x (third exam score) y (final exam score)
65 175
67 133
71 185
71 163
66 126
75 198
67 153
70 163
71 159
69 151
69 159

Table showing the scores on the final exam based on scores from the third exam.

This is a scatter plot of the data provided. The third exam score is plotted on the x-axis, and the final exam score is plotted on the y-axis. The points form a strong, positive, linear pattern.

Scatter plot showing the scores on the final exam based on scores from the third exam.

try it 1

Scuba divers have maximum dive times they cannot exceed when going to different depths. The data in the table below show different depths with the maximum dive times in minutes. Use your calculator to find the least-squares regression line and predict the maximum dive time for 110 feet.

X (depth in feet) Y (maximum dive time)
50 80
60 55
70 45
80 35
90 25
100 22

The third exam score, x, is the independent variable and the final exam score, y, is the dependent variable. We will plot a regression line that best “fits” the data. If each of you were to fit a line “by eye,” you would draw different lines. We can use what is called a least-squares regression line to obtain the best-fit line.

Consider the following diagram. Each point of data is of the form (x, y) and each point of the line of best fit using least-squares linear regression has the form [latex]\left ( x, {\hat y} \right )[/latex].

The [latex]\displaystyle\hat{{y}}[/latex] is read “y hat” and is the estimated value of y. It is the value of y obtained using the regression line. It is not generally equal to y from data.

The scatter plot of exam scores with a line of best fit. One data point is highlighted along with the corresponding point on the line of best fit. Both points have the same x-coordinate. The distance between these two points illustrates how to compute the sum of squared errors.

The term [latex]\displaystyle{y}_{0}-\hat{y}_{0}={\epsilon}_{0}[/latex] is called the “error” or residual. It is not an error in the sense of a mistake. The absolute value of a residual measures the vertical distance between the actual value of y and the estimated value of y. In other words, it measures the vertical distance between the actual data point and the predicted point on the line.

If the observed data point lies above the line, the residual is positive, and the line underestimates the actual data value for y. If the observed data point lies below the line, the residual is negative, and the line overestimates that actual data value for y.

In the diagram above, [latex]\displaystyle{y}_{0}-\hat{y}_{0}={\epsilon}_{0}[/latex] is the residual for the point shown. Here the point lies above the line and the residual is positive.

ε = the Greek letter epsilon

For each data point, you can calculate the residuals or errors,
[latex]\displaystyle{y}_{i}-\hat{y}_{i}={\epsilon}_{i}[/latex] for i = 1, 2, 3, …, 11.

Each |ε| is a vertical distance.

For the example about the third exam scores and the final exam scores for the 11 statistics students, there are 11 data points. Therefore, there are 11 ε values. If you square each ε and add, you get

[latex]\displaystyle{({\epsilon}_{{1}})}^{{2}}+{({\epsilon}_{{2}})}^{{2}}+\ldots+{({\epsilon}_{{11}})}^{{2}}={\stackrel{{11}}{{\stackrel{\sum}{{{}_{{{i}={1}}}}}}}}{\epsilon}^{{2}}[/latex]

This is called the Sum of Squared Errors (SSE).

Using calculus, you can determine the values of a and b that make the SSE a minimum. When you make the SSE a minimum, you have determined the points that are on the line of best fit. It turns out that the line of best fit has the equation:

[latex]\displaystyle\hat{{y}}={a}+{b}{x}[/latex]

where
[latex]\displaystyle{a}=\overline{y}-{b}\overline{{x}}[/latex]

and

[latex]{b}=\dfrac{{\sum{({x}-\overline{{x}})}{({y}-\overline{{y}})}}}{{\sum{({x}-\overline{{x}})}^{{2}}}}[/latex].

The sample means of the x values and the y values are [latex]\displaystyle\overline{{x}}[/latex] and [latex]\overline{{y}}[/latex]. The best-fit line always passes through the point [latex]\left ({\overline x},{\overline y} \right )[/latex].

The slope b can be written as [latex]\displaystyle{b}={r}{\left(\dfrac{{s}_{{y}}}{{s}_{{x}}}\right)}[/latex] where sy = the standard deviation of the y values and sx = the standard deviation of the x values. r is the correlation coefficient, which is discussed in the next section.

Least Squares Criteria for Best Fit

The process of fitting the best-fit line is called linear regression. The idea behind finding the best-fit line is based on the assumption that the data are scattered about a straight line. The criteria for the best-fit line is that the sum of the squared errors (SSE) is minimized, that is, made as small as possible. Any other line you might choose would have a higher SSE than the best-fit line. This best-fit line is called the least-squares regression line.

Note

Computer spreadsheets, statistical software, and many calculators can quickly calculate the best-fit line and create the graphs. The calculations tend to be tedious if done by hand. Instructions to use the TI-83, TI-83+, and TI-84+ calculators to find the best-fit line and create a scatterplot are shown at the end of this section.

Example 2

Third Exam vs Final Exam Example

The graph of the line of best fit for the third-exam/final-exam example is as follows:

The scatter plot of exam scores with a line of best fit. One data point is highlighted along with the corresponding point on the line of best fit.

The least-squares regression line (best-fit line) for the third-exam/final-exam example has the equation:

[latex]\displaystyle\hat{{y}}=-{173.51}+{4.83}{x}[/latex]

 

Remember, it is always important to plot a scatter diagram first. If the scatter plot indicates that there is a linear relationship between the variables, then it is reasonable to use a best-fit line to make predictions for y given x within the domain of x-values in the sample data, but not necessarily for x-values outside that domain. You could use the line to predict the final exam score for a student who earned a grade of 73 on the third exam. You should NOT use the line to predict the final exam score for a student who earned a grade of 50 on the third exam, because 50 is not within the domain of the x-values in the sample data, which are between 65 and 75.

Understanding Slope

The slope of the line, b, describes how changes in the variables are related. It is important to interpret the slope of the line in the context of the situation represented by the data. You should be able to write a sentence interpreting the slope in plain English.

Interpretation of the Slope: The slope of the best-fit line tells us how the dependent variable (y) changes for every one-unit increase in the independent (x) variable, on average.

For example 2:

  • Slope: The slope of the line is b = 4.83.
  • Interpretation: For a one-point increase in the score on the third exam, the final exam score increases by 4.83 points, on average.

USING THE TI-83, 83+, 84, 84+ CALCULATOR

Using the Linear Regression T Test: LinRegTTest

  1. In the STAT list editor, enter the X data in list L1 and the Y data in list L2, paired so that the corresponding (x,y) values are next to each other in the lists. (If a particular pair of values is repeated, enter it as many times as it appears in the data).
  2. On the STAT TESTS menu, scroll down with the cursor to select the LinRegTTest. (Be careful to select LinRegTTest, as some calculators may also have a different item called LinRegTInt).
  3. On the LinRegTTest input screen enter: Xlist: L1 ; Ylist: L2 ; Freq: 1
  4. On the next line, at the prompt β or ρ, highlight “≠ 0” and press ENTER
  5. Leave the line for “RegEq:” blank
  6. Highlight Calculate and press ENTER.

1. Image of calculator input screen for LinRegTTest with input matching the instructions above. 2.Image of corresponding output calculator output screen for LinRegTTest: Output screen shows: Line 1. LinRegTTest; Line 2. y = a + bx; Line 3. beta does not equal 0 and rho does not equal 0; Line 4. t = 2.657560155; Line 5. df = 9; Line 6. a = 173.513363; Line 7. b = 4.827394209; Line 8. s = 16.41237711; Line 9. r squared = .4396931104; Line 10. r = .663093591

The output screen contains a lot of information. For now, we will focus on a few items from the output and will return later to the other items.

The second line says y = a + bx. Scroll down to find the values a = –173.513, and b = 4.8273; the equation of the best-fit line is ŷ = –173.51 + 4.83x.

The two items at the bottom are r2 = 0.43969 and r = 0.663. For now, just note where to find these values; we will discuss them in the next two sections.

Graphing the Scatterplot and Regression Line

  1. We are assuming your X data is already entered in list L1 and your Y data is in list L2
  2. Press 2nd STATPLOT ENTER to use Plot 1
  3. On the input screen for PLOT 1, highlight On, and press ENTER
  4. For TYPE: highlight the very first icon which is the scatterplot and press ENTER
  5. Indicate Xlist: L1 and Ylist: L2
  6. For Mark: it does not matter which symbol you highlight.
  7. Press the ZOOM key and then the number 9 (for menu item “ZoomStat”) ; the calculator will fit the window to the data
  8. To graph the best-fit line, press the “Y=” key and type the equation –173.5 + 4.83X into equation Y1. (The X key is immediately left of the STAT key). Press ZOOM 9 again to graph it.
  9. Optional: If you want to change the viewing window, press the WINDOW key. Enter your desired window using Xmin, Xmax, Ymin, Ymax

Note

Another way to graph the line after you create a scatter plot is to use LinRegTTest. Make sure you have done the scatter plot. Check it on your screen. Go to LinRegTTest and enter the lists. At RegEq: press VARS and arrow over to Y-VARS. Press 1 for 1:Function. Press 1 for 1:Y1. Then arrow down to Calculate and do the calculation for the line of best fit. Press Y = (you will see the regression equation). Press GRAPH. The line will be drawn.”