 we've done this a little bit in the past so I'm going to say all right there's our calculation let's go to the home tab font group underline that and so this is the odds of any suit this is equal to up to 13 divided by up arrow 152 I'm then going to make this cell a percent by going to the home tab number group percentifying it that's not a real word but I like using it some people it upsets them but you get 25 percent I think it's fun I think it's I think it's a term that should be introduced to the dictionary and I should get credit for advancing human kinds understanding through language but in the case that I'm also going to indent this home tab alignment indent and then I'll select these so notice this is a nice way that we can go home tab alignment indent oftentimes when I have the subtotal you put a colon at the end of it to show the indentation and sometimes you might even I'm going to make this little wider double indent the answer right alignment indent so now you've got you know this nice little formatting I'll underline this one too that shows shows everything we need there so that's the odds of any suit and then I could take I could take the odds odds of any number any suit so any one number any one number in any suit in other words I could get an ace in either spades hearts clubs diamonds or clubs right so any I can get I have four out of out of 52 chances every time I draw a card to draw a ace a two a three a four and so on so we can once again say number of card cards of each number are equal to four right and I can say then compare compare that to the cards in the deck equals 52 let's put an underline here home tab font group underline and do our odds I'll just say odds equals four over 52 we'll make that a percent home tab numbers percentifying it add a couple decimals so about seven point six nine note that excel actually even though I'm rounding it here remember that excel doesn't actually round it if I was to use this number in another calculation in other words if I said I want to take this cell times 100 it's not really multiplying it times 100 times seven point six nine two but rather it's multiplying by the full decimal it's only that it's only rounding to the point that you can see that's really important otherwise you'll get a little bit confused like if I just took seven times a hundred uh or or now it's eight times a hundred and I get eight but I add some decimals it's like wait a sec something went wrong here it should be eight and it's seven point six nine that's because it's multiplying by the whole number here even though you can only see see how many decimals that you are showing all right let's indent these the same way home tab alignment indent I'll indent this one home tab alignment indent I'll make these blue and bordered as is our tradition so I'm going to select the first cells home tab font group border it and then bucket add in the blue same here I'm going to say border blue and then this one let's make this border uh blue the blue and border okay so so now we're we're going to say okay well how can I simulate that and excel I'd like to run an experiment where I basically can mimic uh pulling a card from the deck but I can't really do it because all of because I don't have an individual value for each of these cards unless I call it you know one of spades or something I would like an individual numerical value for each card well okay so now let's let's try to assign each card a numerical value so I'm going to then make k small I'll make a skinny k and say all right here's our issue here's the here's the assigned number I'll say assigned number and notice I'm over the cells but I'm not going to worry about it because I can type over here I'm going to say this is the card number and this is the suit okay so what I'm going to do is center these in format then selecting the top three home tab font group uh let's actually go to the alignment first and wrap the text center them I'm going to make them a header but by going to the font group bucket black and white all right now the the card numbers that I have I've got one two and so on selecting those cards and copying down until I get to 13 so I've got 13 cards and they're of the suit let's just pick this suit I'm going to say equals because that's the easy thing to do because I'll just pull the suit from over here equals c1 so I just pulled it over equal c1 instead of typing it again and on the second one I'm going to say this equals the one above it that's a useful little formula because then I can I can select this cell and copy it down the other method you could use is to make an absolute reference but notice I can copy that down so I've got one through 13 states these last three representing the jack queen king and then I've got starting over again one two I'm going to select those two cards copy them down to 13 and these are going to be the next suit I'm going to say equals to pull that suit over left arrow scrolling up to the top I want to pick up the hearts that's the next one I had in line or at hearts and then in the cell below it I'm going to say equals up arrow the hearts above it and then simply put my cursor on that cell fill handle drag it down dragging it down so then we have one two again to 13 selecting those two so I can do the auto fill bringing it on down to 13 and these are going to be equal to in in 25 I'm going to say equals instead of typing it in less likely to misspell it multiple times I'll just pull in the one misspelled one diamonds diamonds and then we're going to say this equals the one above it and copy that down and then we'll do this one more time of course for the last suit and we just put these suits in random order this you could put them in any order you want this but this is the order we're going to choose once they're in order then you got to stick to it so the last one is the clubs so I'm going to say equals why you got to put the clubs last huh huh huh I don't know I just there's no reason I just randomly put them in clubs you got to put the clubs on the bottom is that what okay I just here we go so here and then I'm just going to assign a number so now I'm going to assign them a number from one to 52 instead of saying they're going to be from one to 13 and then assign each suit I'm just going to say the number we're going to give them is just going to be one two grabbing those two and fill handle them down to uh 52 cards so there it is boom all right so then so now I've just assigned these out so you can see down here like this 11 or if I go into the diamonds this five of diamonds is being represented by a 31 in our in our numbering scheme so that I can then set up a random selection between one and 52 each number representing a separate card so let's put a