00:01
So for this problem, what i'm going to do is show how to do this using excel.
00:05
So i've copied the data into my excel spreadsheet here.
00:09
Then i'll go to the data tab, go to data analysis, and i'll want to go to regression.
00:14
Hit ok.
00:16
Then i input my data, the y range and the x range.
00:23
I am including labels, and i'll say this is for the...
00:28
This should actually be a 99 % confidence level.
00:31
Hit okay, and we get our summary output for our linear regression.
00:37
So the first thing for part d that we're interested in is this part of the output down here, where we have the intercept, the x, and the coefficients.
00:50
So from that, we'd have that y hat, our predicted y value, is going to be equal to the intercept, 5 .594, plus the x coefficient, 0 .1 .1 .4.
01:03
3131 times x our predictor variable.
01:08
So when we have that x equals 78, our prediction, y hat, is going to be equal to 5 .594 plus 0 .13131 times 78.
01:21
So you need to put in the equal sign.
01:23
So this actually calculates...