Home |
Search |
Today's Posts |
#1
|
|||
|
|||
binomial distribution
How do I generate observations using binomial distribution? Pls help.
|
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
how do i draw a distribution chart in excel | Charts and Charting in Excel | |||
bell-shape normal distribution curve | Charts and Charting in Excel | |||
Distribution Graph | New Users to Excel | |||
Forced Distribution | Excel Worksheet Functions |