 this you can see what's happening here is just like what we saw pictorially if I'm saying well if this orange is everything up to 80 everything over that point is going to be the blue and everything under the curve blue and orange represents a hundred percent so if I'm using a formula I can use the same formula and just say it's going to be one or a hundred percent minus well first I'll just say this is going to be equal to the same thing I'm going to just do the same thing here and I'm going to say then that this is going to be equal to one one or a hundred percent right minus and then add my norm dot dist norm dot dist so there it is I'm going to select tab to pick it up this is going to be running much the same way I'm going to be picking up my x which is going to be the 80 now notice it's a little bit tricky because this is equal to so the 80 has already been picked up here so if I'm trying to do the inverse I'm going to say that this I can't say it's going to be greater than or equal to so I'm going to say minus then I'll pick like a really low number I'm going to say I'm going to say plus point oh oh oh oh one right so now it's not exactly equal to here and then I'm going to say comma and then the mean is going to be the 74 again and then comma and the standard deviation is the 10 as before and then comma is it cumulative we're going to say it will be cumulative so that's going to be a one and then brackets percentify at home tab number group percentify add some decimals and we get to that 70 30 74 again so if they ask me a question such as what's the likelihood that it's going to be greater than 80 then I can still populate the information up here and now the orange is representing everything less than or equal to and the blue is in essence representing thing everything over and above that amount so that's a a little bit kind of tricky to use this graph we could of course make a different different graphs as well and but sometimes it might be easier to use the same graph so we'll take a look at some different variations to make this graph on the right to deal with these different questions of less than or equal to or greater than and then of course between would be the next question that would often come up now notice if I go up to my formula up top so this is now I didn't make this a dynamic formula so if I go into this now I can make this dynamic let's go into here and say this is going to be equal to I'm going to put the quotes around the text area so this is going to be from here to here I'm going to end the quotes and then I'm going to say and so now I'm going to say and to tie it together and then I'm going to replace this 80 with this actual number up top or that G 10 and then and to tie it together to this last piece of text bracket or quotes and quotes all right so I'm going to say enter and so now we have a dynamic field so if I made this go down to down to 60 for example now you have the 60 over here and you can see it reflected in the graph and you can see it change in our dynamic field so let's bring it back up to 80 and then I'm also going to say this let's say this equals equals this one and then I'm also going to tie it together so I'm going to say and and then I want to tie it together with this one so now and let's see if I can wrap that home tab alignment wrapping the text so now this this column is kind of representing those two things which can help me to basically visualize either of those questions with the orange and the blue is the general idea and I can even adjust my legend over here if I wanted to by going to the the chart group I can go into my data and I can say that this one right here the p of x let's go ahead and edit it and then in the name up top I'm going to change the name to be like this was the blue one I'm going to say this is going to be p is greater than or equal to 80 hopefully I get this right and I don't and then this one I do get it backwards and it's going to be edit and I'll change the name here and say this is going to be the p is less than or equal to 80 and then okay and okay so now I'm going to go back on over and now we have the legend of the blues the amount above the 80 and so so now we can kind of ask both of those questions when you have and you can kind of play with it pictorially okay so then of course you might also get a question of something being between let's do the z score first though so I can do the z in the same way let's just calculate it again so we get an idea of the z again so this is going to be equal to I'm picking up the number we want I'm going to say is x is 80 minus the the middle point closing up the brackets divided by the standard deviation divided by right here I saw the divided by and then standard deviation so there's our formula I'm going to say enter add some decimals home tab number group decimalizing it so there's our point five once again and then again I can do this I can do this same calculation but now with the z score so this is going to be equal to norm dot s dot dist and then enter and so now all I need is the z because the z you'll recall just as we saw is taken into consideration the mean and the standard deviation in that calculation so I just need the z now comma it needs to be cumulative and notice I didn't put the one minus so it's going to be wrong but let me just show you I'm going to say this is going to be true close it up and so if I percentify that I can say oh wait a sec if I put those together that adds up to 100 this is the inverse I got to this I need to say one minus I'm going to double click on it and say this is going to be one minus a hundred percent minus that and then I get that same number now the next question that we get is as you can say that this is going to be P and let's say let's say that that the lower the lower is now going to be let's say 75 in the upper is going to be what we had up here which is just going to be the 80 so now I'm going to say between the lower and the upper is what we want so we might put that in here is by saying P is going to be and you could represent it this way like 75 is less than or equal to the the x which is which is less than or equal to the 80 I kind of like doing this I don't I know this may not be that I tend to think of it as x is going to be is going to be less than less than or equal to