View Single Post
  #1   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

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. I hope I said that correctly.
If this is not possible in a spreadsheet can someone point me to a
software that can? Thank you.