Thread: Generating random numbers with the occasional outlier
View Single Post
  #2   Report Post  
Posted to comp.apps.spreadsheets,microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
  
Posts: 418
Default Generating random numbers with the occasional outlier
wrote:
I can do this in excel
=RANDBETWEEN(120,160)
Is it possible to also occasionally generate numbers between 160-300
and 0-120? To use some stats lingo, I want the distribution between
120-160 to be 3 standard deviations with the remainder to be outside of
120-160.

Are you sure you want a uniform distribution over 120-160 and
"occassionally" a uniform distribution over 0-120 and 160-300
independently? From your request, I wonder if you really want a normal
distribution over 0-300.

Reply With QuoteReply With Quote