 Well, hold on a sec some of these and enter and make that a percent home tab number percentify adding some decimals Or I can use the poisson cumulative function so I can say this is the Poisson DIST and this I'm going to take the X is I'm just going to hard code is going to be 3 and then comma the mean 2.73 but this time instead of taking it at one point in time having just three people arrive I want to go from zero up to three people So that's going to be the cumulative distribution or where I could type either true or a one So I'm going to type a one close it up and then I'm going to say that this is a percent adding some decimals So there we have it so it gets a little bit more complex if you were to say for example you want between Between let's say between two and five people between two and Five so I could once again go over here and say okay. Well, if I'm going to say this equals the sum of Between two and five now if you're not including two or five then I would say that would be either three Or four so you got to be kind of careful on where the starting point is Are we saying equal to and including two and five or between? You know the two and the five so make that a percent and Then we could do that with a formula and if I did that with a formula notice What I kind of have to do is I've got to take the poisson distribution for the upper limit Which in this case the upper limit being five but note I'm not including five in this case So I'm actually going up to and including four and then subtracting out that lower amount Which is going to be up to and including the two and that will leave me with just the three and the four the middle Points, which is what we're looking at so it looks something like this equals Poisson dot dist and that pick up the x so the first x is going to be the upper limit not five But four because that's what's going to be included in it because it has to be below five Comma then we'll pick up the mean two point seven three again And then comma it has to be cumulative up up to that point so then I can subtract out the lower bit So we're going to say it's going to be cumulative Which is either type in true or put a one and then I'll close that up and then subtract out another Poisson dot dist and this time I'm going to be picking up an x of two So up to and including two is what I got to subtract out this bit over here and then Comma the mean is still two point seven three Comma this also needs to be cumulative and therefore I can type in true or I can put a number one Close up the brackets enter Check it out home tab number group percentify adding some decimals You know I could add decimals here if I wanted to and so those those are the ways that we can calculate So those are the kinds of questions that we can then ask ourselves What's the likelihood that amount how many people will arrive within a certain time frame either one? Absolute number two people arriving within in this case the one-minute time frame or some combination Such as zero, you know Zero to five people or what's the likelihood that you know from six to ten people Are going to arrive or sit over six people are going to arrive remember down below It's it's unlikely that you're going to have anything That's going to be way down here although we're skewed to the right on this curve So it's it's theoretically possible that infinity people arrive in a one-minute time period But it's quite unlikely right so if you go six and above you can kind of sum up Everything down here and say well, what's the likelihood we just get you know swamped Over something over the six and and you can those are kind of the questions that You can get enough obviously those can be useful for planning purposes. Let's clean it up a little bit. I'm going to then I'm going to add some blue To our data home tab font group bucket. I'm going to make this blue And bordered I'll do that here too. I'll select these control shift down And I'm going to make that bordered drop down if you don't have that blue. It's right here In the fill color. I'm going to do that here too. Scroll into the right control shift down I'm going to make that blue and bordered. I'll make this blue and bordered Just to color it the way we normally do we could actually Make these a little skinnier and they call them d a little skinnier And maybe I'll select column d home tab format paint it to call them i Format paint it to call them m possibly And then over here. I might format paint it to call them x For skinny x and then here. Let's make this blue and bordered Home tab font group border blue. Let's take the skinny x home tab format painter skinny a a Just take this data Make that blue selecting these items control shift down I'm going to make that blue and bordered here And so we have that by the way if I total this up equals the sum Of this or I can do it this way Alt equals Let's do that again alt equals It should come out to one Or uh 100 that's kind of a check number That we can have let's make that percent Here let's put this as a total Let's put an underline here home tab font group underline And then on the right let's put some blue around this stuff Going to home tab font group border blue. Let's take skinny double a Home tab paintbrush skinny ai put a skinny ai there And might as well check the spelling while we're here Spelling checky And it's good enough. All right