 X, P of X, and then we're going to have, let's select those two, I should have kept it unhidden so I can black, white, I'm going to make the X a little smaller, we should probably center it, alignment, center, and then I should probably just copy the X's from what we did before but I'll recreate them, well actually let's unhide and copy the exact same X's, so I'm going to unhide, putting my cursor from L to U, Lou, and then right click and unhide and let's just pick up the exact same X's to make sure that we have them lined up, this equals this five, putting my cursor on it, double clicking the fill handle, it won't let me do that so I've got to drag it down. For crying out loud Phil, why is the handle not working, why is Phil's handle not working? So I'm going to scroll up, we don't need the decimals, decimals which you number group kindly depart so that we can get down to business over here, then I'm going to hide from M to S, so miss is going to, we're going to hide miss and then hide, she's distracting people with a miss, okay so now we're going to say this is going to be equal to norm dot dist and so now we're going to pick up the X which is now 2022 data, so I'm sorry it's going to be that X, the five comma the mean is that 22.2 for the 2022 data, I want to F for it because I want to copy it down dollar sign before the K and the two so that 22.2 don't move down comma standard D, that's going to be the 6.12 F4 in other words make it absolute dollar sign before the K and the three comma cumulative no false or zero closing it up enter putting my cursor on it, percentifying the cell home tab number group percentify so we can recognize and then we're going to put our cursor on the fill handle and double click it on down there we have it and now it adds up to 100% if I go to the total down here and we say alt equal one or a hundred home tab number percentify decimalize and recognize all right so then we're going to say the Z we can do our Z score which is important for our comparison purposes home tab font group black white let's center it let's make it a little smaller and the Z is going to be equal to brackets the five minus the X minus the 22.2 in this case close the brackets dividing by the standard D standard deviation 6.14 there's our Z I want to copy it down so anything that's outside of my data over here that's outside of the table I'm working in I need to make absolute that's anything in column K so that's going to be this K2 F4 dollar sign before the K and the two K3 F4 dollar sign before the K and the three enter putting my cursor on the Z score double clicking it down and we can see that it gets to that zero point around 22 and 23 because that's the mean and that makes sense so we can compare the Z's for years 2022 and 1920 now let's do the actual frequency you're a frequency frequency I don't know font group black white did you just call me a freak I know it's the freak the frequency I said I said frequency we're going to say this is going to be the frequency which is which is how many times it's going to fall into the buckets for example this one being above zero up to and including one so we'll do our frequency equals frequency tab data array is going to be over here control shift down control backspace to get back up comma and then the bends array which are our X's which all live in Texas we try to stay out of Texas therefore I because there's that's where the X's are and so it's not a pleasant place a lot of times that's a song okay get the song out of your head no song references no one even knows what you're talking about man no one even knows what you're talking about okay sorry let this cut there's still two down here so let's actually pull this down and bring this down to one more I'll pull these two down so that we get that last two in there and this should be 56 and then there we have it so now I can total this up this is going to be alt equals alt equals 822 so that 822 should tell to that so that looks good that's our check number now and now what I'd like to do I could multiply all these numbers by the 822 so I can compare it to the frequency but I'd rather make these into percentages so now I'm going to say this is going to be the actual actual percent of total and then we're going to go home tab font group black white wrap it center it and then we'll say this is going to be equal to that zero divided by I'm going to go into my data so I can go control shift down just so I can find that bottom number f4 on the keyboard dollar sign before the x and the 65 so I can copy it down not having the total move down when I do so percentifying the cell before we copy it down home tab number group percentify to recognize add some decimals fill handle double click in it and fill fill does the calculations and there we have it so I can say alt equals that should be 100 percent right there home tab number group percentify to recognize and so there we have now I can say the difference the difference between the actual data and the p of x data home tab font black white center is equal to p of x stuff minus actual percent of total percentify home tab number group percentify decimals double click and fill handle to bring it on down there we have it all right so let's let's put a I have a 2000 I thought I put a 2000 oh there it is let's center this 2022 thing now selecting this whole bit up top right clicking formatting the cells and I will do this by going to the alignment group horizontal center across selection and okay you can't see it because it's in the middle now and it's white there so