 10 tests of a hundred. So now we can up. We can up it a lot. How can I do that kind of easily in Excel? There's different techniques. I'm gonna make this one a little bit skinnier. I'll make this skinnier I'm gonna put my formatting format by selecting all of this and go to the home tab font group borders I'll make them blue. That's just my normal thing and I'll do the same down. Let's pull these I'm gonna highlight these and cut them right click and cut Instead of copy and then right-click and paste that just moves them to the right So that I can see the average or mean and then home tab font group Brackets and blue on that all right, so so Let's also make a skinny V So one technique I could use I could say well let me just copy the entire thing that has my random generator over here and Then and I'll copy it over ten times and then I'll randomly generate ten sets of numbers and Then I'll go through and I'll I'll pick up and I'll cut off like the extra numbers So let me show what you what I mean what I'm trying to get at is to make one hundred I'm sorry to make ten tests of one hundred So I can take this is my random generator of the entire population. Let me copy those two I'm gonna copy L to M and then just simply right-click and Copy and then I'm saying I'm just gonna paste it as they are Ten times so I'm gonna put my cursor on on W right-click and Paste I hold on a sec. I copy it again. Let me do it again copy of these two and then put my cursor right-click and Paste just normal pasting and then I'm gonna do that ten times. There's one. I'm gonna do it on Z Control V or paste. There's two Over here control V or paste. I'm gonna use the clicks to control V three control V four control V five control V six control V seven control V eight control V nine and Control V ten. So now we've got our data. So now what I'm gonna do is I'm gonna I'm gonna make All of the center points smaller. So I've got these non adjacent cells. We're just practicing using Excel here I'm gonna put my cursor on Y hold down control put my cursor on a B Let go of control when you're moving around usually But I hold down control so I can select these non adjacent or not next to each other Columns, so I'll select this one holding down control this one holding down control holding down control now Notice I messed up because and if I do that it's not gonna work because now I got the cell in here So if I try to manipulate this column, they might not all manipulate together So I got to do it again. I'm gonna say okay. I messed up. Why hold down control hold down control I'm gonna select all these middle ones boom boom boom and then boom boom Boom and now when I make them skinny, they should all become the same skinny. We want them to be the same skinny All right, so there we have All of our random numbers. So now because these random numbers generate every time I Can just sort by whatever the random numbers on so that's 65 should change if I go from you know A to Z so I'm just gonna randomly sort these all of these from A to Z and they should randomly Sort up so I gotta do this 10 times So I think I'm on this one Anyone that has that 65 up top So there's that one changed This I think I changed this one So randomly sort each one So I'm on AU Randomly sort Randomly sort and Randomly sort Okay, so now now what I want to do is copy just the results and Then I'll paste them into a table. So I'll have my 10 result columns. So I'm gonna say all right I'm gonna put my cursor on On just the X the result. I'm gonna hold down control select the results Holding down control letting go of control as I move to the right So I can hold to control again and Select all of the columns letting go of control holding control again and then Control C or right-click and copy. So now I've copied even though they're not all next to each other When I paste them they will be all next to each other So I'm gonna put them in a in BE right-click and paste and Then I don't really need the table formatting. So I'm just gonna paste 1 2 3 and There and there we have it. So now we have all of our our data and I might call this, you know sample this will be Sam 1 tab Sam 2 and then Excel will be able to read that even though I have a Label in front of it. So I select those two cells put my cursor on the fill handle drag it to the right and So now Excel can see those I'm gonna make this a header I'm gonna instead of putting a table in I'm gonna go to the home tab font group drop down on the bucket and I usually make the headers black and white black and Then the labels white if I don't insert a table and then I'm gonna go to the centering Right there. So there we have it and then on this data What I want is it to go down to a hundred. So let's do a count here and I'll count this let's make this black white and Centered and I'll say this is simply going to be one two and so on I'll select those two put my cursor on the fill handle and drag it down and you can see it It's predicting the next number down to 100. So we'll bring that on down to a hundred So there we have it right there and Then everything beyond that I want to delete the data It's because we just wanted a random sample of a hundred. So I'm gonna copy. I'm gonna hold control I'm holding shift and selecting these you can do it this way Or you can use the keyboard and hold shit and then I'm gonna select control shift Down arrow and that takes me directly to the bottom number and then I simply want to delete all of that stuff So now we've got basically a random sample of our population, right? So this is just some how we can kind of practice with this stuff in Excel and Then if I if I select all this data, let's just format it like I normally do with the The blue so I'll select this thing and we'll go to the insert tab Home tab. I mean font borders and I'll make it blue All right, and then we'll and then we'll do our we can we can take our average of all of them average and I can take so I can look at each of these samples and see how close, you know, they line up to the