 Home tab, font group, header, black, white, center it. And then let's insert column J. Let's insert something between column J, right click and insert. And then we're going to say, this is gonna be the Z of age, Z of age. And so we'll do our Z score. This is gonna be equal to brackets, the 24 minus the 28. I'm gonna say F4 on the keyboard and then close that thing up and then divide it by the standard D, F4 on the keyboard dollar sign before the letter N number and enter, then decimalizing it, home tab, number group, decimalize, double click in the fill handle to drop it down. Let's do it again over here for the Z of the BA batting average. Format paint, the header cell, home tab, clipboard, format painter for the Z of the batting average doing the Z score. Once again, equaling the batting average data. Well, we need a bracket. Bracket and then the batting average data minus the mean F4 on the keyboard making an absolute dollar sign before the letter N number, closing up the brackets and dividing by the standard D which is the 0.0555. And then we want an F4 on the keyboard, dollar sign before the G and the three and enter. Let's decimalize it, home tab, number group, decimalize to recognize and then double click on the fill handle to drop it on down. Let's make it a little skinnier from I to L because it's ill, it needs to be sick. This is sick, man, it's ill. All right, so we're gonna close it up like that. Is that good or bad? I don't know, it's ill, man, it's ill. All right, let's do then the next one is gonna be the Z age times the Z of the BA and let's do this formatting, home tab, font group, black, white. Let's wrap the text this time and center it. So now we're multiplying these together. So we took the X minus the mean over the standard D, the Y minus the mean over the standard D which is the age and the batting average. Now we're multiplying them together. This is gonna be the Z of the age times the Z of the BA or batting average. Let's decimalize to recognize and then double click in the fill handle to drop it down. Dropping it down. All right, so now we just need to sum it up to get that numerator. So we'll close up, let's make the N a little bit thin and then we're gonna say this is gonna be the R or core correlation. I think I spelled it right this time. This is the last problem I believe and the spelling home tab font group has been done. I can learn. I learned stuff. Sum of the Z of age times the Z of the BA, tab, tab, putting it in the outer column, summing it up equals the S-U-M, shift nine and picking up our last column, control shift down and enter. Let's decimalize it to recognize it a little bit better home tab number. If you wanna recognize it better, you need to reveal the decimals. Otherwise you don't even know who they are. I don't even know who you are, some column. Then we're gonna do the denominator, N minus one subcategory calculation. We're gonna say N, just N, just N. Don't try to help me out, Excel. Less one, you're not helping. You're not helping, Excel. I don't care if you're trying to help, trying to help. I'm gonna say, let's select these two. My house can't be rebuilt with good intentions, Excel, you're messing it up. Home tab, alignment, space. This is gonna be the count. So we're gonna count the number of rows we have equals to count. I can count any one of these. Let's just pick the first one, control shift down and enter. So we have 815 columns of data. Less one, according to the numerator in our form, you lie, equals 1, 815 minus the one, 814, let's put an underline under here, home tab, font group underline, and let's say this is gonna be the R or correlation. So the correlation is gonna be equal to the numerator up top now in the outer column divided by the denominator, it's zero. Let's go to the home tab, number and decimalize to recognize. So 0.05, so not the largest of correlations there. We could also plot this out, we could plot this thing out and say, all right, what if I plot it out then check it out that way. Let's do this, two data sets, control shift down and say that we're gonna say control backspace and insert charts, scatter plot and check it out that way. So now you've got, let's put the labels on it, plus button, access labels. It's gonna pick up by default, the one on the left being the X. So I'm gonna say this equals the age and then this one over here is gonna be equal to the BA or batting average. So usually we would be thinking this would be the independent variable. So you can question if that is the case as the age goes up, you would kind of think possibly the batting averages would go down, except maybe as the age goes up they're able to consume more drugs or something and so maybe they get more yoked up as they get, I don't know, I don't know, I'm just guessing here. But let's just see what the data says in terms of the correlation line, the trend line. Let's put that one in place. You don't see much action happening there, not a very high degree of correlation at all. If we tied it, if we could know how much juice they were taking, that would probably give us a better line. I don't know, I'm just kidding. Let's go to the first tab. We're gonna say let's hit the drop down here, make it a straight line, let's make it orange. And so we have a bit of, a bit of a negative trend.