 insert a bar chart so now we have now we have p of x 2000 or 1920 verse p of x 2022 something like that and then I'll pull this on over here and let's also pull in the 2022 I need the X's so I'm going to pick up the X's too so we're going to say don't pick up the X's it's not a good idea it's not a good we have to we have to do it we're going to go in here we need our own X's it's better than just having random X's be given say that we pick them up or we get random X's okay so there we have it and then then so now we're going to select the data and go into chart design select the data and I can put on top of it I'm going to add another data set and say this is going to be the second p of x or let's call it this one let's just name it p of x 2022 and then I'm going to pick this data it's going to be this range p of x 2022 boom and okay so now you can see the the two if we if we approximate a bell curve on the two you can see they're slightly you know this they're slightly skewed the shape of the bell curve let's let's add a legend here legend uh hold on I thought I changed the name this orange one oh my data so this one let's edit this and this is 1920 so let's just call it 1920 okay so the legend and then this one let's call it edit let's make that one 2022 and okay okay so now we can see that the shapes of these on top of each other and see that it's kind of skewed and then this one obviously more peaked in uh 2022 and we can see the differences over here in our mean is 24 versus 22 so those middle points you would think would be 24 versus the 22 so we can see kind of the the relative data here now when we look at the z scores remember we're thinking about the z scores are relative to the middle point of of their of their distribution which we have these two different kind of bell curves based on the two different time frames so we have that and then we could do a comparison of uh like the percent of of the total versus the percent of the total uh over here but let's let's keep it at that for for now and and just note then when you do some of these comparisons then sometimes the z score becomes relevant because when you're trying to compare one year versus another year you might be saying well uh you know if i if i if i looked at something down here and we had we had a player that had like a 30 a 30 percent right a batting average in 1920 and we looked at their z score which is this column and so it's at it's at 0.79 up above that average point and if i go over here the 30 percent if we look at the z score is 1.27 above and so if i just look at those two numbers you can say well they're both at that 30 but but if i compare it to what was happening relative this one over here in 2022 is a lot higher up you know it's so it's further away from that middle point the average of the times so you would expect you know that would that would be a differentiating factor possibly even though you're looking at the same percentages remember that the general idea of the statistics oftentimes is that i can't look at just how many at bats they have or how many times they got on base because they're going to have different at bats that's why we make the percent so the percent already kind of evens things out a bit but it's still not going to be give us we want to have more questions about who's the better player and what time frame and whatnot and the argument of course is going to be yeah but and the things were a lot different in in 1920 than 2022 so let's see how well that percentage was compared to the the middle point the average the z score right and that would be another another factor that you can kind of put into play let's go ahead and add some formatting here so i'm going to select all of my data here up top i'm just going to make it blue home tab font group bucket if you don't have that blue it's in the more colors there it is the blue and i like to put some borders around it if i may i'm going to do that here too you may no one's going to stop you home tab font group border blue border blue at least i don't think anyone's going to stop you i won't stop you you can make it a different color if you want i won't stop you from doing that either it's a free it's a free country man it's a free country well at least it used to be border blue i wouldn't be surprised if someone stops you now the king of england probably come in here and try to tell you what color you should make your chart home tab font group border blue and then we'll say this one home tab font group border blue and then this one uno vase moss one more time control shift down home tab font group border blue i'll make my table however i want to make my table if it has only two legs on it and falls over every time i put something on it that's how i want it that's how i made it that's how it's going to be okay that's how it's going to be this is going to be center across let's make it home tab font group and orange and let's pull our graphs over here so we have all our pictures so we can see them we need to have our it's not enough just to have your pictures your special pictures you have to have them ready so that people can look at them you can show them off when at like parties and stuff so then so there they are let's go into the review and i'm not oh now it's gonna i can't spell check it because it has all the names let's try to highlight all of this stuff and just spell check it over here see if i misspelled i fix in my spelling spell check frequency i knew it that wasn't actual okay we can make some skinnies let's these can be skinnier mr. t you're still not skinny enough i know you lost some weight but still all right that looks pretty good looks pretty good