 those to the actual and again we would expect some of the averages to be of above and below they're not going to be exact even though we took as large or sample from 10 to a hundred this time but we would expect that they would approximate closer towards you know a middle a middle point with this kind of spread this type of data so if I select this and let's put our our tools around now notice you might also let's insert another column I'm going to insert a column between BP and BQ so I'm going to do that to insert an entire column it always inserts to the left so if I select BQ the entire column right click on the selected and insert it will insert a column to the left now you got to be careful of doing that if there's anything below it that's going to be messed up but there's nothing below here so that's the easiest way to kind of move this stuff to the right so the other way if there was something below then if I undo that hold on a second it's thinking if I undo that if there was something like below here I can select just these items I can pull it to the right like this or I could I could cut right click and cut which is more efficient and pasted to the right like that or one more time I could select these cells and then I want to shift these to the right by right clicking let's it's now I got to get rid of the dancing ants so I'm going to double-click select these cells right click and insert and then I can say I want to shift them not down but rather to the right so then I can shift them to the right so a bunch of different ways you can do the same thing which will be useful depending on whether there's data to the bottom or to the right of it for example so then I could say let's take the average of the averages right I could say why did I took the 100 tests and I got the average for each test let's take the average of the averages and so that gives us the the 6799 which is which is pretty which is like right on basically you know we can add more decimals because this is all this is actually longer decimals than two so it's not going to be perfect but you know you get you get pretty close with that because that's pretty that's a lot that you know that we kind of come so let's make this font group and brackets and put some borders around this and then now of course if you wanted to you can also insert histograms from this information we could make like 11 histograms for each of the data sets of a hundred data points we could make a histogram as well of the averages of the results but there's only 11 of them so that might not be enough data to do that but you know if you chose like the entire sample let's say sample 11 here and I'm going to hold down control shift down to the bottom and then I'm holding down shift to not pick up the total so that I and then I scroll up so I just want to go down to 101 not 102 and then I'm going to hold down control backspace taking me back to the top I know I'm using a lot of key strokes here but I'm just trying to point out that if you have a large set of data that's going to be more efficient than then like scrolling down and then scrolling up although you can do either one even with a hundred data points it's not too bad to scroll down but when you get really large data sets then it's useful to use the keys strokes so then we can go to the insert and we can go to the charts and insert a histogram so now you've got a histogram of that last sample man I deleted the of that last sample so you could you could see it kind of approximates the actual histogram right here's the actual you could say here's the actual histogram and then here's our sample that last sample of 100 so it might be let's let's put the sample of a hundred if I did a couple of these let's say we did number 10 control I'm putting my control shift down shift up and then control backspace and then I'm going to put this one next to it over here insert charts histogram boom so here's here's another one of sample 10 so right so and then let's just make one more as you get an idea we got a different spreads of the data of a hundred shift down and and shift up and then control backspace and then I'm gonna scroll to the right shift to the Lou scroll to the right and then skip to the Lou and then scroll to the right that's a song skip to the Lou my darling I'm not sure what the Lou I think that's a instrument but whatever then we're gonna go to the insert tab and then charts drop down histogram and so here's another histogram and so you can get an idea of you know when I when I when I pull these what's the spread of each of these of the of each of these samples of of a hundred and and notice one of the questions we come to is well how close are two way to the center point that's what we've been looking at and also you know what is the characteristic shape of the spread also kind of similar to the actual data set that's another kind of question that we would like to be able to know and it can help us to then also think about how confident we are that like the actual center point and and the distance you know the distances between them is is is correct which we'll get into more technically later but for now we want to just practice using our Excel tools as well to kind of think about how we can create some of these random samples and manipulate some of the data and then and then do our calculations on them