 Statistics and Excel. Correlation calculation with strange result. Get ready, taking a deep breath, holding it in for 10 seconds, looking forward to a smooth soothing Excel. Here we are in Excel. If you don't have access to this workbook, that's okay because we'll basically build this from a blank worksheet. But if you do have access, there's three tabs down below. Example, practice blank. Example, in essence, answer key, practice tab, having pre-formatted cells so you can get to the heart of the practice problem. The blank tab, it's a blank worksheet so we can practice formatting these cells within Excel as we work through the practice problem. Let's go to the example tab to get an idea of where we will be going, what we will be doing. We're looking at correlations once again, two different data sets to see if there's a mathematical relationship or correlation between them are the data points moving in alignment with each other to some degree. And if there is a mathematical relationship, the next logical question would be, is there a cause and effect relationship? If there is a cause and effect relationship, the next logical question would be, what is the causal factor in that relationship? This time we're looking at some two generic data sets with few data points so we can focus in on the heart of what we're looking at, which is the unusualness of the results of this particular scenario. And we'll do our normal kind of calculations for the correlation and we'll get a result that's a little bit less than what we would expect from it, the point being that we can't depend totally on any kind of statistics or one statistical calculation generally. We still have to analyze what is happening so that we can get the most out of whatever data that we are looking at. So let's go back to the blank tab and build this out. So I'm going to first format the entire worksheet by selecting the triangle up top, right clicking on the selected cells. We're going to format those cells as we do every time. I like to make it currency, negative numbers bracketed and red, no dollar signs, no decimals to start off with. We're doing our generic data. I'm going to say control up and scroll in a bit. Generic data. So I'm just going to call it x and y, x and y. Let's make the whole thing bold too, because I like to be bold, not all the time, but just when home tab font group bold when you're recording. That's what my producer tells me. You've got to be bold when you're doing your screencast. So we're going to go to the home tab. Let's go to the home tab alignment, center this. Let's also hit the drop down and make this black and white. All right. And then so there we have it. And I can make them a skinnier. Let's make these skinnier too. We don't need it that wide because we're just going to have some numbers in there. And then we'll list this thing out. So the first data set is just going to be one, two, three, four, five and then zero. And the second data set is going to be one, two, three, four, five and seven. So if you were to look at these two data sets and you're trying to say, is there a mathematical relationship between them, just looking at the two data sets, you would say, well, it looks like kind of they are moving together for much of the process here. So that would be our general sense if we were just to take a look at the data. Let's do the calculations with it. Let's make a skinny C over here. skinny C. There it is. And let's copy over the X and the Y headers X tab. This equals the Y tab format paint. Let's just format paint this one over home tab clipboard format painter paint that on over here and do our mean calculation and our standard D. And so this is first one's going to be equal to the average just like we've seen before. So I'll do it fairly quickly because this is not new stuff. If you've seen some of our prior practice problems on this, and if you haven't, then you should go take a look because they are excellent. And then we go to the home tab, we go to the number group. Let's decimalize this thing. Let's just copy it to the right this time with the fill handle dragging that fill handle to the right, which will format it and give us the relative formula. Let's do the standard D now standard D for the sample standard D dot s. So this is going to be tab picking up the X data control shift down enter decimalizing it home tab number group decimalize fill handle grabbing that fill handle dragging the fill handle to the right and the standard D for Y calculating as you can see. Let's go ahead and select these two cells up top and skinnerize them skinnerizing the cell and then we will copy over our correlation formula. So we'll do our correlation calculation right here. So we'll bring this down and put it right there so we can see what we are doing.