Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Genrate random numbers using the binomial distribution
How can I generate random numbers using the binomial distribution and an
excel spreadsheet. If possible please do in a step-by-step guide. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Genrate random numbers using the binomial distribution
Hi funkysunflower
How about a video http://tinyurl.com/yj69stn or Google links http://www.google.ca/#hl=en&q=binomi...076c90c9 4111 HTH John "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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Genrate random numbers using the binomial distribution
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
random numbers but normal distribution | Excel Programming | |||
How to Manipulate formula for Binomial Distribution | Excel Worksheet Functions | |||
binomial distribution | Excel Programming | |||
Plotting a binomial distribution formulae in excel? | Excel Worksheet Functions | |||
binomial distribution | Excel Worksheet Functions |