 but nothing that's looking absolutely telling. Now I'm gonna pull this to the right and say, well, what if, obviously if you were to make assumptions about this data, you'd probably be saying, well, if the age goes up, their batting average would go down. That would be the hypotheses that you would most likely be making, making the age the dependent or the independent factor and the batting average dependent. It would look fun, but you could think about it the other way. Let's reverse this chart just to do it. So I'm gonna go back to this tab and select the same data, control shift down and control backspace and then insert charts, scatter plot. And this time I wanna change the axes. So let's add an axis, axis title, but this time I wanna make the x equal to the batting average as if it's the driving factor that is going to be correlating to the age. So sometimes you don't know which is which and you could plot it either way, you're still gonna get the same kind of correlation direction, negative correlation in this case, but I need to flip the data around then to do that. So I'm gonna go to the charts, I'm gonna go to the select data up top, pick our data here and edit it, and then this x factor, I'm gonna delete it needs to be, I wanna make that the BA data, control shift down, control backspace and there it is, make sure, and then on the y I'm gonna delete this data and make this equal to the y data, control shift down, control backspace and boom. So there we have that one and okay, okay. So there's that scatter scatter. If I add the trend line in that one, I still get that slightly downward sloping trend line. If I then take a look at the options and format it, we're gonna go to the bucket up top, make it a straight line and orange for the buckets or orange, make it orange. That's the format that we like to see the line in. All right, okay. So then we've got that and so then I can let, let's let Excel do the correlation calculation and see if it gets to the same .05 that we got to here. So let's try that. So let's go to the data tab to our analysis. If you don't have that analysis, it's in the file tab, it's in the options, it's in the add ins and then it's in the add ins down here and then you go to that and then you click off the tool pack if you wanna be part of the cool cats. All right, so then we're gonna go up to the data analysis and we're gonna say this is gonna be the correlation of, okay, let's go into it first. Hit in the tab, where's the data set we wanna go to? We want this data set, the age and the batting average, control shift down, control backspace going back up top. We picked up the row for the column. So we want the labels on the first row. Where do we wanna put it on our worksheet? We wanna put it right there. And so we'll say, okay. And so there it is. So it looks like we've coming up with the same correlation. Let's add some decimals to better recognize. And so there we come up with the same correlation. Move B to the end. Let's make a skinny, let's make this black and white, home tab font group, black, white, there that is. Now we can also do our standard statistics on this one just to practice that for the fun of it with our data, data tab, analysis, data analysis. We want the descriptive statistics and then we'll pick up the data inputs here, control shift down, control backspace. We wanna pick up the labels, output range is over here. We wanna put it over here somewhere right there. And then I'm gonna get the summary statistics and possibly the confidence at 95 and okay. So that spits out our general data here. It's not dynamic. It's hard coded in other words, but there it is. Let's format this, I'm gonna format this and say let's go to the home tab, black, white. I'm gonna make a skinny V. I'm gonna make all this blue and bordered. And then next time we'll pick some other stuff and see if we can get a higher correlation. So I'm gonna go to the home tab, font group, bucket drop down, not black, but that blue. If you don't have that blue, I use standard blue right there. And border it as well, border blue. And then I'll make this border blue. And then I'll make this border blue. And then I'll make this whole thing, control shift down, border blue. And then I'll make this border blue. And then I'll make even this border blue, control shift down, border blue. We'll make the same skinny columns too, but I'll wait to do that next time. as we pick some other data sets again and try to see if we can find a higher correlation between them.