00:01
After reading this is i need to put this data into excel.
00:04
So i have the age, which is x, and i have 38, 41, 45, 48, 58, 51, 51, 53, 57, 61, 65, and i'm just going to count three, six, nine.
00:31
Okay, perfect.
00:33
And then pressure, which is y.
00:37
And 65, 75, 60, 80, 66, 78, 85, 85, 78, 85, 95, and 90.
00:56
So i'm going to just make these a little bit bigger, bold it.
01:04
Okay, and center.
01:07
So it says to determine the linear correlation coefficient between the age and systolic blood pressure, show your work.
01:15
So in order to do that, i'm going to use excel, and i click on tools, and then i click on data analysis, and then i'm going to find correlation coefficient, and i'm going to highlight the numbers and click okay, and i'm going to just copy this and go back to the sheet.
01:40
And so a, the correlation coefficient is 0 .795 -392 -1.
01:50
Then for b, does a linear relationship between the agent systolic blood pressure exist between the two? so if i do this, i'm going to insert a scatterplot.
02:09
And for this, there is a positive linear association.
02:23
It's a little bit on the weak side...