 percentify, decimalize, double click on the fill handle, dropping it down. So there it is. Then we can have our Z score. This is the Z score of H. And so now same format, we're going to say black, white, center, similar calculation of the Z score we did before, but now we're using the kind of the smoother curve of the actual approximation of the bell curve based on the data set information. So this is the equal brackets, each data point minus the mean F4 on the keyboard dollar sign before the letter number closing it up, divided by the standard deviation F4 on the keyboard dollar sign before the letter and number and enter, double click in the fill handle to drop it down. So there we have it. Let's select all three of these, make it a little bit thinner. Let's make a thinner AG as well. And so there we have it. Now if we were to plot this out, I can plot this out and we should get our bell curves. I'm going to say control shift down, control backspace. And if I was to say insert charts, I won't do an area chart. Let's do just a normal kind of bar chart just to see the shape. So there it is. So now we've got a smoother bell shaped curve, although it's a it's doesn't have as much, you know, detail in it here. So we're going to say, Okay, so there is that. Let's do the same thing for our weights. So I'm going to say now let's do the weights. This is going to be w p of w. And this is going to be z of w selecting those three home tab font group black, white, center, wrap, we don't really need to wrap it, but we'll do it anyway. And then we're going to say this one lower, we're going to have in pounds, go and let's go to 79 79 pounds and then we're pound our way up. We inched our way up last time. Now we're going to pound our way up up to 174. I'm pounding my way up to 174. I'm sick of inching my way up. Now I'm pounding my way up, man, because I'm that's how it has to be because people wasn't wasn't happening with the engine. This is going to be equal to the norm dot dist. And the x is now 79 comma the mean is now the 12708 f4 in the keyboard dollar sign before the letter number comma. And then the standard D is now 1166 f4 in the keyboard and comma the cumulative no zero or false closing up the brackets enter percentifying it home tab number group percentify adding some decimals double clicking the drop it down. Let's do the z score. The z score equals brackets each of our data points 79 in this case minus the average weight 127 which seems light to me. But that's again because I'm obviously so yoked up that I'm heavier than that. So it's not like I'm it's for health. I'm healthier by being heavier. Just kidding. So then we're divided by the standard deviation. Here and then we'll double we'll double click to drag it down. So there's our Z's. Okay, so now that we have that we can then plot our bell curve for this one selecting the middle column control shift down control backspace to get back up. I'm going to put that over here somewhere home tab or insert tab charts. Let's just do a chart like this. We get our bell shaped curve. So there it is. All right. So now let's just kind of think about these z scores the relationships between the z scores. I'm going to copy this. I'm going to pull this to the right pull this to the right and let's just try to match up our our z scores as best we can. I'm going to make a skinny a k first and then I'm going to select all these columns from a h to a n. I'm going to say control c. I want to paste that here but I'm going to paste just the values only I'm not going to pull over the formulas right click and paste it 123. I'd also like to paste the formatting just not the formulas. So I'm going to right click and paste the formatting only. So now we have it looking the same but there's just hard coded numbers in other words no formula. I'm going to move this stuff to the right so I can have some room and so these pictures need to be moved to the right. So we have our space to work here and then I think it's easier this one has less data so I'm actually would like to move this onto the right side. So to do that I could select all of this and then I can say I could try to move it this way but it's useful to note that it's the same to do a cut if I cut that and paste it over here control v pasting it over there that's kind of the same thing. Then I'm going to delete these columns which I don't need from AO to AR right click and let's delete those we'll make a skinny AS column here so there we have it. So now what I'd like to do is for the best I can is match up the Z score so not going to match up all the you know exactly but we can match up the Z score is basically as best we can because that's the the tool that we can use generally to match up the data so for example the second one here I can take this and move it down and say this is close as close close pretty close to this one so it's actually close to this one 3.6 a 3.69 this one I'm going to grab this and move it down it's pretty close to the 3.15 like that one it's pretty close between between those two two point this is going to be 2.63 2.63 it's pretty close to that one and then we're going to say the next one is 2.1 it's pretty close to that one it's kind of in between these two I'll put it there and then we've got the 1.57 1.57