 to say let's percentify at home tab number group percentify and we get something slightly different because it's right on the line there of the 79. If I double-clicked on this one and I changed this to this minus 0.1 or 0.1 right then I get a little bit closer but I'm gonna keep it where it is because what I would like to do now is to practice plotting another graph like that so I'm gonna go over here I'm gonna make another column and I'm gonna make it dynamic by picking up this here so now this is gonna be P of X is less than or equal to in this case 79 and of course again we can change it by changing this dynamic field but I'll keep it there for now let's make this black and white so I'm gonna go font tab black and white and let's then center it and so so now I actually want to see it on a different graph this time so I'm gonna actually pick up another graph and let's start at our same starting point I'm gonna pick up the P of X and shift up so I don't pick up the hundred insert it's an area graph charts drop down I'm gonna pick up an area graph down here that's the one and then I'm gonna delete the title of it and let's build this in the same format so I'm gonna adjust the X's so I'm gonna go to the chart data data select and choose the edit I'm gonna replace the X's over here with my axis control shift down shift up to not pick up the total okay there they are that looks good so I'm gonna say okay then I'm gonna add this column this time so I'm gonna put my cursor here I'm gonna go chart design data and then I'm going to say select data let's go to then the ad so I'm gonna add data the series is gonna be this name remove this stuff down here and I'm gonna click on this little icon put my cursor up top so I can make it dynamic picking up the whole column control shift down and let's hold on a second it went too far you've gone too far what are you doing well hold on I don't have anything in here yet I can't do it so I'm gonna select the data and then I'll set enter and then I'll say okay nothing's there yet because I haven't added the data which would be useful so I'm gonna say okay what am I gonna do to get the data I'm gonna say using our logic test again because I want to pick everything that is gonna be less than the 79 so this time we want to say less than and including somebody picking this one up you can see that's where kind of the overlap is so we're gonna take that up to there so you would think would be like this amount 99.44 if I was to add it up that way doesn't tie out to these numbers over here because the area under the curve so this is gonna be equals if brackets and I'm gonna say if this number is less than or equal to this 79 this number then comma what do you want you to do I want you to pick up this number than the related percentage but if not comma that's what the comma means I want you to leave it blank double quotes to leave it blank closing up the brackets and enter so it puts that in there I'm gonna percentify it home tab number group percentify adding some decimals double clicking on the fill handle to bring it down it doesn't work because I didn't do some absolute references double clicking on it again everything that's outside of my area of work this number in particular d15 I need to make absolute putting my cursor d15 f4 on the keyboard dollar sign before the d in the 15 enter let's try it again put my cursor on it double click and taking it down so there it is so now you can see it brought it down it gives you this little tweak down here so you can see it's quite small on the upper end because we don't have a whole lot of data but you get the idea I can make this let's make this something different now let's make it 76 so now the orange area represents this I can add the legend plus button and say I want the legend and boom so now we have that there and so so now we have that as a dynamic and the orange is representing this column so we can also add the z score of course two so I could say let's double click on this secondary access and then close this up delete this stuff don't need it and then in my data up top I want to go to the second bit and now delete this or change it to be picking up my z scores and okay and boom and bam and now I need to hit the plus button and axes add the secondary axis and there it is plus to get it off of that again turn that off and then double click on this bit I'm gonna bring it to the bottom under the labels and then bring it down to the bottom poor father or if you please and then lower it and boom so we can do that so now we've got that graph now the last one you might say okay well what if I what if I want a between graph so there's a couple different ways we could do it but if I'm gonna ask a question what if it's between this or that right I'm gonna bring this one down here okay well then we can do another we can do another one if we want to do and say I'm gonna make one where it's good where I have let's say a lower and an upper to get between right so now I'm gonna say something like P of X and I like to do it this way that's probably not the best way to write it but I like to say that X is gonna be greater than or equal to let's let's say it's gonna be greater than equal to 72 and 72 and less than less than or equal to 79 something like that I'll make this a little bit larger so that might not be the most perfect way to write it but that's what kind of makes sense to me right so that's gonna be between 72 and 79 including 72 and 79 so I'm gonna say the lower bit is 72 upper bit is gonna be 79 is the point if I want this to be my title up top I want to make it dynamic so I can change the lower and upper double clicking on this I'm gonna say equals quotes from all the way from here to here I want to be text so quotes and then I'm gonna say and and to tie it together I'm gonna select the 72 and pick it up from here so it picks up that cell and then this and I want to be text so I need another and and then I'm gonna tie it to the text quote of the and so one and is is code and the other and is text so I'm gonna tie it to and actually I want the and all the way over to this end quote as text and then another and to tie it to the 79 which I want to be referenced not as a hard-coded number but this upper cell and then I also want to tie that to with another and and then quotes around the last bit of text which is closing up the brackets so that's awfully kind of confusing looking but it works beautifully and if you do it a few times it kind of you kind of get you kind of get the hang of it right so if I was gonna do that with a with a calculation here it would look something like this we'd have to say I've got a mate I've got to take everything up to the upper limit minus everything up to the to the lower limit and so I'm gonna say this equals norm dot dist and the X is gonna be on the upper