00:01
All righty guys, so for this one here, we're going to look at this data set.
00:07
And i started by opening a google sheet here.
00:12
And this google sheet will help me analyze my dataset.
00:15
So here we go.
00:17
Looks like my data set reads this way.
00:20
So that's my x, there's my y.
00:22
And i'll go ahead and type in all my numbers here in my google sheet.
00:27
Let's take a little bit longer, but this does take time in the long run, trust me.
00:32
There's a lot of the hard work for you.
00:33
All you do is the easy work of plugging things in, and it'll do the hard work for you.
00:43
My y's in.
00:47
Double check at the end to make sure that i got everything right.
00:51
Okay, looking good so far.
00:56
Okay, it's always annoying if you type everything in and find a mistake.
01:01
Okay, yeah, that's fine, i guess.
01:03
It didn't include the point zero, but that's okay.
01:05
Okay, perfect, so i've typed my data in.
01:07
And my next job is to find a scatter plot and compute the linear correlation coefficient.
01:12
Let's go and do that.
01:13
All right.
01:14
So for my scatter plot, i'm going to highlight all my data on the google sheet and do insert chart.
01:23
And there it goes.
01:25
Okay, so there is my chart right there.
01:30
And let's see.
01:31
I would go ahead and copy that down because it's going to change, guys.
01:35
That chart's going to change when i add the extra letter.
01:38
So for part a, the linear correlation coefficient.
01:43
Efficient.
01:49
Let's go and do that.
01:50
The way you do that in a google sheet, very simple.
01:52
You're going to write the, you open a new cell, do the equals symbol.
01:56
And you write six letters c -o -r -r -e -l, and then open parentheses.
02:02
When you open parentheses, you highlight all your explanatory variables.
02:06
In this case, the x...