 minus one without the colon, putting that in the outer column. This equals 205 minus one. Let's do some fancy indentations for the subcalculation. Select in these three, home tab, alignment, indent, and then I double indent in here. Home tab, alignment, and indent again. So that's our standard subcalculation colon. Representing there's going to be a subcalculation. We pull that into the center column and then we indented. And then when we finished the calculation to get to what we had with the subtitle, we put it on the outside. So now we have the numerator and the denominator and the outer column, which is a standard tax return kind of format, which may kind of turn you off with the tax return format. But it's actually a good strategy or format when you're trying to work through practice problems, even though taxes are not enjoyable for most people. So this is going to be the R or correlation. Maybe I should have put the R up first here. R correlation. And so we just divide that out because we got the numerator and the denominator, home tab, font group, underline. And let's just divide it out. Obviously, 204 divided by the 204 is one, but now it's negative one, which means now it's perfectly negatively correlated. And so that's what we would have, that's what we expect. So I was like, OK, perfect negative correlation, that makes sense. Now let's do the same thing with Excel just telling us it's negatively correlated. So to do that, I can go to the data, to the analysis. Now, if you don't have that analysis tool, remember you just go to the file tab. You go to the options. You go to the add-ins. You have the Excel add-ins. Go to that and then add the analysis tool pack, the super cool pack of tool. So then here we are. And if you don't have the tool pack, you are a tool. I don't even know. Anyways, correlation. Here's the correlation. We're going to say OK. And we'll find this one. And let's put this down. And we'll say, we're just going to take these two. I'm going to take the headers in, control shift down in our data. We have to have them side by this side. You can see I'm going to say backspace. I think I've got the right data, so it's still summing that up. Yes. All right. And then I'm going to say OK. And then labels checked off because I had the labels in there. So you have to have that if you included the labels when you summed it up or drew the location of where the thing is. That wasn't very well said, but I will leave it in. OK. And then where the thing is when you did the other thing, let's put it here and say OK. And then OK. So there we have it. So then it tells us it's perfectly negative correlated. I'll format this. Let's make some black and white, home tab, font group, black, white. Let's center it and wrap the text. OK, so that looks good. And then, of course, I'm just going to do that last analysis to let's put let's pull this underneath now. So we have room for our charts. Can nice go there nice and cozy like underneath. So they're not too far away from everything else and they feel like they're part of everything that's going on. They're not out in the distance in the cold. Let's also then do the other data analysis data analysis and do that descriptive statistics just to practice with that because it's a cool tool. It's a cool tool. Let's go same thing, same set of data, selecting the data. And then I'm going to say, where do we want to put it? I'll tell you where to put it. Excel, you put it right there. That's where you put it. That's where it goes. That's why you put it there. Summary statistics and then I'll do the confidence intervals, although we're not going to focus in on them now. OK, so then and then let's make this a little wider. Boom. And it gives you the mean, the standard error, the median, the mode, standard deviation. And that, of course, can give you some indications about the relationships between the data sets. But remember that this is kind of static data, so it's not dynamic. So if you can't change it as easily. So it's any case. Let's do it. Let's just format our stuff now like we normally do. I'm going to go all the way back to the beginning, control shift down. I'm going to make this blue, home tab, font group, make it border blue. If you don't have that blue, by the way, it's in the more color. You don't have to do this blue, by the way. It's that blue right there. You can color it whatever color you think is fine. Home tab, font group. I like the blue. I've grown up with the blue. The blue has, I find it has endeared my heart. And so I stick with it. Home tab, border blue. But that's just me. You can do whatever you want. I do enjoy other colors as well. Home tab, font group, blue, borders. And then let's do this one. I tend to like to use the other colors for other standardized areas, see? And so I have it all worked out in my logic system in my mind, which isn't always that logical. It has this plan of which colors are supposed to be where. And that's just so I just, that's why. But you don't have to follow that. And here we go. And then this one, home tab, font group, and black and white. Color coding is not my strong suit. It's not my strong suit. That's why I use the same colors, because then I don't have to think about it. Let's put some borders around that. Let's do a spell check on it, if we would. Check the spelling. Correlation, I can't spell that word. I can't spell it. It's a hard word to spell. That's why you have spell check, though. So that's cool, no worries. All right.