binomial distribution
 

How do I generate observations using binomial distribution? Pls help.

Adynne wrote...
How do I generate observations using binomial distribution? Pls help.

N trials would require N separate cells. Each trial has an independent
probability of success of p, with 0 < p < 1. So if you want simulated
counts of successes, you'd need to enter the formula =RAND() in an
N-cell range named Trials , then generate your sample values using the
formula

=COUNTIF(Trials,"<="&p)

There's no way to do this in a single cell formula using only built-in
functions.


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=275794