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