00:02
Okay, so the problem is you didn't give us your data to work with.
00:07
So i don't have your data for biomes and can give you the specifics.
00:13
However, i can still show you how to find a least squared regression line and the y intercept in excel.
00:20
So i'm going to do everything in excel using this data that i have that has weight and backpack weight.
00:28
So my weight of students is going to be x, and their backpack weight is going to be y.
00:36
All right.
00:37
So what i'm going to do in excel is i'm going to highlight my data, my x and y data, and always make sure your x is on the left -hand side.
00:46
It just makes things easier.
00:49
And then i'm going to draw a scatterplot.
00:52
Now i'm going to adjust this just a little bit, so we can get a better look at it.
00:57
0 to 200.
00:59
We don't need to go that far.
01:00
Let's say like 75.
01:05
And then this one will change a little.
01:12
0 to 40.
01:15
Let's say 15.
01:20
Okay.
01:21
So we have a least squared scatter plot here.
01:27
Now we want to add a trend line.
01:31
So we're going to go here and we're going to add a trend line.
01:35
That is your least square.
01:37
Where it's regression line...