00:01
We got some data that was collected from a sample of n equals 10 incarcerated women.
00:11
And they were surveyed about their aces score and their ipv score.
00:16
So where aces, it's a way of measuring childhood, adverse childhood experiences.
00:23
And ipv stands for intimate partner violence.
00:29
So this is childhood here and this is more adult.
00:32
And what we're looking at is if there's looking to regress ipv on aces meaning we're going to make a model y hat that predicts ipv based upon your aces score so y hat is equal to beta hat naught plus beta hat 1x where x is your aces score put your aces score in run through the model and then it will give you an an ipv score, it's your predicted score.
01:04
We're gonna do that.
01:06
And we're gonna do that in excel.
01:08
So let's go ahead and go through that.
01:10
And a little note on the notation here.
01:12
I wrote beta hat not, you might see it as a, the main thing, however you notate that, it's the interceptor.
01:22
And then you might see like, beta hat not, it's the same thing.
01:28
Beta hat one, you might see this as just b, but regardless this is the slope of that coefficient, or the slope of that term.
01:37
Alright let's go ahead and run this in excel.
01:40
So this is what we have.
01:41
Here's the data.
01:43
We go to data and you go to data analysis.
01:49
This window and you want to go to regression.
01:52
That's okay.
01:53
This is what you see and it says to select the y range.
01:57
So y is our variable, our y variable, the output.
02:02
Dependent variable and the x range, which is gonna be your independent variable.
02:08
And then we want, we do have labels, because we have aces and ipv.
02:13
Confidence level is 95, that's fine.
02:15
Output range, we're gonna send that right here.
02:24
And let's go...
