Adynne wrote...
How do I generate observations using binomial distribution? Pls help.
N trials would require N separate cells. Each trial has an independen
probability of success of p, with 0 < p < 1. So if you want simulate
counts of successes, you'd need to enter the formula =RAND() in a
N-cell range named Trials , then generate your sample values using th
formula
=COUNTIF(Trials,"<="&p)
There's no way to do this in a single cell formula using only built-i
functions
