Excel Statistics 74: Taking a Sample with RAND & VLOOKUP 

The "Hey" always cracks me up in the beginning of the videos.

This video is so awesome! I am a week behind in turning in an assignment all behind the Rand, and vlookup! You gave the most informative and simple explanation. Thank you...

Thank you. Video gives clear instructions. Very helpful .

You are welcome!

You are welcome!!

Search for and watch this video title: excelisfun Search for Excel Videos, Playlists & Download Workbooks Then go to the Playlists and find the playlist that has Randomzing Tricks. There a a few videos that show how to download and use the MRAND function - which is perfect for what you want.

It should be working now - RU-vid sometimes has problems, but usually within an hour or two it is working again.

Oh no!! I forgot to post it and I can't post it until i get back to work on Monday. If you go to my college web site and then go to Busn 210 and then to Chapter 7, you can find the file there. I can't post the link in a comment, but send me an e-mail and i will send link: excelisfun at my gmail account.

No because INT always goes down. The smallest number RAND can yield is something like 0.000000000000001 and the biggest 0.999999999999999. Since INT(0.000001) = 0, you must add 1. INT(RAND()*52+1) will yield 1 to 52.

Hello everyone, I want to ask something. I want to choose random values within certain range. For example, if i have a value 15, i want randome values between 12 and 15(i.e -3 to +3), in another row i have a value 30, i want random value between 27 and 33( i.e. -3 to +3). Can you tell the formula for this to select the random value of a certain number within the specified range..........

Dear ExcellsFun, thanks for all this nice material, so cool to have passionate people sharing their knowledge! I was wondering if by any chance there was a way to run a systematic random sampling automatically from a population's list instead of calculating a sampling step and applying it manually...? Thanks!

Hi Could please help me with an automation for extracting sample data from population data using vba

nicccce ! thanks

Mike - I can't find a workbook "Busn Class Ch07". There is "... Ch06" but not ".....Ch07". Can you check that??? Please :)

=INDIRECT("B"&RANDBETWEEN(1,52)) with repeat

I can't find a workbook "Busn Class Ch07". There is "....Ch06" but not "..Ch07". Can you check that??? Please :)