 2417. Let's put a difference in here. Difference just for the fun of it. We're going to say home tab font group, black, white, center it. So then we'll do the average here, average for 2022, which is this data, control shift down, enter. And then the difference. Here's the difference. So we're going to have an average, you know, little bit different average standard deviation, standard, standard deviation, we're going to say for the population. And I'll pick up this data set, control shift down and enter. So there we have that. Let's do it again, standard deviation for the population, this data set control shift down, holding control backspace there. There's our calculation and enter the difference equals this minus this. Okay. And then we've got the median, middle point equals the median. And we're going to say this data from here, control shift down, control backspace back up and enter. And it's pretty close to the mean. That's an indication that the bell curve might give us might be a good tool to use. And then we're going to say the median on this one, it's going to be this data set control shift down, control backspace and enter. Pretty close to the mean, which is usually an indication that the bell curve is something we can use. There's the difference between the two and the mode equals the mode single mode. And from here on down. We got 25, which again is pretty close to the mean. Another indication that the bell curve might be useful mode, single mode here, control shift down, backspace, enter. So again, that is close to a little bit further off, but still relatively close to the mean. So it's an indication that the bell curve might be a tool to use. And the difference between those two is zero. All right. So then I could say, okay, let's start with our data for for 1920 and start to build our our bell curve. So we'll build our table to create our bell curve. So I'm going to make a small M skinny M. I'm going to see I need my X's and my P of X's. And then these tables are getting in the way again. You need to get way out of here. Get out of here. You're in my way. Like it's like a just like a pet little chihuahua under my feet all the time. It's like I'm trying to walk. You try to kill me. This thing's trying to kill me keeps on walking under my foot. And then and then they anyways, hometown font group black, white, let's center it. Now we need to know the starting point. So where should I start the X's at? You might say, well, if we're talking about averages, which we're representing in whole numbers, I could just go from zero to 100. Because you would think that would be the entire spectrum. But let's do our thing where it's usually the four standard deviations. I'm going to say, let's do the number of standard deviations. Let's take it for standard deviations out for both data sets because that will encompass the vast majority of the data. So the lower x and in the upper x would then be what the lower x for 1920 would be the mean times the standard deviation or I'm sorry, plus the standard deviation times four. So standard deviation times four minus the mean the mean minus the standard deviation times four for the standard deviation below. Alright, enter notice it goes below zero, which in reality doesn't isn't going to happen. Because you can't have a negative batting average. But I'm going to keep it because once we graph the curve, it'll show all of our data points, which gives us that kind of double check that we have all of our data in there. So I'll keep it there. And then we're going to say the upper is going to be equal to the mean plus the standard deviation times four. Enter, boom. And then let's do on this one. This is going to be for 2020, the mean minus the standard deviation times four. And this is going to be equal to the mean plus the standard deviation times four. So there's our upper and lower x's. So let's go down to the lowest x because I want to and then up to the highest so for both of these. So I'm going to go I'm going to go from five to 50 to 53 so that we have x's that will line up under both data sets. So I'm going to say the x is going to be at negative, let's say negative five. We're not going to have negative batting averages. But I'm going to I'm going to start it there so that we can so we cover the whole the whole data set. And then I'm going to go from to negative four, negative three. I'm going to select that group. I'm going to bring it down to 54. So I'm going to put my cursor on the fill handle, take it on down till we get to 54, 50, 54, right there. Boom. I don't need the decimals on this one. Let's go to the home tab, number group, remove the decimals get out of here decimals. You're not needed or welcome in this on these cells. And then we can do our P of x. So this is going to be equal to the norm dot dist tab. The x is going to be this comma the mean we're looking at the 1920s. So we're picking up this one and not not that that's the mean and then f four to make it absolute dollar sign before the J and the two so I can copy it down comma the standard deviation. We want this one f four dollar sign before the J and the three comma do we want it to be cumulative? No, false or zero therefore closing it up enter putting my cursor on it. And we're going to just double click to let's make it a percent home tab, number percentify adding some decimals. And then I'll put my cursor on the fill handle and double click copying it down. So notice all of this data is now selected and adds up to 100% because we went you know, all the information is kind of within the four standard deviations. That's what's kind of nice about picking that up even the negatives because then you get that full kind of curve or pretty much the full curve the full data. Okay, so I'm going to stop it here and we'll continue on with this next time building our curve and then doing the same for 2022 and then looking at the differences between them.