00:01
This is a question about ornithologists.
00:06
It says percent return and percent new.
00:10
So i'm going to copy and paste this into google sheets here.
00:18
There's the percent return.
00:21
And then the percent new, i think i'm just going to go like this, percent new there.
00:32
All right.
00:38
So now i want to, i think i'm just going to type this in.
00:44
74, 66, 81, 52, 73.
01:06
Okay, so that's the percent return.
01:11
And then this will be new here.
01:26
Okay, so i'll put the new ones in.
01:28
5, 6, 8, 11, 12, 15, 16, 17, 17, 18, 18, 19, 19, 19, 20, 20.
01:41
All right.
01:47
So now let's answer the questions.
01:50
A, make a scatter plot.
01:56
So we highlight, insert, chart, and hey, look at that.
02:06
It made a scatter plot immediately.
02:08
That's the first time that's happened.
02:10
Okay.
02:15
Use the regression function to find the equation of the line.
02:22
So double click on this and then over here, i can scroll down and go to trend line and display r squared because i know we're going to need that and use equation.
02:39
Okay, so our equation is right here and the r squared value is here.
02:46
Now, i think it's going to ask us for the r value.
02:49
The r value is the square root of the r squared value, which is 0 .56.
02:57
So 0 .75.
03:04
Okay, let's see here.
03:12
What do the slope and y intercept tell us? well, let's think about what's going on here.
03:19
Ornithologists are studying birds.
03:23
They tag them.
03:33
Okay.
03:35
So, this indicates the number of birds who have returned versus the number of new sparrows.
03:55
So the slope, which is negative 0 .304, indicates how the number of new sparrows changes with respect to the number of returning sparrows...