00:01
All right, so i am showing the data that's written in numerate here.
00:10
So i want to use year as the independent variable, and i want to draw a scatter plot.
00:21
So insert, chart.
00:29
I need to change this chart to a scatter plot.
00:38
So where is it here? series year.
00:48
Why can i? all right.
00:54
What am i missing here? oh, there we go.
00:59
It's up higher.
01:06
Okay.
01:07
All these numbers are really close to 62.
01:12
So i'm going to change my scale.
01:17
Minimum value.
01:19
I guess i'll just make it 60.
01:23
And let's do 63 is fine.
01:27
Okay, so there we go.
01:33
Now i'm going to add a trend line, double click on this, trend line, show r squared value, use the equation.
01:44
So here we have the equation and the r squared value.
01:48
The r value is going to equal the square root of 0 .869, which is 90 .93.
01:59
This is actually a pretty strong correlation, even though the difference doesn't look like it's very great.
02:10
So let's see if we answered part a.
02:14
Yes.
02:18
It does appear that there's a relationship once i zoomed in.
02:22
When i was zoomed out, it wasn't clear that there was a relationship, but once i zoomed in, it is clear.
02:34
So we calculated the line.
02:36
It's right there.
02:40
The correlation coefficient is, is significant.
02:47
Estimate 1991 and 1988.
02:51
Well, 1988 is here.
02:54
That's about 62 .4.
02:59
Just reading it off the graph.
03:06
And what was the other one? 1991...