 and scroll on up so the average of the sample that we have taken is uh... two thousand one seventy four you'll recall that the average of the entire population two thousand one eighty nine so so that so there's our comparison and we could compare of course each data point that we got you know compared to to you know the average so let's take the bottom number here the average and I'm going to copy that all the way across to the right to our seventy five samples of twenty so there's our averages for the whole set of samples that we took and then let's take this entire thing i'm gonna make it blue so i'm gonna go up top and say let's make that drop-down blue white bordered and then i'm gonna i'd like to see that in a vertical format so i'm gonna do what we've seen in the past to take this whole thing and then paste it in a vertical format so i'm gonna copy this put it in a column in other words control c or copy scrolling up i'm gonna put it we put the wrong button put it right here in d i d right click i lost it now because i fumbled around i fumbled fumbled let's copy it again alter a copy alter a vase another time once again porfavor right click and copy copy that copy that roger roger and then we're gonna paste that in d right click and paste it let's do it one two three and then i'm gonna copy again right click and copy and then paste it over here and d g and pasted special because we want to transpose transposed make it into a column if you would and and excels like okay and then it does it no problem no problem says excel if we can do that without a problem so let's make this into a table i can say insert tables let's make a table boom so there's our averages and uh... and and we can compare the the average to to what we had for the expected or actual or population average right the population average was equal to i'm gonna scroll all the way to the left to pick up that original average that we came up to two thousand one eighty nine so there's the population average and i'm gonna say double click on this one i'm gonna uh... make it absolute by selecting f four dollar sign before the e and the one to pull that all the way down this is the difference from the average of all those and so this is going to be equal to this minus this so there's the difference all the way down we could make a total column down here in a table you can do that by going to the table tools and total row and then on this column i would like it to give me the average of the averages which is uh... which is that pretty close right and then i can for this one i want the some which is doing of the differences so that's that's that i'm gonna make this a little bit smaller now you could you could take a histogram then of our samples to see what what each sample kind of looks like in terms of the of the data so for example i could go into my sample data here for seventy five and insert uh... charts a histogram now we only took seventy five so the histogram you know it's somewhat limited in the data but here's our histogram of seventy five and we could change the buckets if we want to to maybe add more buckets like five buckets uh... and so there's our histogram with five buckets we can compare that to the data for seventy four so i could take the data for seventy four and insert if we so choose a histogram and we can compare the results on seventy four putting this down here i'm gonna just call this seventy four and we can then take a look at our buckets change that i think we did five buckets red have five buckets on this one so there's a you know different data sets for the randomly generated data mapped out with a histogram let's do one more seventy three and insert charts histogram his his histogram histogram it's hissing at me like a cat and then this is going to be i don't know why i had to say that i don't know histogram we're going to say let's make this one into number of buckets five so they all have five buckets so so we can compare you know the samples data that we have and we can also make a histogram if we wanted to of the averages uh... of all the samples because we took seventy five samples so i could then take take these results if we wanted to uh... and then make a histogram of that insert uh... uh... his togram i should have moved up before i did it now you gotta move it up uh... it's not too bad i thought it was gonna be more tedious than that okay so this is going to be the the samples samples let's just say and that has you know five buckets so so so there's just a different kind of tool that we can basically use for the shuffling tool and how we can generator our random data uh... samples and use that of course to create our histograms of the sample data that we have chosen per sample or possibly of the averages of all you know that the average sample data