| Home |
| Search |
| Today's Posts |
|
#1
Posted to comp.apps.spreadsheets,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| generate unique random numbers | New Users to Excel | |||
| Generating Random Number from a set of numbers | Excel Discussion (Misc queries) | |||
| Random Numbers | Excel Worksheet Functions | |||
| generate random numbers | Excel Worksheet Functions | |||
Threaded Mode
