 around this. I'm going to just put a table around it by going to the insert tab, tables, and then we'll just add a table around it and say okay. So then I'm going to I'm going to make these two cells skinnier again. I didn't mean to widen the cells out like that with the table. All right, so now so to simulate a draw of a card if it was an even deck that has all 52 cards in it you don't have the card shark with an ace up their sleeve that they snuck in to the deck then you would expect that we could just do a random draw between 1 and 52 to simulate a random draw of the card. So I can then let's make a skinny zero here a skinny zero column and then I'm just gonna say this is a random draw of a of a fair deck that we're trying to simulate. So I'm gonna go then to the home tab font group make this black white alignment group wrapping it and then alignment group centering it. So I'm gonna use my random number generator again. I'm gonna say rand between and I want to take it between 1 comma 52. So we're just gonna get a random number between 1 and 52. Enter there we have it. Now the question is well how far down do we want to go now we have it we're in Excel here so we can do this for quite some time so let's let's imagine that we did this a whole lot of time so let's take it down to like thousands of draws just for the fun of it. So we're gonna go into like I'm gonna drag it down to let's say like 3,000 I'm sorry let's say let's keep it down here I went to 5,000 that seems a little much. Let's just we'll keep it 5,000 instead of 5,002. I'll see if I can go up to just 5,000 5,001 because I think we started on cell number two. So a whole lot of random drawing happening here so I'm gonna go back up and so that would obviously take a lot of time in real life but our generator can do that and so then I can go into the insert tab and let's put just a table around it and it'll grab the whole table all the way down to cell 5,001 and then okay so now we've got a random generator so we've got a random generator and if I double click on it it should reshuffle or I can like re-sort it and it'll reshuffle as I re-sort it. So now let's just mimic one one of those random samples of you know the 5,000 draws that we drew one card at a time so I'm gonna copy this whole thing I'm gonna right click and copy and I'm gonna put it in column R but paste it just one two three so it just grabs those numbers and solidifies them to just one number. Let's go ahead and put a table around this one, insert and then tables and insert a table so here's our result of the first random draw and I'm gonna make this home tab alignment wrap center and there we've there we go so now we can sort that we could sort this you know a to z or z to a if we so choose and we can see all the ones all the twos and whatnot but there's a lot of draws there so we could then we could then try to come up with a table showing how many times each of those cards were drawn and see if that kind of lines up to what we would expect and how far off we are and so on. Let's make a skinny Q column to do that I'm gonna make a skinny S column and so let's say that we have our table again with our assigned number let's start off by just copying the table we did over here right let's copy the table we did over here where we had these three our assigned number let's copy this stuff from L to N I'm just gonna copy the whole column and we'll bring that on over here and I'll paste it in column T pasting it the suits got messed up because I used a formula to get the suits so let's just say the suits let's just type it in here this is going to be spades well let's do this let's hard code the suits so I'm going to go over here and I'm going to copy this whole thing and instead of pasting a formula I'm gonna right-click and paste it one two three so now the suits are hard coded and there's no formula in there okay so there we have that and then I'm gonna say the so these are our our results results from the five thousand and one or five thousand draws that we had so let's do a count of the results so now I'd like to do a count function and I'd like to say I want you to count it if it's a number one so however many times the number one shows up here that's what I want the result to be the number one standing for the ace of spades so I'm going to use our trusty count formula count if brackets and then I'm going to say the range is the first criteria selecting the entire range that should pick up the entire range of the table comma and then the criteria is this number one not the card number because that repeats I want the number that we assigned that has an individual a number per card so it picked up and notice it copied the reference all the way down for us because we're in a table so that's great that's what we wanted to do and so there there's our results so we've got it has seventy nine ones one hundred of the twos of spades spades right and then the count of 28 which represents a two of diamonds ninety of those and so on so if I then I can add to the bottom of the table a total right we'd like to have a total down here so let's go up top and to do that with a table I can go to the table design I can go to the table style options and let's add a total column so there's our total and then when it counts this up it comes out to five thousand and that's correct because that's how many times that's how many how many of these we did how many times we drew one particular card out of the deck of fifty two five thousand times alright so now we can get a percent a percent of total so so how often is that from a percentage basis common calculation when we're doing our statistics it's going to be equal to seventy nine divided by the total which is five thousand enter it copies it down I can't see anything because the cells are not in the format of a percent so I'll select the whole thing home tab numbers percentifying it I can add a couple decimals to it and then if I scroll down we can see that it should sum up I'll choose my table options to summit it should come out to you know a hundred percent number