00:01
So we have a set of data where x is standing for our expenditures in advertising, and this is our total sales, i believe.
00:10
And so we have a 10, 15, 7, 12, and 14, and then we have 100, 280, 120, and 150.
00:22
And i'm going to leave the graphing for you, and we need to find what the correlation coefficient is.
00:27
And if we do this longhand, that means we have to determine what the mean is of that mean and standard deviation is for each of those two lists.
00:37
And we find that the mean of the x's is 11 .6 and the standard deviation is 3 .209.
00:47
And for our y values, we have the mean as 130 and the standard deviation is 46.
00:57
0 .904, 46 .904.
01:01
And so we know we would find what the x minus each x minus the x bar.
01:08
And i'm going to actually do this all in one list and the y minus the y bar.
01:15
And then we'll be adding those up.
01:17
So when i do this, here's my list one, my list two, and this is my list three.
01:22
And so when i go into my spreadsheet, i'm actually going to be up in list three, and i'm going to type in a left parenthesis and then list one minus the x bar, which is at 11 .6, and then times, and then a left parentheses, and then my list two minus the mean, which is 130.
01:47
And then i'm going to hit enter.
01:49
And it's going to go through and tell me this first product is 48.
01:53
And let me quick write these down for you.
01:56
And this is 238...