00:01
In this exercise we find the equation of the regression line for the given data.
00:06
So in the first row we have some values for temperatures, and in the second row we have the associated absences.
00:15
So we want to create a regression line that predicts the number of absences from the temperature.
00:22
And such a line has this form.
00:26
Beta -naught is the y -intercept, and beta -one is the slope.
00:31
And they can be solved using these equations, where s -sub -xy is calculated as follows, and s -sub -xx is calculated as follows.
01:17
This is pretty computationally intensive to do by hand, so let's go ahead and do this using excel.
01:25
So in my excel spreadsheet i've gone ahead and put the x -values in column a, and the y -values, the absences, in column b.
01:36
We start a computation in excel with an equal sign...