Genrate random numbers using the binomial distribution

  • Thread starter Thread starter funkysunflower
  • Start date Start date
F

funkysunflower

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Uniform Random Number Generator 2
Random Generator in Excel? 4
binomial distribution 1
Random binomial numbers 2
Probability Distribution Library 1
How to Manipulate formula for Binomial Distribution 3
Binomial Tree 4
Generating random lognormally distributed numbers 1

Back
Top