 Home tab font group bucket drop down make it green and there we have it and the hiccups Okay, so that looks good. So so now I could say uh that that we we do a p of x Calculation so I could say well, let's look what the p of x looks like control shift down And shift up to not pick up the total control backspace to get back to the top And then I'm going to say insert Charts, let's put this in place with a bar chart boom And so there's our our actual data. This is for 2022 comparison, let's say And then I'm going to put my actual data on top of it. Well, first let's fix the x's The x's down here. They need to be fixed. Something needs to be done about these x's We're going to go to the chart design We're going to go to select And then edit this on the left And then add our x's. I'll be selecting my x's. Okay I'll be so you don't just give me random x's I'm the one that picks them. So there they are And then we're going to say okay And then now let's put the actual data on top of it to compare it So we're going to go to the chart design data select And then we're going to add more data And I'm going to call it actual percent of total And then We're going to say boom And let's pick up our actual data And Okay Okay And so now you can see this one's a little bit kind of weirder Because well, let's add the legend hit the plus button We're going to add a legend and it's going to show a picture of me Oh man, I'm I thought when you look it up in the dictionary legend Then I thought there's a picture of me When that when you do that, but no They put the legend here. So then now this one You know, it's a little bit more walky, but it still kind of conforms to so you think the bell curve Would still give us some predictive power So we're going to say, all right, let's put that down here in our collection of pictures I'll put this over here. I have a lot of pictures On your phone of your family and stuff. No, they're of charts They're their chart pictures They're really important to me I have to keep them safe over there Okay, so now we're going to say that we want The difference So we can call this Let's put it up top differences Let's say let's make that orange Home tab font group drop down Making it let's say dark orange or something and white And then let's put the differences for the x's and then the p of x's Maybe and then we can say the differences between the actual Percent of total that we can do differences on Selecting these items Home tab font group making it black White centered wrapping it. I need to unhide my 2019 20 data, which is between l and t putting my cursor on the drop down or on The column l to to you lu we're going to lu and right click skip to the lu my darling and uh We want to unhide Where's your darling she's skipped off to the lu Skipping to the lu my darling That's a song nobody knows what you're talking about that song is ancient for crying out no need. What's the lu? And okay, whatever Let's skip into the lu man so Let's just do this Actually, let's just pull over the x's so the x's are just going to be this and then i'm going to copy it down and We're going to copy it down To here and then let's go to the home tab Numbers and Remove some of the decimals, okay We can make this a little bit smaller possibly All right, and then the p of x is i'm going to say is equal to the difference between The 1920 p of x data so this minus Then this data so you can say boom There's that and I can make it a percent possibly home tab number percentify Adding some decimals double clicking to take it on down. So now we're looking at the difference between 1920 and and 2022 I could do that for let's do that. Let's insert a cell here right click insert For the z's as well So for the z's I could say this equals the z here minus The z there So and then I don't want to make that a percent. Let's format this one home tab font group format paint it And so there's our difference and then I'll just double click to bring that on down We can take the differences in the actual percent of the total So this equals The actual data for 1920 minus 2022 Boom making that into a percent home tab number percent Adding some decimals double clicking it on down. So there's some Some comparison data And then of course we could make some other graphs and try to graph these things on top of each other if we wanted to such as the 1920 p of x and the 2022 just to see them overlapping each other to see what that would look like So let's take the p of x here. I'm going to say control shift down and then uh shift up And control backspace back to the top insert Charts and let's