 Limit 79 comma mean 73.7 comma standard deviation 2.3 comma cumulative yes or one closing it up minus norm.dist tab x lower x 72 comma mean 73.70 comma standard deviation 2.3 comma cumulative yes or one and close it up and enter let's percentify home tab number percentify adding some decimals and so there we have it now if I wanted to to graph that I'm going to say all right let's say this is going to be equal to my dynamic reference over here and then I'll center that home tab alignment center rapid font group black white okay and then uh I'm going to say okay so so now with my instead of trying to do an if function that picks both those up I'm just going to take these two and I'm going to say that that I want you to well let's do it this way one way you can do it is you could you could try to plot the lower you can plot the upper and then you can try to sum them up uh only if something is showing if it's greater than or equal to zero or something like that with an if function uh or I could do I could do something like this I can say this is going to be equals if brackets and then there's basically two tests that need to be met so I'm going to embed now an and function so now I've got an and within my if so I can have my two tests so if I'm going to say and then and the logic test is going to be this number the x if that is let's say we're going to say that has to be less than or let's say it has to be greater than or equal to the lower bit the 72 and so I'm going to say a comma and we also want to say that this number over here is going to be less than or equal to the upper limit 79 that closes up our and so we've embedded those two conditions in the if using the embedded and and then what then I'm going to put a comma what are we going to do if that's true well if that's true then you pick up the p of x and then comma if it's not true we just want you to leave it blank which is two quotes and then close it up and enter so nothing's there if I double well now I'm going to double click on it again I need absolute references for these two cells which is on in columns d and e so anything on d and e so this one f4 and then this one f4 making them absolute dollar signs before the letters and numbers enter and then double clicking on the fill handle to pull it down and then you can see it basically adds up that middle bit let's highlight this whole thing home tab number group percentify adding some decimals all right so now let's just do another once again our our chart so I'm going to start the same way control shift down shift up insert charts drop down here we want an area chart going to pull that to the side remove the title going to scroll to the side a bit I'll do this a little bit faster since we've seen this a few times I'm going to go to the data up top go to the x's select the data I want to fix these x's select in this one I'm going to pick my x's control shift down shift up and all right and okay so boom the x's have been entered then I'm going to pick up my second data set going to the charts data again adding the second data set which is going to be named this my dynamic name removing this bit I'm going to select this item so I want to pick up the whole range even though there's only data in the middle of it and say okay so there it is it pulled it in okay boom that looks good and then I'm going to so now you can see that this is the upper limit so right this is in the middle there even though it looks like it's almost kind of picking up the whole bit because that triangle but that's fine so now I'm going to say all right let's double click on this one giving us our format data series make our secondary axis closing this up I'm going to remove this bit because I don't need it and then I'm going to go into my data again second data set changing the secondary axis to be the z score control shift down and okay it didn't pick it up notice that it's a little finicky sometimes because I could see it didn't do it what did you do excel close that up I'm going to select this it's a little finicky control shift down I'm not going to get upset what did you do excel why did you even do that man why did you even do this like I don't even know you anymore excel okay don't be too hard on excel we're going to say there it is so then so then I can hit the plus button and then hit the arrow secondary horizontal and then okay and then I'm going to and then I'm going to pull this down to the bottom double clicking on it labels and bring it down to the bottom lower and so now we've got this between one which is dynamic because if I make the upper limit let's say let's say we make it between 74 or something like that now you can see it basically gives you that between so you might not need all of these graphs to to to represent your data one would probably be fine but you do want to be able to build them so that you can represent your data pictorially because it's it's often quite useful to do so let's just do some formatting on this now I'm going to select this whole thing I'll just make it uh I'll make it home tab number select the bucket let's make it blue let's make it bordered so there we have that and then I can select all of this stuff let's make it home tab font group blue and oh not white undo undo control z let's border that and we could sum these up if we want to alt equal just to sum up our totals alt equal may as well alt equal oh not that way what are you doing what are you doing excel uh you want to pick the stuff above you know what I wanted don't play don't play dumb don't play dumb with me excel I see what you're doing I see what you're doing think you're so smart but I can tell all right so there we go now we should have a space between our table over here I feel like so I'm going to put my cursor on column F right click and insert and then I'm going to clear the formatting in here just so I have that interim white bit so they're not all connected together with my table I'm going to go back to my home tab and make some borders around that and so that will help you to basically answer questions and look at it pictorially whether you're giving x's or whether you're given z scores and then you can and then you can draw and you can draw various graphs even if you can't draw them by hand let's do a quick review on the spelling did I how was how's the spelling looking it's perfect it can't be spell check must be wrong but there it is it's good good enough