| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Generate 1 or 0 in xls with input probability
I have a list of binomial probabilities (several events with potential outcomes 1/)), and I need to run multiple simulations of potential outcomes. Is there any xls function that can help me?
|
|
#2
|
|||
|
|||
|
Quote:
If so, would =RANDBETWEEN(0,1) copied down for the requisite number do the trick for you? Although not truly random, it's as close as Excel is going to get. If I've completely missed the point of what you're trying to achieve (which happens!) perhaps you coud explain your need a little more... Last edited by Spencer101 : November 2nd 12 at 08:01 AM |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Generate 1 or 0 in xls with input probability
Il 02/11/2012 02:39, Morinne ha scritto:
I have a list of binomial probabilities (several events with potential outcomes 1/)), and I need to run multiple simulations of potential outcomes. Is there any xls function that can help me? Your probabilities in A1:A100 In B1 =IF(RAND()<A1,1,0) and copy down E. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Input to Generate ListBox Range | Excel Programming | |||
| Generate random sequence based on probability | Excel Discussion (Misc queries) | |||
| Probability | Excel Discussion (Misc queries) | |||
| Probability | Excel Discussion (Misc queries) | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
Linear Mode
