 go down to 55 just so we can include that last number and so Okay, so there we have it and then I'm going to total this and And then sum it up over here So if I sum this up by the way should get alt equal that should be a hundred or one home tab Numbers percentify and This one over here if I say alt equals we're going to get to the six twenty nine Which should be our account right there's the six twenty nine That's a check a double check that we've kind of got all of our information now instead of multiplying these Percentages times six twenty nine so I can compare to the frequency. I'm going to take the percent percent of Total the percent of the total So that we can convert this into percentages, which I can compare to these numbers then on the actual data So actual let's say actual actual percent of total home tab alignment center wrap it black White and then we'll put our cursor here. This is going to be equal to this Divided by I'm going to put my cursor in the data so I can say control shift down taking me to the bottom Picking up these six twenty nine I'm going to say f4 on the keyboard to make it absolute so there we have it So we're going to take each one of these divided by the total enter and let's make that into a percent home tab number Percentify add some decimals putting our cursor on the fill handle double-clicking it taking it on down So now we've got our percentage use comparisons So this compared to this now this compared to this This is our bell curve. This is the actual percent of total data Let's look at our differences then we could say that well, it's the difference Between the actual and our percent data home tab No font group black white alignment center and Let's say this is going to be equal to the p of x minus the actual percent of total Making that a percent home tab number percentify adding some decimals Double-clicking the fill handle to take it on down So we can see the differences there. So it looks like it lines up pretty good pretty good Now we could actually plot this information We can plot these two basically on top of each other to see how closely they line up the bell curve and The actual percent of total so we'll pick up control shift down and then shift up So I don't pick up the total control backspace. So I get back to the top and then insert Charts we're gonna put a bar graph and boom So there's our actual data looks very bell ish bell ish shaped and let's say this is for 1920 comparison and Then I'm gonna pick up the actual in data. So let's put our cursor here So let's go to the chart and let's add the data. I need to first pick up my proper X's So these X's aren't right. I need to pick them up over here So I'm gonna edit and then select this one and go into our X's like we do every time control shift down and Shift back so I don't pick up the total enter Okay, so it looks like it's got the correct X's so I'm gonna say okay Got the correct X's because we went to Texas and found all of my X's That's a song. Sorry. That's a song. I got distracted all of my X's are in Texas Anyway, we're gonna. I don't know why that song just Would you would you delete that stew Phil would you delete that cuz that shouldn't be in it select That's my editor. We're gonna then go into here and and we're gonna say now We'll then take this and say we want to select the data and we want to say that we have add Let's add the next data set which is gonna be named the actual percent of total and then we'll take our column over here and Pick that one up and say percent boom Looks good Okay, and okay, so now we've got the two on the same So you can see that that let's add a legend Let's add a legend. Oh, I thought it was gonna put a picture of me right in there because I'm a legend I thought it was just gonna put my portrait on the side whatever anyways You can see that the that the actual data is pretty close, you know So so you could see to the to the bell shaped curve Which means that the bell shaped curve should give us some predictive power Over what we're doing here. So let's pull that on Down now we could of course make an area type of graph as well But let's what I want to do now is do the same kind of thing for for the next year Let's put let's put something above this so that we can show that it's 1920 data so I'm gonna select all of this information and right-click and then insert and Shift it down Shift it down okay, and then this is gonna be 1920 and Let's make that number format and let's just make it a general and Then I'm gonna select that and I'm gonna I'm gonna copy it across. I'm not gonna some people might merge I don't like to merge. So I'd rather right-click and then format the cells so and then go into the Alignment and then I want it to be Horizontal center across the selection so that'll put it in the middle without combining so there's still separate cells But it's like in the middle and then I can go into The home tab and let's make it a different color like a blue maybe let's make it blue and white So that's the 2020 stuff. All right. Let's now do the stuff for for 2022 so I might be able to hide some data first. Let's make a skinny T It's like mr. T got skinny because he stopped Working out. It's a skinny T and then we're gonna right-click and then hide No one knows who mr. T is anymore Whatever everybody knows mr. T man. He's on the 18 and And so this one it's blank because I hid the data. All right, let's do it again up top and then let's do this for 2022 so now we're on I'll put this up top 2022 Formatting that home tab Number let's make it general format. I'll make this one green. Let's say so I'm gonna hit the Home font group. Let's make it dark green and then white Okay, so we have the same starting point. We have x's we've got the P of