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. |
#2
Posted to comp.apps.spreadsheets,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generating random numbers with the occasional outlier
|
#4
Posted to comp.apps.spreadsheets,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generating random numbers with the occasional outlier
|
Reply |
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 |