funkysunflower -

You posted in the programming newsgroup, but your question seems to ask for
a spreadsheet solution instead of VBA code.

(1) For example, consider n=5 and p=0.3. In cell A1 enter
=IF(RAND()<0.3,1,0) and copy to cells A2:A5. In some other cell, enter
=SUM(A1:A5). Press F9 repeatedly.

(2) Alternatively, download the Tryout version of RiskSim from the Download
page at www.TreePlan.com, and use its RANDBINOMIAL function.

- Mike
http://www.MikeMiddleton.com


"funkysunflower" wrote in message
...
How can I generate random numbers using the binomial distribution and an
excel spreadsheet. If possible please do in a step-by-step guide.