 divided by the total and then I want to copy that down so I'm going to say F4 so I can copy it down and then enter and then I will percentify that home tab numbers group percentified add a couple decimals possibly double clicking on the little fill handle copying it down so there's the percentages of the total so when we did our when we sat there with our stopwatch we counted for every one minute you know for a thousand one minute time intervals 62 times zero people showed up which is 6.2 percent 171 times one person showed up which is 17.1 percent 243 times out of a thousand minutes we sat there with our stopwatch 2243 showed up and then three people showed up 232 times which is 23.2 of the total and so on and so forth so now that we have our data then we can say okay well what if I was to plot this data you know what what would it look like if we were to plot it and notice I could plot either one of these so I could say let's take the actual numbers and I'll bring it down to here and so I'm gonna say let's say insert and then go to the charts and then I'm gonna make this a bar chart and we'll say bar chart and there it is so I've plotted the frequency and let's go into my data I'm gonna go into my data up top I'm in the chart design data and then the frequency looks good I'm gonna adjust this one however to pick up the range that I want which is from zero here down to the 29 control up I'm sorry control shift down shift up to pick up just down to 29 okay and then okay so so there we have it and I can look at that and say hmm I could see it you can see it's kind of skewed to the right here and it's got that distribution that looks like it might be you know a poisson distribution I can also do it this way with the percentages if I select all the percentages and I insert a bar chart right I can go hmm let's do this with the percentages and I'll do the same thing data tab this looks good I want to make the data over here on G3 control shift down shift up enter and okay right so you've got now you've got it in terms of percents versus the the whole numbers and so that's one indication that if we start looking at our data and say hmm that you know it looks kind of like it might fit a poisson distribution why might that be useful because the poisson distribution will allow me to have an even line that will allow me to make predictions more you know more easily because now I can stunt now I can make predictions based on you know a function as opposed to you know just randomly generated numbers right if this if I did this and it came up to some jagged landscape looking thing then I wouldn't be able to plot any kind of curve on top of it with a nice fairly relatively simple equation I know the poisson equation doesn't look you know really simple but it equates to a nice smooth line as opposed to you know a jagged landscape looking thing which would be much more difficult or a complicated type of thing you need calculates to do it right okay now I'm also I'm gonna move this to the right now I'm gonna move these to the right so that's gonna be an indication for us that we might be able to use poisson another if I I'm gonna make column J a little smaller and I could say okay what's the mean of the data so now I can calculate the mean now if I was to do a poisson curve then I'd have to know what the mean was remember that we took the mean in order to generate the data but in real life I wouldn't know the mean possibly and I would have I could guess it right I have an idea maybe but then I now I can calculate the mean based on this data right so now that we sat there with our stopwatch so I can say the mean is going to be equal to the average brackets of the data control shift down and enter so now we just took the average and if I add some decimals home tab number group adding some decimals