00:01
The following is a solution for number 44, and we're looking at the weight of, i can't remember what it is, helmets or something, and then the price, and we're going to see if there's any sort of relationship here.
00:12
And so first thing we're supposed to do is to make a scatter plot.
00:15
So let's go to insert, and i'm going to do all this on excel because that's what this lesson is about.
00:19
So insert and then scatter plot, and there you see, it seems like it's a pretty nice relationship there.
00:25
Go ahead and double click.
00:26
You can pretty this up as much as you want.
00:29
Maybe go to like from 40 to 70 i guess you know you can see a little bit better there you can even go to 45 if you really wanted to so 45 right and you know you can add titles and whatnot so that's good enough and you can even add a trend line so linear so that appears to be a pretty good fit so that'll come up come in a little bit later so that's the first thing you're going to do and then the second question or part b is this a does there seem to be a relationship.
01:01
So this is part a, right, part a, and then part b, yes, relationship, it appears to be a negative relationship.
01:08
So as the x independent variable, as the weight increases, the price tends to decrease there.
01:14
So now we're going to do the regression lines.
01:16
This is part c.
01:17
So get the actual equation here.
01:21
And what we're going to do is we're going to go to data and then data analysis and we'll type in regression there.
01:27
And the y input is the price.
01:29
So i want to from b2 to b19, and then the x input is from a2 to a19.
01:34
Now i went ahead and made a residual plot just to kind of look at it, but you don't have to because we haven't actually learned that yet, but that kind of helps me.
01:40
And so you see here the r square is 0 .77, which is pretty good.
01:46
That's pretty high r squared.
01:49
That means you can explain 77 .4 % of the variation in y by the x value.
01:56
And here you see residual plot, so you don't want to see a pattern there.
02:00
Which you'll learn about in next lesson.
02:01
So we don't see a pattern there.
02:02
So this seems to be a pretty good fit.
02:04
And the regression line is this coefficient here.
02:07
So if we make this bigger, so coefficients.
02:10
So the intercept, so this would be part c...