00:01
So here is your rock surface area and your algae density, and we're going to find the least squared regression lines.
00:09
So we're going to use equals l -i -n -e -s -c -lin.
00:33
And then it wants our y values, then our x values, and we're going to calculate the b constant normally.
00:51
I'm using excel, because that's what i have available to me to do that.
00:59
Oh, and let's make these bigger because you need like five decimal places.
01:03
The cool thing about excel is it adjust as you adjust how big it is.
01:07
So the least squared regression line would be y hat equals negative 2 .92036.
01:19
Oops.
01:25
92036.
01:26
And i think you had that on there and it was good.
01:37
Yes.
01:40
And then time fax.
01:46
Plus 230 .87255.
01:56
I'm rounding it to two decimal places.
02:00
And so yours was just off by a little bit at that five decimal places.
02:09
Okay.
02:10
It looks like you found the r squared okay and did the interpretation of that right.
02:15
But you had trouble with calculating the standard error of the residuals.
02:20
So i'm going to do it the long way because you can do this on any trouble.
02:24
Calculator or excel or anything.
02:27
Excel does have a data analysis that's available that will like just spit everything out for you.
02:35
But since you got the correlation and all of that good and the r square good, let's just do this.
02:44
So let's cut this.
02:48
Let's put it up here.
02:50
So what we're going to do is we're going to take the ys minus the y hats and so square them.
02:59
Okay, but first i need some y hats.
03:01
Let's make a y hat list.
03:05
So y hat is just the predicted value from the least squared regression line.
03:14
So this would be the predicted value of algae density given a certain rock surface area.
03:22
So this is what i do to calculate my y hats.
03:24
I'm going to do equals.
03:26
And then i'm going to oh, just a minute, sorry.
03:37
I'm not going to do equals.
03:38
I'm going to go over here, and i'm going to copy my line, and then i'm going to come over here and put it in here.
03:47
And then instead of x, i'm going to put undo.
04:03
Okay, fine...