Thread: Generating random numbers with the occasional outlier
View Single Post
  #4   Report Post  
Posted to comp.apps.spreadsheets,microsoft.public.excel.worksheet.functions
[email protected] 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 QuoteReply With Quote