For each data point, you can calculate the residuals or errors,
for
.
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
This is called the
Sum of Squared Errors (SSE) .
Using calculus, you can determine the values of
and
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 thatthe line of best fit has the equation:
where
and
are the sample means of the
values and the
values, respectively. The best fit line always passes through the point
.
and
where
= the standard deviation of the
values and
= the standard deviation of the
values.
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 .
Using the summary statistics and correlation coefficient for the relationship between third exam score and final exam score we will calculate the regression equation, the line of best fit.
Start by calculating the slope of the line.
Using the slope find the u-intercept.
The least squares regression line (best fit lint) for the third exam/final exam example has the equations:
Third exam vs final exam example:
The graph of the line of best fit for the third exam/final exam example is shown below:
Remember, it is always important to plot a
scatter diagram first. If the scatter plot indicates that there is a linear relationship betweenthe variables, then it is reasonable to use a best fit line to make predictions for
given
within the domain of
-values in the sample data,
but not necessarily
for
-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.
Third exam vs final exam example
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.
Receive real-time job alerts and never miss the right job again
Source:
OpenStax, Collaborative statistics using spreadsheets. OpenStax CNX. Jan 05, 2016 Download for free at http://legacy.cnx.org/content/col11521/1.23
Google Play and the Google Play logo are trademarks of Google Inc.
Notification Switch
Would you like to follow the 'Collaborative statistics using spreadsheets' conversation and receive update notifications?