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.
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...
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.
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.
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!
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..........
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.
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...
The "Hey" always cracks me up in the beginning of the videos.
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.
Thank you. Video gives clear instructions. Very helpful .
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.
You are welcome!
You are welcome!!
It should be working now - UA-cam sometimes has problems, but usually within an hour or two it is working again.
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!
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..........
Hi Could please help me with an automation for extracting sample data from population data using vba
Mike - I can't find a workbook "Busn Class Ch07". There is "... Ch06" but not ".....Ch07". Can you check that??? Please :)
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
nicccce !
thanks