 F4 on the keyboard, dollar sign before the B and the two, and then close it up. So it's a little bit of a complicated formula there, but again, this is kind of our random number generator tool to simulate us out there with our stopwatch trying to see the intervals between customers, right? So if I hit enter, there it goes. So I'm going to add some decimals, home tab, number group, decimals, decimalizing it. I want it to be positive, so I'm going to double click on it again and before the whole thing I'm just going to put a negative, which will basically multiply the whole thing times negative one, enter, and so now we get a positive number. I'm going to double click the fill handle to just copy it down, and there we have it. So we've got our randomly generated numbers simulating us out there just counting how long it takes, the intervals and minutes between customers coming in. Now if you look at this, notice what kind of happens. This is kind of the key to kind of understanding why the curve is this way with a line waiting situation. The first one we have 22, which is quite long. But then we had only one minute, five minutes, seven minutes, one minute, less than a minute, three minutes, five minutes, one minute, and then eight minutes fairly long. So notice you have what ends up happening with these line waiting situations is you have some of these long waiting situations intermixed with a lot of shorter wait situations is often what you end up with, and that's what's going to give us our common exponential kind of curve that we will be generating. So notice this is going to regenerate because I have that random number generator. So what I want to do is copy this whole thing because this is my generator and then paste it 123 so it's not going to keep on trying to regenerate the numbers. So I'm going to put my cursor on D and E. I'm going to right click and copy those and then I'm going to paste them in column G right click but paste it 123 so we just have the numbers. I can also paste the formula I mean the format without the formulas right click and paste the formatting so that I get those header formatting. I'll make column F a little bit skinnier. So there we have that I'll make column C a little skinnier. And then if I took the average of these arrival times I should get to around you know that six over here so I'm going to say then my average or my mean of my data is going to be equal to the average brackets. I'm going to put my cursor here control shift down taking the whole average enter and if I add some decimals home tab number group so you can see that the that the average we get is around six although it's kind of all over the place and we have some of those high numbers and a lot of a lot of the lower numbers right we got this twenty six eighty one up here and then a lot of these lower numbers that's often kind of the case you'll have in like a line waiting type of situation. So now let's let's we could take a histogram of this and see what it would look like. So if I for example take my data here control shift down and I'm going to then control backspace and go back to the top and I insert say charts and a histogram. Now we've got our our chart. I'm going to call the chart equal to enter arrival times let's say or it won't let me do it this way in a histogram enter arrival times. So I let it I let it choose the boxes down below. So we've got you know point oh two to three point oh two and three point oh two to six and so on and so forth and you can see what we end up having here is that most most of them are grouped up in the lower range not a whole lot of wait time but we have a few that are way out here at twenty one and twenty four minutes and some that are even further out which which is kind of what's so that's kind of giving us our characteristic exponential distribution look here so this you and if we look at this we're saying how that looks kind of like an exponential curve. So let's let's then try to do this with bends this time so I'm going to make column I a little bit skinnier and let's put our bends together and do this in a manual way and I'm going to use our frequency to do that and this is going to be the frequency let's make these to home tab font group black white let's put let's wrap it let's center it and let's say that our bends are going to go up to like to like I don't know let's say let's say thirty five so I'm going to say from bends of zero one to I'm going to copy this down to let's say thirty five let's go to forty let's go to forty we'll take the bends up to forty so and then we'll and then I'm going to do my frequency now I'm trying to see how many times and this and this data set these numbers are showing up but notice they're not even so I want to use a frequency which is going to kind of simulate the the bends the bends up to a certain rate it has a range to it right so I'm going to use my equals frequency tab the data array that I want to be picking up is going to be then this data control shift down and then control backspace to get back up and then comma and the bends that I want are these bends so control shift down and control backspace to get back up and there's my my spill array frequency enter and so there we have it so now we're going to say that that one and this is going up to and including one I believe we talked about the bends you know how these happen and how these work in a prior presentation we have fifty one there and then to we've got the thirty and then three we've got the thirty one and so on and so forth now I can also look at the let's take a look at the total total these bends up so if I go down to the bottom I want to get rid of this last bend down here so I'm going to go into this one and say take that to forty one get rid of that last bend and then I'm going to say the total is going to be alt equals summing that up gets to three hundred that makes sense because I had a count of three hundred here so it looks like it at least picked up all the numbers so that's good so then we're going to say one more column which I'm going to call it the percent of the total and I'm going to make that black white wrap it center it and I'm going to take each of these results the zero divided by the total down here the three hundred I'm going to F for absolute reference dollars seven