 upper X so that should work. So I'm going to go back on over and then this I don't want why I want the actual frequency and then I'm going to say home tab alignment let's center it black white wrapping the text and let's make this the same black white and center it and so now we're going to do our frequency so I can do this with the actual data now so we did the frequency over here you'll recall and it wasn't very helpful because we're when we go up calorie by calorie then it's not going to give us we're going to get sparse ones every once in a while on all of these calorie by calorie data but now I'm going to do a frequency with the actual data so for the second one we're going to be picking up everything that is going from zero up to the 400 so let's try that we're going to say this is going to be equal the frequency tab and we'll pick up the data array which is our actual data way over here and we'll pick up the whole thing and then enter I'll hold on a second that's not the whole formula and then I have to say comma and we want our bends now let's pull this to the side so you can see it then the bends are going to be from this zero on down control shift down I'm going to scroll back up so there it is and then closing this up and that's not a close close it up and enter so there we have it it goes a little far so I'm going to double click this go to that last bit and bring it back to 15 and so there we have it so then our total count if I sum this up alt equals should be that 457 which matches our 457 when we just counted the data so that's our double check that it looks like it's picking everything up so we had 400s anything from zero to 400 we had five of those anything from above 400 to and including 814 and then six from 800 to 1200 and so on and so forth now we might want to do a percent of the total in our bucket so we can also do that this way percent of total and I'm going to say this is going to be font group black white let's wrap it let's center it this is going to be equal to this number divided by the total now which is that 457 f4 on the keyboard making it absolute dollar sign before the in and the 17 enter let's percentify it home tab number group percentify adding some decimals and then double click the fill handle to take it on down I don't want the 100 to be just doing this divided by this so I'm going to say delete that and instead sum up to get that 100 alt equals for our check number there's our 100 that checks out so we can do that now I also want to group my P of X's I could do this a couple different ways I could say well look I want to get all of my P of X's that go from negative to zero that's going to be my first bucket and then all of my all of my P of X's that go from that they go from zero to 400 and so on now this isn't the perfect way to do it because you might say well then it's you're like summing up you're summing things up but again this is where it comes into play that because these are such we're using such small units we're going to get pretty close to the to the actual answer even though we're kind of summing this up and then we'll show another way to do it as well so so if I was to so I could sum up the percentages which I can compare to these percentages or I could sum up this count number that's why we did the count number two and you know we can do either either of those methods let's do the percentage though we're going to say this is going to be the P of X frequency I'll just say freak when C it's the freaky P of S X and then alignment wrap center okay so to do this we could use like a sum if formula so I could say something like this equals sum if S because there's going to be some ifs and then brackets that's the one we want the sum range the range that we want it to be summing is going to be this one so I'm going to put my cursor in the P of X on the percentages control shift down I don't want to pick up the total so shift up and then I'm holding down control back space to get back up to the top and then the criteria range is going to be the criteria of the criteria is going to be these X's I'm going to select this whole thing I'm going to put my cursor G to control shift down and then shift back space not to pick up the total control back space to get back up to the top and then comma and the criteria is that we want it to be I'm going to say we have to put brackets around our less than we want it to be less than or equal to I've got to put not brackets but quotes around that and then tie it together with a knot and that's our knot and we're going to be picking it less than or equal to the zero so this should be picking up everything that's in the negatives up to the zero and then I'm going to close it up and enter and so we have let's make a percent home tab number group percentifying it add a couple decimals we're at the point 36 okay so this next one's going to be a little different because I'm going to have two criterias now because I want it to be less than uh the 400 but greater than zero and then we can copy it down so we're going to do it again equals so we'll say some if