00:01
We're going to do question 43 of chapter 15.
00:06
So a disclaimer, data is not provided for 2014, so we're just going to use the data for 2005.
00:14
If you're using the data from 2014, then the process is going to be pretty much the same.
00:23
So this is the data that we're going to use.
00:28
Part a, we're just going to regress with excel, and this is the result for coefficient that we got, and from this coefficients table, we get the regression equation as this.
00:45
And now we define y as scoring, average, and x1 as green in reg, x2 as putting average.
01:00
Part b, so this is a plot for standardized residual versus the predicted value.
01:07
And we can see that the sum of the standardized residual is less than negative 2 or greater so we may speculate the doubt in the assumption of epsilon.
01:24
So this is the standardized residual results that we got from excel.
01:30
And you can get this result by checking standardized residual option in excel regression before you regressed that data.
01:40
So that's the standardized residual...