Posted to microsoft.public.excel.worksheet.functions

plinius

external usenet poster

Posts: 51

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User Input to Generate ListBox Range	TesterEd	Excel Programming	0	July 31st 12 02:17 PM
Generate random sequence based on probability	James R[_2_]	Excel Discussion (Misc queries)	5	December 19th 09 01:46 PM
Probability	roystonteo via OfficeKB.com	Excel Discussion (Misc queries)	3	February 5th 09 07:18 PM
Probability	Dennis	Excel Discussion (Misc queries)	6	October 31st 06 09:16 PM
generate a random number and use if function to generate new data	Dogdoc1142	Excel Worksheet Functions	4	April 26th 06 03:44 AM

All times are GMT +1. The time now is 06:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us