 this by saying this equals this number two divided by control shift down. I'm just want to pick up that 25,000. So it's just that number two divided by the 25,000. I want it to be absolute. So F four and the keyboard dollar side before the J and the nine enter. I'm going to percentify this whole column or I could just do this one cell and then copy it down maybe home tab number percentify so we can recognize and then add some decimals and then double click on the fill handle and boom it copies it on down. So now we're comparing these percentages and I could say okay what's the difference between our percentages difference between what we got to what we would have predicted if we used these numbers and multiplied times our 25,000 count or something right or got our percentages. So let's go to the home tab font black white alignment center wrap and then difference equals the p of x minus the percent of total. I'm going to percentify it home tab number percentify add some decimals double click it down on the fill handle and so you can see the differences are pretty low for the most part. So once again indication that indication that this could conform to a bell curve and a bell curve could give us good information about this data. Okay so now we want to say okay let me graph this thing this actual bell curve. I could graph it first to just see what it looks like in terms of our percentages. I'm going to put my cursor here control shift down shift up so I don't pick up the total scroll back up to the top insert I'm going to go to the charts first I'm going to just hit the bar chart and let's just check take a look at a standard bar chart there it is there's our bar chart and so now I can say okay maybe I can look at this bar chart and compare it to my actual percent data so remember we did this one over here with with the numbers but now I'm going to do it comparing it with our percents of the actual data and put them on top of each other so before I do though I'm getting ahead of myself hold on hold your horse you hold your horse your horse is tired it needs a hug so I'm going to change this bottom bit because it shouldn't start at one it should start at 80 selecting the data chart design data and I'm going to say selecting the data edit group on the right and then we'll select this item I'm going to put my cursor on the 80 shift down control shift or just shift up so that I don't pick that up and then I'm going to say okay and okay so make sure to check it on this side because sometimes it gets a little picky over here it doesn't pick it up but it looks like it did it so there it goes so there's our smooth bell curve now let's add this on top of it to see our actual data in percent form on top of the bell curve stuff so I could then go to the data and I could say let's add another it's going to be the percent of the total as the name delete this stuff make sure you it's a little tricky here it gets a little sketchy it's not hard but it's but sometimes excels doesn't do what you tell it to do and you got to be like okay excel I'm not mad I'm not mad or anything but you're not doing it you're not doing what I said to do and it's just frustrating I'm just disappointed just disappoints me when you do that excel and then if you talk to it nicely like that then it usually starts to work so that you can see that this lines up pretty close our actual data and that you can also do that with a line graph I probably should show a line graph just to show the difference but that's the idea so now I can say all right now I can make an area chart of it if I wanted to because we're usually thinking about terms of areas not the bar chart so I can take my actual bell curve and say my bell curve is good to go now and let's make an area chart with it so I'm going to go up top and say I want to insert this time an area thing an area chart not just like a thing and then we'll say okay and so now we have the area and I once again need to change the bottom bit down here so I'm going to go to my data and then this this one on the right I'm going to then say I want you to be the x stuff here and then the dancing ants do their x axis dance see how it didn't do it see that excel why I'm not mad I'm just saying like I picked up the numbers correctly and you didn't you didn't bring the x's in there I see what you did pick those you see the you see the dancing ants doing their x axis dance get it right see then it picked it up so you just have to just have to get a little you know you gotta you gotta watch him you gotta watch excel they mess with you sometimes so there's that so so now uh now what we would like to do and and we'll do this next time we'll continue on to adjust this graph so that we can then ask questions like what if x is you know greater than so much and we'll do the between thing looking a little bit differently and we'll also add uh the the z scores uh as well and add those to our graph in the following presentation