 not exactly a whole number or something like that because it's not picking up all the numbers which either means that it's not picking up one of these numbers or that there's some numbers that are actually higher than 100 so we could use a formula to try to make these all all exactly rounded numbers but I find the other way we could do this I'm going to delete this data is to use the frequency which is a still array formula instead so the frequency equals the frequency tab and then we want the data array which is going to be here I'm in d2 control shift I'm holding control shift down arrow takes me to the bottom then I'm going to hold down control and backspace to bring me back up and then comma the next argument are the bends which are going to be these bends it's going to look for these bends control shift down and then again control backspace to bring me back to the top closing it up and entering it spills it now so now we have a spill array uh type of system I'm going to try to remove that last bit so it doesn't do that last one double clicking up top and say what if I clip it at 101 will it then stop that it does and now let's do the total which will be alt equals there's 500 so now I picked up all 500 of them and put them into the relevant bends which is nice let's make this a header I'm going to go to the home tab and say this is going to be black and white and then we can center it so now I could graph this frequency right so I could say let's take this frequency control shift down control uh well hold on a second whoa caposso control shift down I don't want the total though all right I'm just going to select the whole thing and then I'm going to insert let's go to the insert over here and we'll say that I'm going to insert a chart let's make it a bar chart for the frequency so there's what we have on the bar chart let's click into the chart chart design I'm going to the data up top so the data is good I want to edit this side however to pick up my bends on the left so it picks up my bends and not just some generic bends control shift down and then uh shift up so it doesn't shift up so it doesn't pick up the total and then enter okay and okay so there we have our distribution and you can see it's a little choppy here we don't have as much data but it looks like it might be conforming to uh you know the poisson type of distribution so it's it's not going to be perfect because there's still randomness involved in it but if we can approximate what is happening here with the poisson distribution then we might be able to use that now I can also do the percent of the total percent of total let's make this format paint home tab format painter here I'm going to take each of these numbers and say equals the frequency divided by the total 500 I'm going to make that second number absolute because I want to take each number divided by the total so I can say f4 and enter and then I'm going to make it a percent home tab numbers percentifying it and then double click on that copying it's down and if I then double check that everything is done properly I'm going to delete this total and sum it up for the double check and it should come out to 100 which is going to be alt equals we'll give us that some function nice and easy there's the 100 so I could make my frequency my chart using this column as well so I can select a this column and I could say okay let's make our chart based on that insert and then charts bar chart boom bar chart boom let's do some formatting while I'm here on it data are this side I want to make sure that this is picking up our bends shift up and okay so so then we get the same kind of look and feel but now on the percent basis as opposed to the whole number of bases alright so then let's do let's take the a couple stats on our data I'm going to make a skinny eye here make a skinny eye and then we're going to say that this is going to be the mean calculation so I can take the mean calculation of our data so I'll say this equals the average shift nine go into our data the whole data set and control and control shift down arrow and enter so now we've got it the mean being 20 I'm going to add some decimals it's not exactly 20 because remember we used the mean as a condition to populate the data but there's still randomness in the data that we populated so the mean of the actual data that we have is more like 20.14 potholes per 100 miles and then we can calculate the variance let's do the variance with a p so it equals the variance and we'll take the variance of all of our data set control shift down and enter and let's add some decimals there and you can see it's pretty close to the mean and that's another indication that we might have something that would be we can represent abstractly with a poisson distribution here's the variance if it was a sample equals the variance s of our data and we'll add that a little bit more here so then we've got 1952 so you could see these so now if we're looking at this data we're saying okay so now we're talking about something that might conform to a poisson distribution because we have something that's happening over a certain not time element but space in in terms of the road we would think that each instance of the pothole would be independent from other instances of the pothole and so on and so forth and when i graph it it looks kind of like a poisson distribution possibly could fit that and when i pick up the variance and the mean of the data they're pretty close to each other which means that we might benefit from making predictions based on the poisson distribution curve into the future right so next time what we'll do is we'll then do the poisson distribution which will be a more perfect curve and and do some comparisons and see how how well that relates to our actual data that we populated and then think about well will will will that poisson distribution then be useful to make predictions uh as we extrapolate this information into the future for decision making