 right. Imagine that we flip it 12 times. Copy to the right. Imagine we flip it 13 times. Copy to the right two more times and say that we're going to flip it 14 times and then copy to the right one more time and then we have to stop these good times of copying and say that we flip it 15 times. So there's our random generation tests going from one. I'm going to put my cursor on these two and drag it to the right and it should be able to pick up the test numbers going from test one to 14. I'm going to select all of these, make that into a border by going to the home tab font group and I'll make it black and white which is typically what I do with the borders and let's center it and then I'm going to go back to the left and I'm going to select all of my information here and put my blue and borders around it. Now this is just my test range so what I'd like to do is just copy this whole thing and then I'm just going to paste it 123 so that this thing will reshuffle anytime I want to kind of reshuffle it. I can go in here and reshuffle everything and then it'll and then I can come and copy it again. So let's go ahead and copy this thing and copy the whole thing and then go to the to the left and I'm going to paste it 123 just the values. Now I don't want the formulas but I also want the formatting so I could right click and paste the formatting so I've pasted the values in the formatting but not the formulas so I get this mimicking of the table which now gives us our results right and I can go down here and say okay well let's take a look at the heads so I'm going to use my count if function again so I'm going to say equals count if brackets and then I'm going to take the range here down to here and then comma and I'm going to say count if it's uh if uh there's the range and the criteria if it's a one so count it if it's a one and then brackets enter and there are zero this time that is a that is a one notice with these first two tests we've got two tests they came out completely tails right which is could happen because we only flipped it a few times and then if I copy this to the right now I've got one and two so I'm going to copy this all the way to the right and so there we have it and then we're going to say tails so I could do the same thing count if brackets I'm picking up the entire range because I want to be able to copy it across I'm not just going to pick up those two because I want to copy it across count if comma it's a number two and then close it up and so there it is and here's the total then which is the sum of these two which means we only ran two tests this time time so I can underline this and then I can say these are my percent heads versus the percent tails so the percent heads would be equal to zero over two zero and the percent tails would be two over two hold on a sec equals two over two and then the percent total which is going to be equal to the sum of these two percents so I'm going to make all of these percents home tab numbers percentifying them so there's our percents and I could put an underline here so there we have it in our first flip we had zero heads two tails and so total tails and so we've got a zero percent heads and a hundred percent tails so let's copy that across putting my cursor on the and copying across and you can see of course the idea would be that if we have more flips then you would think we would get closer to the to a better result so I'm going to go to the to the home tab font group and make this blue this time for my totals blue and white let's but let's put some borders around it too for the fun of it put some borders around it so the idea here being that with two flips is probably not going to be enough with an infinite number of flips right of the population and and so we could come up with some skewed results of you know here's two to that all three hit tails here which is kind of unusual and then here we've got the tails are just doing quite well we've got 25 percent tails 75 head because one out of four versus three out of four five flips so now we have two tails three so that one looks at least a little bit more accurate notice this one we flipped all heads came up this time which is kind of unusual even though we flipped it six times right so that's kind of weird and then you got four and three this one actually came out exactly 50 50 and you would expect that if you get more flips you would get closer uh you know on average however not it's not always going to be closer than like this one we flipped it uh less amount of times 14 versus 15 and the 14 came out to what we would think is actual population 15 is off so then if you if you use a random generating tool like this you can then go in here and basically reshuffle everything right i can go in here and say let's do a reshuffle reshuffle make sure that we get every column on the reshuffle it might be better to put a table in here to make sure everything is shuffling let's actually do that let's insert a table make it into a table and then when i reshuffle each column everything should shuffle up and then hopefully that all shuffled up and then we could take you know all of our numbers that were randomly generated hopefully copy them and paste them into our table over here but paste them formats only one two three and so now we've got a different set of numbers now we're on two that came up heads and then now we've got two two and three so there's just a a nice tool to be able to kind of simulate our our results with the random with the randomness i'm going to make this a little bit thinner and we'll stop it here and continue on with some more testing next time