Random Number Generator

Roydboy · 04-08-2004, 05:47 PM

Would someone be kind enough to give me the formula to use with excel to generate a series of random numbers. I would like to generate a column or page of numbers between 0-100 as I want to use Cubedrum's scheduling and would like the computer to do the work.
Thanks anyone for your help.
Roy

vistaman44 · 04-08-2004, 07:04 PM

Roy, have you tried this?

http://www.random.org/nform.html

tim86432 · 04-08-2004, 07:28 PM

Ive been using this formula for the random numbers

=INT(RAND()*100)+1

Roydboy · 04-08-2004, 08:05 PM

Thank you gentlemen the formula works fine.
Thanks again,
Roy

Gunsmoke · 04-08-2004, 08:32 PM

If you have excel another option is turn on the Statistical Analysis tool pak under options and use:

=RANDBETWEEN(1,100)

cubedrum · 04-09-2004, 02:26 AM

Here's a great program that I use to generate random series of any size. http://3rdplanetsoftware.com/cubensi...ebout/dice.zip

Cube

mh2365 · 05-07-2004, 03:46 PM

Quote:

Originally posted by vistaman44
Roy, have you tried this?

http://www.random.org/nform.html

That's the one I usually use but it's been down the last day or two ... here's a backup

http://www.randomizer.org/form.htm

javier_83 · 05-07-2004, 09:46 PM

use excel

04-08-2004, 05:47 PM	#1 (permalink)
Roydboy Minors (Single A) Join Date: Jan 2004 Location: Long Island, NY Posts: 64	Random Number Generator Would someone be kind enough to give me the formula to use with excel to generate a series of random numbers. I would like to generate a column or page of numbers between 0-100 as I want to use Cubedrum's scheduling and would like the computer to do the work. Thanks anyone for your help. Roy

04-08-2004, 07:04 PM	#2 (permalink)
vistaman44 Hall Of Famer Join Date: Jul 2003 Location: Auxvasse, Mo. Posts: 3,143	Roy, have you tried this? http://www.random.org/nform.html __________________ ---Mark (vistaman44) "What lies behind us and what lies before us are small matters, compared to what lies within us." — Ralph Waldo Emerson, American essayist, philosopher and poet (1803-1882) ----------------------------------- Currently operating 1980s JM-HW, 1940s, African, 1980s LW and women's boxing universes

04-09-2004, 02:26 AM	#6 (permalink)
cubedrum All Star Reserve Join Date: Jan 2003 Posts: 877	Here's a great program that I use to generate random series of any size. http://3rdplanetsoftware.com/cubensi...ebout/dice.zip Cube __________________ "If you build a man a fire, he stays warm for one day. If you set a man on fire, he stays warm for the rest of his life" - Edgar Frog

05-07-2004, 09:46 PM	#8 (permalink)
javier_83 Hall Of Famer Join Date: Nov 2003 Posts: 2,369	use excel __________________ Unification World of Boxing Universal World of Boxing First Tbcb Forum Tournament

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

04-08-2004, 07:28 PM	#3 (permalink)
tim86432 Bat Boy Join Date: Mar 2003 Posts: 7	Ive been using this formula for the random numbers =INT(RAND()*100)+1

04-08-2004, 08:05 PM	#4 (permalink)
Roydboy Minors (Single A) Join Date: Jan 2004 Location: Long Island, NY Posts: 64	Thank you gentlemen the formula works fine. Thanks again, Roy

04-08-2004, 08:32 PM	#5 (permalink)
Gunsmoke All Star Reserve Join Date: Jun 2002 Posts: 945	If you have excel another option is turn on the Statistical Analysis tool pak under options and use: =RANDBETWEEN(1,100)