Thread: Generate 1 or 0 in xls with input probability
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
plinius plinius is offline
external usenet poster
  
Posts: 51
Default 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 With QuoteReply With Quote