Menu

Generating random numbers with the occasional outlier

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to comp.apps.spreadsheets,microsoft.public.excel.worksheet.functions

[email protected] utsuxs@hotmail.com is offline

utsuxs@hotmail.com is offline

external usenet poster

Posts: 2

Default

Generating random numbers with the occasional outlier

wrote:
I don't know what the statistical implications are of this solution,
but it will give you a random number between 120 and 160 with the
occasional random number between 160 and 300.

=if(RANDBETWEEN(1,1000)<2,RANDBETWEEN(160,300),RAN DBETWEEN(120,160))

Thanks.
Wasn't looking for a uniform distribution. Just needed a random number
generator using software I already have and know how to use.

Reply With Quote

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Seed numbers for random number generation, uniform distribution	darebo	Excel Discussion (Misc queries)	3	April 21st 23 09:02 PM
generate unique random numbers	Stephen Larivee	New Users to Excel	7	March 29th 06 01:04 AM
Generating Random Number from a set of numbers	CalsLib	Excel Discussion (Misc queries)	3	March 17th 06 04:27 PM
Random Numbers	anuterrnd	Excel Worksheet Functions	1	July 22nd 05 05:32 AM
generate random numbers	Jules	Excel Worksheet Functions	6	November 2nd 04 05:57 PM

All times are GMT +1. The time now is 07:45 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement