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
How can I generate random numbers using the binomial distribution and an
excel spreadsheet. If possible please do in a step-by-step guide.
